Need to save individual sheets in a workbook as different files

**aparnawangu** · 01-31-2018, 12:10 PM

Hi Team,

I have a workbook in excel containing 3 tabs .I want to save these three tabs as 3 different files in excel.Please help me out how can I achieve this.

Regards
Aps

**bakerman2** · 01-31-2018, 12:44 PM

Something basic to start with.

Please Login or Register  to view this content.

**aparnawangu** · 01-31-2018, 12:58 PM

Hi bakerman,
Thanks for a quick response.I would like to understand as a layman as I am new to macro coding.In this code which line tells the compiler that there r 3 tabs n save them as separate files and also what does / indicates and how to give full path of the file.Please help me with an example.
Thanks much
Aps

**bakerman2** · 01-31-2018, 09:46 PM

Please Login or Register  to view this content.

Need to save individual sheets in a workbook as different files

LinkBack

Thread Tools

Rate This Thread

Display

Need to save individual sheets in a workbook as different files

Re: Need to save individual sheets in a workbook as different files

Re: Need to save individual sheets in a workbook as different files

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Command button, save sheets from master workbook to separated new files.(And more)

VBA help to create new files with data and save as individual files with specific names

Macro To save multiple Excel sheets to multiple (individual) PDF Files

[SOLVED] Save Every Worksheet in a Workbook to individual PDF files that use the worksheet name

[SOLVED] Save 1 workbook with individual sheets & formats.

Help importing multiple text files to individual sheets in an excel workbook

[SOLVED] How do I save sheets in a workbook to separate files?

Bookmarks

Bookmarks

Posting Permissions