Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error when opening Excel workbook
When I open this workbook I get the following message and I am unable to
locate the cause any help would be greatly appreicated Cannot find 'F:\users\mnajjar\misc\lbo.xlm! Auto_Open, which has been assigned to run each time [Book1.xls]IS is opened. I have looked at any links and deleted them. Not sure what else I can do. Thanks in advance for any help on this Deb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error when opening Excel workbook
If it's only that one workbook that does this, and you've killed all links,
then maybe you have a "Workbook_Open" macro in your "ThisWorkbook" module..... Vaya con Dios, Chuck, CABGx3 "dcournoyer" wrote: When I open this workbook I get the following message and I am unable to locate the cause any help would be greatly appreicated Cannot find 'F:\users\mnajjar\misc\lbo.xlm! Auto_Open, which has been assigned to run each time [Book1.xls]IS is opened. I have looked at any links and deleted them. Not sure what else I can do. Thanks in advance for any help on this Deb |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error when opening Excel workbook
Can you tell me where to find this
and yes it only happend to this workbook "CLR" wrote: If it's only that one workbook that does this, and you've killed all links, then maybe you have a "Workbook_Open" macro in your "ThisWorkbook" module..... Vaya con Dios, Chuck, CABGx3 "dcournoyer" wrote: When I open this workbook I get the following message and I am unable to locate the cause any help would be greatly appreicated Cannot find 'F:\users\mnajjar\misc\lbo.xlm! Auto_Open, which has been assigned to run each time [Book1.xls]IS is opened. I have looked at any links and deleted them. Not sure what else I can do. Thanks in advance for any help on this Deb |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error when opening Excel workbook
Open your workbook
hit alt-f11 (to get to the VBE) hit ctrl-r (to view the project explorer--like windows explorer) You'll see something like: VBAProject (book1.xls) Click on it to select it Hit the asterisk (*) on the numeric keypad to expand all the levels. You'll see the ThisWorkbook module. === But if this is happening with book1.xls and book1.xls isn't important to you--it isn't a real workbook, you could just delete that file. Back to excel. with book1.xls open and the active workbook file|properties|General tab You'll see the location of the file. If it's truncated, you could use this, too: Put this formula in any cell: =cell("filename",a1) And note the location. Close the file, open windows explorer, traverse to that folder and delete it. dcournoyer wrote: Can you tell me where to find this and yes it only happend to this workbook "CLR" wrote: If it's only that one workbook that does this, and you've killed all links, then maybe you have a "Workbook_Open" macro in your "ThisWorkbook" module..... Vaya con Dios, Chuck, CABGx3 "dcournoyer" wrote: When I open this workbook I get the following message and I am unable to locate the cause any help would be greatly appreicated Cannot find 'F:\users\mnajjar\misc\lbo.xlm! Auto_Open, which has been assigned to run each time [Book1.xls]IS is opened. I have looked at any links and deleted them. Not sure what else I can do. Thanks in advance for any help on this Deb -- Dave Peterson |
#5
|
|||
|
|||
I also get this exact same error when opening a workbook: Same drive, same user name "mnajjar" - everything. It happens on a file which contains information that was downloaded from the AT&T Business Direct website. I wonder if the previous user's file originated from the same place? Was s/he successful in eliminating the error message? I followed the directions above, but was not successful. I'm using Excel 2007, if that makes any difference.
Last edited by Zubie : January 20th 09 at 01:52 PM Reason: clarification of location of directions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
custom color palette does not get transferred with the workbook. Excel 2003 | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
Excel 2003 crashes when opening | Excel Discussion (Misc queries) |