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
|