ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excell 2000 macro will not open file! (https://www.excelbanter.com/excel-discussion-misc-queries/447383-excell-2000-macro-will-not-open-file.html)

JHB

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

GS[_2_]

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




All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com