Thread: Excel 2007 macro gets workbook name and path from temp file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
  
Posts: 2,718
Default Excel 2007 macro gets workbook name and path from temp file
Better post some code that duplicates the problem.

--
Jim
"BothFeet" wrote in message
...
|I have Office 2003 with compatibility pack installed. I have an
| App_WorkbookOpen macro that gets the name and full path of any newly
| opened workbook. This macro works correctly for any pre-2007
| workbooks
|
|
| When opening 2007 workbooks, the macro gets the name of the temp
| files! So workbook.name, workbook.fullname and workbook.path all
| point to the .tmp file.
|
| Is there a way around this?


Reply With QuoteReply With Quote