Excell 2000 macro will not open file!

  • Thread starter Thread starter JHB
  • Start date Start date
J

JHB

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
 
Back
Top