View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cliff[_3_] Cliff[_3_] is offline
external usenet poster
 
Posts: 5
Default Excel menu toolbar hyperlink issues

So I have an hyperlink to an excel file in the tool bar and I created
and auto_open macro to read a temporary csv I need retreive and format
data from. When I go to the directory and open the excel it work
flawlessly but when I run it as a menubar hyperlink to a file it
doesnt run the macro. Its Excel 2000. and the Excel file I'm opening
hides iteslf and then opens and formats the temporary CSV file for
display.

any thoughts on why it opens diffrently each way and how I can work
around this?

thanks,
-Cliff