Unable to open an Excel file using VBA

[Dileep Reddy]

Hi,

I have written a vba code to loop through all files and do some specific work. However I am not able to open one file (Attached) through vba and hence its throwing me an error. But I can open this Excel file by double clicking on the file. May be because the file contains special character but the client is saying that if we can open the file using normal excel, why can't you do the same through macro.

I am using the below code in my workbook

'Target File Extension (must include wildcard "*")
myExtension = "*.xlsx"

'Target Path with Ending Extention
myFile = Dir(mySrcPath & myExtension)

'Loop through each Excel file in folder
Do While myFile <> ""
'Set variable equal to opened workbook
Set wb = Workbooks.Open(Filename:=mySrcPath & myFile)

Can you please help?

Thanks in advance.

Dileep

 

[vletm]

@Dileep Reddy
An idea ...
If You do like below with that 'file', solve its ThisWorkbook.Name -value.
It's value will be different than 'original' filename.
But it will show it 'correct .. as written' in sheet.

There are rules for 'filenames' like:
https://msdn.microsoft.com/en-us/library/windows/desktop/aa365247(v=vs.85).aspx

 

[Dileep Reddy]

@Dileep Reddy
An idea ...
If You do like below with that 'file', solve its ThisWorkbook.Name -value.
It's value will be different than 'original' filename.
But it will show it 'correct .. as written' in sheet.
View attachment 40268
There are rules for 'filenames' like:
https://msdn.microsoft.com/en-us/library/windows/desktop/aa365247(v=vs.85).aspx

I have No idea @vletm

 

[vletm]

Did You read that link?
There are rules for filenames.
Maybe even VBA won't allow all possible variations with filenames.
Did You notice difference of those values?

 

[Dileep Reddy]

Did You read that link?
There are rules for filenames.
Maybe even VBA won't allow all possible variations with filenames.
Did You notice difference of those values?

Yes I did, and I knew this before, it say we cannot use special characters in file names and the file that I attached is a valid file name since it doesn't contain any special characters that are mentioned in this link. Excel itself wont allow the special characters when naming a file.

 

[vletm]

There is at least one special character; after 'k'!
Look again! It's not "="!

 

[Dileep Reddy]

There is at least one special character; after 'k'!
Look again! It's not "="!

If not "=", may some other character but that is not among the prohibited characters in listed in that link. Same goes with last character of the file name omega.

 

[vletm]

... anyway that character do not match!
It's much more simply to use like 'A'...'Z' & '0'..'9' than
use some 'copy&paste'-result!

 

[Marc L]

Hi vletm !

As yet written in its duplicate thread (so closed) …
​

 

[vletm]

@Marc L
~1:20 ago, I offer same the 1st time, but
maybe he needs some evidence/document for his client, who knows?

 

[Marc L]

As we are not mind readers !

Take care ! ​

 

[vletm]

Merci