-
- Excel user form to select a favourite file
by UK089669
- 2 Replies
- Last post
by Andy Pope
- I am trying to use a custom form for the first time and would like to select an excel file from the normal "File _ Save As..." window and once selected, save the path and filename into cell A1 of a spreadsheet called "My Toobar.xls".
This will then allow the user to open this "favourite" file very quickly.
Can anyone help me get this Windows "File _ Save As
-
- subscript out of range
by Derek at Potters Clay
- 5 Replies
- Last post
by Andy Pope
- I am getting an error when running the script
Do While (Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "dsl") Or Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "hsi"))
I am uncertain why this is coming up. i is currently set to 1, so it should be starting to search in cell a1.
-
- Conditional Formatting Problem/Bug?
by FaV1105
- 8 Replies
- Last post
by FaV1105
- This is my first time in a forum. I have mostly found all the answers I could but I can't seem to find the answer for this:
I don't know if this is a bug in excel or if I am doing something wrong.
I start a new Excel application from another workbook and apply a conditional format that uses an array formula for its condition (I have read that conditional formatting always formulates
-
- API and OpenGL in VBA for Excel
by Spinor
- 7 Replies
- Last post
by @sanya
- How to use in VBA for Excel such API functions like, SetPixel, GetPixel, LineTo, PolyLine or ArcTo acting on the new created standard UserForm or in the special new window opened by appropriate API function. I know that it is trivial within VB applications, whereas VBA makes troubles (handle address of UserForm). I would be grateful for some simple examples (which have been tested and work well).
-
- sending emails from MS Word with variable subject line
by gve2002
- 9 Replies
- Last post
by Andy_F
- Hi,
I've searched these forums but have not been able to find exactly what I need.
I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code ( .Subject = "New subject" )
What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in
-
- Inserting Excel Data into Word Report with VBA
by Deserthawk
- 2 Replies
- Last post
by Deserthawk
- Hello,
I am trying to find a way to open up an existing word document and place excel data into the document at predetermined locations. Can anyone get me started in the right direction
Thanks,
Deserthawk
-
- how to make Icons in LISTBOX and not in list view
by Mohamed Sami
- 0 Replies
- Last post
by Mohamed Sami
- hey can anyone help me on this
C# help
-
- Heap dump (dmp) in cabinet file
by paso
- 5 Replies
- Last post
by Jason Hardester - MSFT
- I have configured the error reporting so that the reports are stored on a shared volume iso being sent to Microsoft.
When the crash occurs I can see that there is not only a mdmp file but also a hdmp file on the temp directory. Howerver the cabinet file on the local share does not contain the hdmp file.
Is is possible to force the hdmp file in the cabinet when using a local share for report
-
- MergeSort for Double Arrays
by Douglas Penna
- 3 Replies
- Last post
by Andy Pope
- Hello There =)
I made a MergeSort function for matrices with Double Data. I haven't found this on the web (one that works, that is), so I'm posting here, so ppl can watch, and maybe improve.
To use with strings and other kinds of variables, you just have to change the compare statement, and the type (Double). The compare statements are bolded.
Cya
Public Function MergeSort(Doubles() As
-
- Comparing two word documents
by SurajJaldu
- 4 Replies
- Last post
by kannaiah
- Hi All,
I have to compare the text of two word documents using VBA. These word documents contain images and tables also. But I just wanted to compare the text.
Can anybody please let me know how to do this
Thanks,
Suraj
-
- Using FindWindow API to Get Focus and Send keys to a window
by Consulter
- 3 Replies
- Last post
by DVDK
- I have put together some code in VBA to naviate to a webpage in IE, wait for it to load, find a hyptertext link on the page named "spreadsheet", click it, wait for the "download file" window to load and the go through the process of saving the file into a specific directory using send keys.
The problem is, I am constantly losing focus on the windows. My code actually repeats
-
- Extracting an embedded document within a cell in a table in a Word document
by llmpro
- 3 Replies
- Last post
by Carleton
- Hello, I need to extract and save files embedded in cells of a table in a Word document. I have bookmarked my table, I already have a a macro to find the table based on this bookmark and parse the content of it, except the embedded files inside the table cells. Here is how I parse the cell content: 'I find my Table in the Word doc based on a bookmark Set idTable = RetrieveTable("myTableBookmark
-
- Inserting Excel Data into Word Report with VBA
by Deserthawk
- 2 Replies
- Last post
by Deserthawk
- Hello,
I am trying to find a way to open up an existing word document and place excel data into the document at predetermined locations. Can anyone get me started in the right direction
Thanks,
Deserthawk
-
- Corrupt email causes Outlook Express to freeze
by EU_BNL_Carol
- 1 Replies
- Last post
by EU_BNL_Carol
- Today when I brought my email in, the computer got stuck at some point. It wouldn't react to anything, not even Ctrl+Alt+Del.
I've been trying many things for hours and hours, but the problem remains.
As soon as I stand on this particular email where the above happened, OE freezes. As long as I work around it, all goes well.
How can I delete this corrupt email
If you wa
-
- Welcome to this forum.
by Saar Picker
- 1 Replies
- Last post
by Saar Picker - MSFT
-
- How to write this code?
by lyp_sj
- 1 Replies
- Last post
by magicalclick
- Hello:
I wanna embed a variable i1 into Rows("i1+1:i1+1").delete code. How can I write this code correctly Thanks so much!
B.regards/Yaping
-
- Opening an excel file from MS Access
by BassHunter
- 2 Replies
- Last post
by BassHunter
- Hi,
I'm currently working with MS Access and my problem is as follows:
I put a command button to run MS Excel and combined it with command line feature like this but it doesnt work because of the "quotes"., also Syntax Error.
C:\Programme\Office2003\OFFICE11\Excel.exe "C:\Dokumente und Einstellungen\jr_ziylan\Desktop\Arbeitszeiten.xls"
How can I open
-
- How to paste an image in ppLayoutObject
by lollol8754645
- 1 Replies
- Last post
by Andy Pope
- I have wiritten a code that selects the right shape, but how to insert an image in it I tried to do it, but image displays on de slide as a new shape. Pls help me my code: Sub Code() ActivePresentation.Slides.Add(Index:=ActivePresentation.Slides.Count + 1, Layout:=ppLayoutObject).Select ActiveWindow.Selection.SlideRange.Shapes(ActiveWindow.Selection.SlideRange.Shapes.Count).Select End Sub
-
- Adding VBA code to Excel sheet
by Ad Brandt
- 4 Replies
- Last post
by Andy Pope
- I've made a program that reads an XML data file, and generates an Excel spreadsheet with charts of the data. I'd like to be able to manipulate the scaling of those graphs in Excel. That can be done easily, but requires some VBA, to define a Worksheet_Change(ByVal Target As Range) function. My question is: is there a way to write VBA code into an Excel sheet via OLE, just as you can write data and
-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- ado recordset problem
by leeshade
- 2 Replies
- Last post
by leeshade
- i am using the following code and am getting the structure of customers structure returned to my application recordset rs - but there are no records being produced >>> what am i missing (the access table set is not empty) cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\lee\Northwind.mdb;Persist Security Info=False" cn.Open rs.Open "select * from cust
-
- Sending email to more than one recipient in excel using ActiveWorkbook.SendMail
by Scott Boyd
- 1 Replies
- Last post
by Dario Galvani
- Hi,
I had this simple sub routine for sending a completed excel file to an a colleague via email. However, I now got some feedback to ask if it was possible to insert a subject line and add extra recipients. I know this is but I can not for the good of me manage to get it working! I've played about with different bits but haven't had much success :( Can anyone guide me
Sub cmdEma
-
- Help with comma separated values in report
by kdee
- 14 Replies
- Last post
by kdee
- Hi! A bit of a stuck-up. It¡¯s no problem in creating a coma separated fields in .txt kind of file. But I have another problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don¡¯t come up with nothing). I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line. If anybo
-
- WorksheetFunction Object help needed
by Rakesh Simpi
- 4 Replies
- Last post
by rakesh
- i am trying to use WorksheetFunction object to calculate R-Square (linear regression) value. Now, if i export my numeric data to cells of a worksheet and use Value2 function, i get an appropriate answer. But, if i try to use WorksheetFunction object by passing my arrays of integer, it gives me some spurious result which seems to be completely irrelavant. here is my sample code: dim Appp as new Exc
-
- Run-time error '3705'
by ISRI
- 4 Replies
- Last post
by ISRI
- I am trying to run this VB function in Access which will delete records from my table based on the criteria of another table.
The code looks like this:
Function deleteDuplicates()
Dim FHA_Case As String Dim SeqNumber As String
Dim SQL1, SQL2 As String Dim rs1 As New ADODB.Recordset Set rs1 = New ADODB.Recordset Dim rs2 As New ADODB.Recordset Set