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: 31
Default Name vs FullName

Hi

I have discovered that when I download a CSV file, that always contains a
"]", from the work financial system, the previous Application Event
trapping of the form Wb.Name includes the "]" character no longer traps the
the file even though the actual filename still contains a "]". The Wb.Name
now converts the square bracket "]"to a round bracket ")".

What is really odd is that if I use the Wb.FullName property the "]" is
included in the string Wb.FullName and so I can trap the "]" that way.

My question is why is the Wb.Name property no longer properly reflects the
actual filename (any more).

Any help most welcome.

Tim

 
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
How to Get Files.FullName K[_2_] Excel Programming 5 February 19th 09 12:39 PM
extract path from FullName Judy Ward Excel Programming 4 February 3rd 09 11:34 PM
Citrix and FullName Jonathan West Excel Programming 0 August 6th 08 03:25 PM
FullName vs FullNameURLEncoded Posse John Excel Programming 1 August 20th 06 02:41 PM
ThisWorkbook.FullName Steph[_3_] Excel Programming 3 November 23rd 04 08:41 PM


All times are GMT +1. The time now is 12:58 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"