Thread: Excel 2007 macro gets workbook name and path from temp file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BothFeet BothFeet is offline
external usenet poster
  
Posts: 3
Default Excel 2007 macro gets workbook name and path from temp file
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