| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - File Path location | Excel Discussion (Misc queries) | |||
| Inserting File name and path in Excel 2007 Documents | Excel Discussion (Misc queries) | |||
| Excel 2007 add-in with file path showing | Excel Discussion (Misc queries) | |||
| shared workbook, local temp-file and network traffic | Excel Discussion (Misc queries) | |||
| Windows XP default path for temp file | Excel Programming | |||
Threaded Mode
