run-time error '91' object variable or block variable not set

[TRosseter]

when I open up the spread sheet aiiwwaxexcel0 the code runs fine and all is good but if I open up any other or new workbook I get this run time error any ideas?

code below
'Private Sub Workbook_Open()
'Select Case ActiveWorkbook.Sheets("aiiwwaxexcel0").Range("A3").Value
'Case "History"
'History_Order_Guide_Without_Pricing2
'Case "ItemBrowse"
'Order_Guide_With_Pricing2
'Case Else
'End Select
'End Sub

 

[TRosseter]

any time you open up excel this code runs this is why is in this file. I use personal.xlsb which is a hidden template on the computer and accessible to any excel document when opened.when I export an excel document from my software it creates a file "aiiwwaxexcel0" then I can manually run a macro from my personal file. already using this and it worked just fine. i'm trying to automate it now for anyone that opens up an excel document it auto runs a macro bases on info in "a3". this ensures the correct macro runs as I have multiple macro that does different things to the excel document.

 

[Norie]

This code will run whenever personal.xlsb opens, not when other workbooks open.

personal.xlsb is opened every time you open Excel, so the code will run every time you open Excel.

 

[TRosseter]

yes, every time you open excel, runs through a case and if false it exits, if there is a match then it runs a macro.

 

[Norie]

Every time Excel opens it runs that code.

That code looks for a worksheet called 'aiiwwaxexcel0'.

If it doesn't find that worksheet then the code errors.

 

[TRosseter]

this is correct! works only if it finds the workbook but if it doesn't it errors out

 

[Norie]

So the code is doing what it's supposed to then?

 

[TRosseter]

only if it finds the info in the "a3" all others get the global error message. you can always click end and go to your excel document.

 

[Norie]

So this is sorted?