Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
opening an excel file from access
Try adding the following line to your code where fname is the name and path of the file you wish to open. oApp.Workbooks.Open fname- pedlar
- Post #2
- Forum: Visual Basic (Classic)
-
SetWindowPos/GetActiveWindow with MSWord window
Try the following I have used it succesfully to force vbforms to the top, if you pass the handle of Word into 'handle' then it should work. Public Const HWND_TOPMOST = -1 Public Const TOPMOST_FLAGS = SWP_NOMOVE Or SWP_NOSIZE ' Example - MakeTopMost Me.hwnd Public Sub MakeNormal(Handle As...- pedlar
- Post #3
- Forum: Visual Basic (Classic)
-
SetWindowPos/GetActiveWindow with MSWord window
Try the following I have used succesfully Public Const HWND_TOPMOST = -1 Public Const TOPMOST_FLAGS = SWP_NOMOVE Or SWP_NOSIZE SetWindowPos Handle, HWND_TOPMOST, 0, 0, 0, 0, TOPMOST_FLAGS- pedlar
- Post #2
- Forum: Visual Basic (Classic)
-
Clear Commondialog.filename ?
If you initialise the filename when you call the routine it will not retain the last file chosen. eg CommonDialog1.FileName = ""- pedlar
- Post #3
- Forum: Visual Basic (Classic)
-
Exporting data to MS Excel through Automation
Don't know whether this helps but I completed some work recently to export data to Excel in a VB6 project. I found the automation to Excel fro VB was a little flaky so as I was using an access database to store my data I wrote the procedures in Access VBA and then called the procedures from VB...- pedlar
- Post #3
- Forum: Visual Basic (Classic)
