Macro which wil run other workbooks?any1 knows the code plea

Mayk · Apr 15th, 2002, 06:18 PM

I have three following worsheets:
welcomepage.xls
as~project~witoutpics1.xls
database~as212.xls

These files are located on my desktop.
In the welcom page i have a button which i want in a way that after i click on it two other worksheets opens.

The example below is the macro i recorded using key strokes however is is not working.
Anyone knows an alternative please help.

Sub ENTERTOMAINMENU_BUTTON()
'
' ENTERTOMAINMENU_BUTTON Macro
' Macro recorded 11/04/2002 by Radek Ilendo
'

'
Windows("As~project~witoutpics.xls").Activate
Range("G4").Select
Sheets("Main menu").Select
End Sub

robfo0 · Apr 15th, 2002, 06:25 PM

you said you want worksheets to open, do you mean the other workbooks? if so, heres the code to open a workbook:

Workbooks.Open Filename:="C:PathFileName.xls"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 06:18 PM	#1
Mayk New Member Join Date: Mar 2002 Location: rejdus@hotmail.com Posts: 18	I have three following worsheets: welcomepage.xls as~project~witoutpics1.xls database~as212.xls These files are located on my desktop. In the welcom page i have a button which i want in a way that after i click on it two other worksheets opens. The example below is the macro i recorded using key strokes however is is not working. Anyone knows an alternative please help. Sub ENTERTOMAINMENU_BUTTON() ' ' ENTERTOMAINMENU_BUTTON Macro ' Macro recorded 11/04/2002 by Radek Ilendo ' ' Windows("As~project~witoutpics.xls").Activate Range("G4").Select Sheets("Main menu").Select End Sub

Apr 15th, 2002, 06:25 PM	#2
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	you said you want worksheets to open, do you mean the other workbooks? if so, heres the code to open a workbook: Workbooks.Open Filename:="C:PathFileName.xls"