Recorded Macro to save as CSV with original filename.

**Zaki_Jaffri** · 06-27-2023, 04:44 AM

I am new to VBA and Macros, I am attempting to use a macro to save a file as CSV to a specific directory with the original filename.
I have tried recording and editing a macro to do this, but the file will only save as original .xlsx and not CSV.

Thanks

Please Login or Register  to view this content.

**ByteMarks** · 06-27-2023, 05:16 AM

Maybe

Please Login or Register  to view this content.

**Zaki_Jaffri** · 06-27-2023, 05:23 AM

Awesome! Thank you very much that works!

Recorded Macro to save as CSV with original filename.

LinkBack

Thread Tools

Rate This Thread

Display

Recorded Macro to save as CSV with original filename.

Re: Recorded Macro to save as CSV with original filename.

Re: Recorded Macro to save as CSV with original filename.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Once Save as method used, original File opens after every macro

Macro to Save As a Copy of the File, Save the Original File, & Overwrite Previous Versions

[SOLVED] Run recorded macro based on current sheet, not the original sheet

I have a Save as macro but I need to keep the original open at the same time

[SOLVED] Auto save replaced my original file and now I need the original?

[SOLVED] save original data after macro is run again

[SOLVED] Recorded macro: What happens if I change filename?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions