Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2000 macro will not open file!
Hi:
I have a "simple" macro that just wont do what I want. It looks like this:: Sub opening() ' ' Macro1 Macro ' Macro recorded 10/13/2012 by John Baker ' ' Workbooks.Open(Filename:="C:\TASC\Apps \XLSXConvert.xls").RunAutoMacros Which _ :=xlAutoOpen Workbooks.Open(Filename:="C:\TASC\Apps\TASC- DriverDataCollect.xls"). _ RunAutoMacros Which:=xlAuto_Open End Sub The simple objective is that by opening this macro the end user can cause the two spreadsheetes (which include their own macros) automatically. The first sheet is set to close itself when it has done its work, and the second closes the application. They both work fine when the spreadsheets are opened individually, but in this macro after the first one has completed its work the execution stops. Note that the first one does NOT close the application, although the second one does. Anyone got any suggetions? The objective is simple .. one spreadsheet opening causes two spreadsheets to do their thing. Best John Baker |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2000 macro will not open file!
Try opening the 2nd file from the 1st file when the 1st file has done
its task. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when i open an Excell file 3 workbooks open.Why? | Excel Discussion (Misc queries) | |||
Open 2000 file attachments in Excel 2000 | Excel Discussion (Misc queries) | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excell 2000 - Cannot open file | Excel Discussion (Misc queries) |