View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ken smith[_2_] ken smith[_2_] is offline
external usenet poster
 
Posts: 4
Default run macro from custom menu

Thanks, it took the default file path.
-----Original Message-----
In the immediate window in the VBE, check what the

onaction property of the
control actually refers to:

? Commandbars("Custom1").Controls(1).OnAction
If the results doesn't match your TimeTracker_2004.xls

file, then reset it
to match. I suspect that you have changed the location

of the file and
Excel sees the reference and the actual file as being

different.

In any event, it might be easiest to delete and recreate

the button or just
go ahead and reassign the onAction property with the

TimeTracker_2004.xls
file open.

--
Regards,
Tom Ogilvy

"ken smith" wrote

in message
...
XL2000 on W2K - I have a series of menus which load from
personal.xls. One command is to run a macro from a file
that I have open (.OnAction = "TimeTracker_2004.xls!
Process_Weekly_Data"). When called I get an error msg "A
document with the name TimeTracker_2004.xls is already
open." Is this a syntax problem? How can I run the code
without reopening the file?

TIA,
ken



.