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

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

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

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

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

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

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