Workbook.FullName wrong when loading an XLSX file in Excel 2003

[David Thielen]

Hi;

We have a major problem. When loading an XLSX file in Excel 2003
(using the MS file converter), when the
Microsoft.Office.Interop.Excel.AppEvents_Event.WorkbookOpen event
fires, we use Microsoft.Office.Interop.Excel.Workbook.FullName to get
the name of the XLSX file.

We need the path component of this to be correct for associated data
that we read in at that time (in the same directory). However, at this
point the file name is 'C:\Documents and Settings\dave\Local
Settings\Temp\abc123.tmp.

Later on the FullName is correct. However, we need the correct name
when the worksheet is loaded. How can we get this? We don't need it at
that exact spot, but we do need it before the user can edit a read in
Excel file.

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Jialiang Ge [MSFT]]

Hello Dave,

Thank you for reporting this break issue to us. I've reproduced it on my
side that Excel WordBook.FullName returns the path to a tmp file, instead
of the real xlsx path in WorkbookOpen event handler when Excel 2003 opens
an XLSX file with Office 2007 file convertor. This does look like an issue
of our product. I'm very sorry for any potential impact of this issue on
your current business. I will co-operate with the product team and do my
best to help you out.

By far, I am sorry that I have not found out a workaround in Excel.
However, based on my tests, the problem does not happen in Word. The real
docx file path can be returned in Word DocumentOpen event handler by
calling Doc.FullName. The product team is helping me check the issue, and I
will get back to you as soon as possible.

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================