convert xlsx to csv and save to file directory

All

I am trying to improve a process using macros/VBA and have some code that I borrowed off a forum (not sure which one) that perfectly exports a sheet within my workbook to a specific file location....

However, I now need to save this worksheet (again in a specific file location) but as a comma separated value (the file needs to be uploaded into an external

... and am stuck.... have tried searching but most appear to want you to purchase a third party product to convert ...


any suggestions

TIA

Shaz0503

... files save as csv file doesn't work - what do you mean by save as > format> comma separated values ???

Hi, this could help you..

Please Login or Register  to view this content.

All

I have tried a couple of options in 'madrocketscientist' and aavins73 suggestons but to no avail

This is the code that I used from JIM885 for another purpose and was hoping to be able to modify it... again no success....

any additional ideas

shaz0503

Please Login or Register  to view this content.

Try this pls..

Please Login or Register  to view this content.

Thanks all who have replied.....

I have got code working to export as .txt file .... this will suffice for now but would still like to see if I can get code to export as comma separated value delimited....

aavins73 ... your last comment didn't work....

rgds

Sharon