Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
open a query automatically
I have received an XL spreadsheet from a colleague. When I open it I get the
following message: Cannot find 'C:\...'!Register.DClick, which has been assigned to run each time [filename.xls]Sheet1 is opened. I have tried everything I can think of to find where this is set without success. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
open a query automatically
Possibly if you go into thr Visual Basic editor Alt F11, and in the left hand pane go down to where it says ThisWorkbook, double click on this. Is there an event in the righ window under workbook open? Here or in a macro that is called from here, there could well be reference to the file that you can not find Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=542359 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
open a query automatically
I checked this out but there is no code or macro here. No problem - I have
copied the data into a new spreadsheet and this opens fine without an error. "Dav" wrote: Possibly if you go into thr Visual Basic editor Alt F11, and in the left hand pane go down to where it says ThisWorkbook, double click on this. Is there an event in the righ window under workbook open? Here or in a macro that is called from here, there could well be reference to the file that you can not find Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=542359 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
How do I get excel files to open automatically from directories? | Excel Discussion (Misc queries) | |||
how to extend data to next sheet automatically during sql query | Excel Discussion (Misc queries) | |||
How do I automatically open linked documents in Excel? | New Users to Excel | |||
Automatically open excel file after log in | Excel Discussion (Misc queries) |