workbook name with and without extension

[Stefi]

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

[Jan Karel Pieterse]

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

[Stefi]

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
>
>

[Jan Karel Pieterse]

Hi Stefi,

> Thanks, Jan

You're welcome!

Regards,

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