Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where else to look for procedure call
NOPE! Going through the names, auto_open ONLY refers to
=C:\Macro.xlw\macro!auto_open And all other RangeNames are cells occupied with either a label or a fomrula or a value, but nothing that seems to refer to the other file. I'm running out of ideas. How about you? "Tom Ogilvy" wrote: Hold down the Shift key when you open Time.xls and you should be able to open it. Once it is open, go to insert=Names=Define and see if you can find a name like auto_open. See what its refersto property is and alter as appropriate. -- Regards, Tom Ogilvy "Lulu" wrote in message ... I have an Excel95 file name Time.xls. Have second file called macro.xlw which is a single sheet named MACRO and is Excel4.0 Language. Upon open of Time.xls, error says cannot file c:\macro.xlw\macro!auto_open whcih is assigned to run with this file. Have searched Time.xls for call procedure command so I can disable it. Cannot find. There is no hidden sheet. There are no hidden cells. Nothing in XLSTART. No macros attached to this sheet that I can spot. If macro.xlw is workspace, I should still be able to open file time.xls independent of workspace, right? If I copy sheet from Time.xls to another file, still get error. If select occupied cells, copy and paste in new file, error does not happen. So clearly this call command is somewhere, somehow connected to this sheet. I have run out of places I can think to look. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where else to look for procedure call
What do you mean by Nope.
That is where your error is coming from. Move Macro.xlw to the Root directory of the C drive and when you open the file, it should run. -- Regards, Tom Ogilvy "Lulu" wrote in message ... NOPE! Going through the names, auto_open ONLY refers to =C:\Macro.xlw\macro!auto_open And all other RangeNames are cells occupied with either a label or a fomrula or a value, but nothing that seems to refer to the other file. I'm running out of ideas. How about you? "Tom Ogilvy" wrote: Hold down the Shift key when you open Time.xls and you should be able to open it. Once it is open, go to insert=Names=Define and see if you can find a name like auto_open. See what its refersto property is and alter as appropriate. -- Regards, Tom Ogilvy "Lulu" wrote in message ... I have an Excel95 file name Time.xls. Have second file called macro.xlw which is a single sheet named MACRO and is Excel4.0 Language. Upon open of Time.xls, error says cannot file c:\macro.xlw\macro!auto_open whcih is assigned to run with this file. Have searched Time.xls for call procedure command so I can disable it. Cannot find. There is no hidden sheet. There are no hidden cells. Nothing in XLSTART. No macros attached to this sheet that I can spot. If macro.xlw is workspace, I should still be able to open file time.xls independent of workspace, right? If I copy sheet from Time.xls to another file, still get error. If select occupied cells, copy and paste in new file, error does not happen. So clearly this call command is somewhere, somehow connected to this sheet. I have run out of places I can think to look. Any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where else to look for procedure call
"Lulu" wrote in message ...
NOPE! Going through the names, auto_open ONLY refers to =C:\Macro.xlw\macro!auto_open And all other RangeNames are cells occupied with either a label or a fomrula or a value, but nothing that seems to refer to the other file. I'm running out of ideas. How about you? "Tom Ogilvy" wrote: Hold down the Shift key when you open Time.xls and you should be able to open it. Once it is open, go to insert=Names=Define and see if you can find a name like auto_open. See what its refersto property is and alter as appropriate. -- Regards, Tom Ogilvy "Lulu" wrote in message ... I have an Excel95 file name Time.xls. Have second file called macro.xlw which is a single sheet named MACRO and is Excel4.0 Language. Upon open of Time.xls, error says cannot file c:\macro.xlw\macro!auto_open whcih is assigned to run with this file. Have searched Time.xls for call procedure command so I can disable it. Cannot find. There is no hidden sheet. There are no hidden cells. Nothing in XLSTART. No macros attached to this sheet that I can spot. If macro.xlw is workspace, I should still be able to open file time.xls independent of workspace, right? If I copy sheet from Time.xls to another file, still get error. If select occupied cells, copy and paste in new file, error does not happen. So clearly this call command is somewhere, somehow connected to this sheet. I have run out of places I can think to look. Any suggestions? That should be your answer NOPE! Going through the names, auto_open ONLY refers to =C:\Macro.xlw\macro!auto_open |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
call procedure problem | Excel Discussion (Misc queries) | |||
can I call a procedure using a variable | Excel Programming | |||
Selective call procedure | Excel Programming | |||
call procedure | Excel Programming | |||
procedure won't call | Excel Programming |