Unable to to select/change file save destination when exporting mutiple tabs as CSV

Good afternoon all

I am new to this forum so forgive me while I get to grips with the rules and hope I can explain my issues in a comprehensible manner.

I have a macro that works wonderfully for me but I need it do just a little bit more. The macro allows me to export several tabs I have in the workbook as individual csv files, however they are all saved to my documents folder by default. I would like to know how I can do one of the following:

- Save all the files to another folder instead
- Select the file(s) save destination myself

This the macro I am using

Please Login or Register  to view this content.

Would hugely appreciate it if anyone could provide some guidance on this.


Many thanks in advance


Abs

Hi there,

See if the following routines do what you need.

The first routine will always save files in the specified folder, and the second routine will open a SaveAs dialogbox at the specified folder, and allow "onward navigation" from that point. The third routine will allow you to specify a different folder for each new workbook (worksheet) that is created.

Please Login or Register  to view this content.

The highlighted values may be changed to suit your own requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg

Thank you so much for this. Routine 1 worked perfect however routine 2 threw up a run time error - "Run-time error 13" Type mismatch.

Again thank you so much for your help on this, much appreciated.

Kind regards

Abdul

Hi again,

The versions I posted work correctly on my installation, but a possible Type Mismatch problem (for which I previously tested) might be avoidable by using the following versions:

Please Login or Register  to view this content.

Changes/additions to the previous versions have been highlighted.


Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

Hi Greg

That worked perfectly. Thank you so much for your help.

Kind regards

Abdul

Hi again,

Many thanks for your feedback - I'm glad I was able to help.

Best regards,

Greg M