VBA StrFileName question

[Katy Jordan]

Hi, the below line reads if the user has saved the Csv file in lowercase ".csv" but there is a chance they might save in uppercase, is there some kind of code that i could put into place which would cater for both scenarios?

strFileName = Range("rngRgPath") & ".csv"

 

[Norie]

Katy

All that code is doing is setting a the value for a string variable.

Are you having problems later in the code when you try to use the variable to do something with a CSV file?

 

[Katy Jordan]

Katy

All that code is doing is setting a the value for a string variable.

Are you having problems later in the code when you try to use the variable to do something with a CSV file?

i'm having no trouble with the code, but just being mindful that if the user saves the file as CSV rather than csv then the code would fail.

 

[Norie]

Katy

If you are trying to open a file then the case of strFileName shouldn't be relevant.

Excel, and Windows as far as I know, won't allow you to use the same name twice even if the case is different.

 

[Katy Jordan]

Katy

If you are trying to open a file then the case of strFileName shouldn't be relevant.

Excel, and Windows as far as I know, won't allow you to use the same name twice even if the case is different.

So if the code is .csv but the user saves the file as CSV then the code should still open the file?

 

[Norie]

Katy

Yes, as far as I know there should be no problem.

If there is then perhaps there something else going wrong, or even something in your setup that does differentiate between case for filenames.