VBA save as code

[slxia1]

I cannot get the below to saveas (i want to save as so i can keep the csv format)
in cell a1 I have f:\apple_011112
in cell a2 i have apple_011112



I have tried the following, if possible please tell me whats wrong with each, as I really need to know all methods to prevent multiple posts.

Please Login or Register  to view this content.

i know i dnt have to put a format code to get csv, but is it at least correct way i coded it?

[arlu1201]

Use this

Please Login or Register  to view this content.

[slxia1]

Thanks a million.