aout open no workeee
 

When using the string below inserted in 'ThisWorkbook' code of a given file,
'It does not open the file, nor does it give any error message. HELP

Private Sub Auto_Open()
Auto.Open "Menu_List.xls"
End Sub

Thanks for any advice...
Mike

aout open no workeee
 

Hi Mike

Copy the Auto_Open sub in a normal mudule (not Thisworkbook or Sheet)

See
http://www.cpearson.com/excel/events.htm


--
Regards Ron De Bruin
http://www.rondebruin.nl



"Mike" wrote in message ...
When using the string below inserted in 'ThisWorkbook' code of a given file,
'It does not open the file, nor does it give any error message. HELP

Private Sub Auto_Open()
Auto.Open "Menu_List.xls"
End Sub

Thanks for any advice...
Mike

aout open no workeee
 

You have to call the sub..

and I don't know if auto.open would be the right syntax...

Try:

Workbooks.Open Filename:= "Menu_list.xls"
Windows("Menu_list.xls").Activate


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553757

aout open no workeee
 

Thanks this worked!!....But what should I put in the code to have it
auto-return the the main page (from where it was opened)?

"Bearacade" wrote:


You have to call the sub..

and I don't know if auto.open would be the right syntax...

Try:

Workbooks.Open Filename:= "Menu_list.xls"
Windows("Menu_list.xls").Activate


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553757

aout open no workeee
 

You want it to return to the spreadsheet/worksheet that it was at?

try taking out Windows("Menu_list.xls").Activate

or change it to Windows("Name of the original xls".Activat

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=55375

aout open no workeee
 

Thanks again.
Tried both and no luck. I'm sure there is a way...RiGHT?

"Bearacade" wrote:


You want it to return to the spreadsheet/worksheet that it was at?

try taking out Windows("Menu_list.xls").Activate

or change it to Windows("Name of the original xls".Activate


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553757

aout open no workeee
 

aye.. my mistake.. no xls suffix..

Workbooks.Open Filename:="test.xls"
Windows("BOOK1").Activat

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=55375

aout open no workeee
 

I must be close....but missing something. Upon opening the 'StartHere_Site'
file, it does auto-open the Menu_List file, but will not return to the
'StartHere_Site' file as I need it to. This is the code I have so far. I need
help...

Private Sub Auto_Open()
Workbooks.Open "Menu_List.xls"
Windows("StartHere_Site").Activate
End Sub



"Bearacade" wrote:


aye.. my mistake.. no xls suffix..

Workbooks.Open Filename:="test.xls"
Windows("BOOK1").Activate


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553757