LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2000 VBA ActiveWorkbook.FullName

Like millions of Excel 2000 users, we use a VBA macro to
insert the document pathname into the footer. This has
worked for months and months. Suddenly, this feature
stopped working and reports the VBA message:

Run-time error '50290':

Method 'FullName' of object '_Workbook' failed

The offending line of code highlighted in yellow is:
ws.PageSetup.LeftFooter = "&""arial""&08" &
ActiveWorkbook.FullName

We have found that by changing this line as follows:
ws.PageSetup.LeftFooter = "&""arial""&08" &
ActiveWorkbook.Path & "\" & ActiveWorkbook.Name

everything works fine again. However, we would rather not
go through all our workbooks and change the VBA.

Our IS/IT people always install the latest fixes from MS,
but there's no mention of effects to this VBA property.

Why would this property suddenly stop working?

We are using Excel 2000 Version 9.0.6926 SP-3.

Thanks!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert ThisWorkBook.FullName as Link in Email jlclyde Excel Discussion (Misc queries) 3 February 4th 09 02:08 AM
Seperating Text in One Field into 2 Fields EG FullName SunRay Excel Discussion (Misc queries) 1 September 11th 07 07:30 AM
ActiveWorkBook Pete Excel Discussion (Misc queries) 3 May 9th 05 04:14 PM
ActiveWorkbook.RefreshAll Mark[_22_] Excel Programming 0 October 15th 03 02:22 AM
Looking for Excel function to resolve userid to fullname. steve Excel Programming 0 September 17th 03 07:37 PM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"