workbook name with and without extension
 

Hi All,

I have a macro processing a CSV file named 2005_12.CSV, the name stored in a
variable csvtoprocess WITHOUT extension, that is csvtoprocess = "2005_12". On
my PC the line

Workbooks(csvtoprocess).Activate

works, but on an other PC it fails, and works only if csvtoprocess contains
the extension as well, that is csvtoprocess = "2005_12.CSV"

What is the cause of this difference, how can I affect the behaviour of
XL2000 in this aspect?

Thanks,
Stefi

workbook name with and without extension
 

Hi Stefi,

What is the cause of this difference, how can I affect the behaviour of
XL2000 in this aspect?

The behaviour is driven by a user setting in Windows: "Hide extensions of
known filetypes", which can be found in Windows Explorer, menu "Tools,
Folder Options...", View tab.

If I remember correctly, including the extension always works.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

workbook name with and without extension
 

Thanks, Jan, that was it, and you remembered well!
Regards,
Stefi



€žJan Karel Pieterse€� ezt Ã*rta:

Hi Stefi,

What is the cause of this difference, how can I affect the behaviour of
XL2000 in this aspect?

The behaviour is driven by a user setting in Windows: "Hide extensions of
known filetypes", which can be found in Windows Explorer, menu "Tools,
Folder Options...", View tab.

If I remember correctly, including the extension always works.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

workbook name with and without extension
 

Hi Stefi,

Thanks, Jan

You're welcome!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com