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

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