Hi,

I have a macro that opens a csv file. Here is the problem
On my computer the csv files have a ".csv" extention on the end
"filename.csv" but on my coworkers computer there is no csv extention. So
the macro works on my computer but not on his.

Is there a reason there is no ".csv" extention - do you know the most
efficient way to solve the problem?

Thanks for your help.

on your colleagues computer, go into windows explorer

tools--folder options, click the view tab and deselect the option 'hide
file extensions for known file types

That should fix it

cheers

"Jeff" wrote:

Hi,

I have a macro that opens a csv file. Here is the problem
On my computer the csv files have a ".csv" extention on the end
"filename.csv" but on my coworkers computer there is no csv extention. So
the macro works on my computer but not on his.

Is there a reason there is no ".csv" extention - do you know the most
efficient way to solve the problem?

Thanks for your help.

Thanks that is very helpful.

"DazzaData" wrote:

on your colleagues computer, go into windows explorer

tools--folder options, click the view tab and deselect the option 'hide
file extensions for known file types

That should fix it

cheers

"Jeff" wrote:

Hi,

I have a macro that opens a csv file. Here is the problem
On my computer the csv files have a ".csv" extention on the end
"filename.csv" but on my coworkers computer there is no csv extention. So
the macro works on my computer but not on his.

Is there a reason there is no ".csv" extention - do you know the most
efficient way to solve the problem?

Thanks for your help.