Need a VBA code to save multiple sheets from a workbook to a sharedrive location

S

Shravan5564

New Member
Joined
Jun 9, 2018
Messages
2
Hi, I have an excel workbook where I need to save 4 worksheets among 8 and each one was named. These sheets need to be copied to a specific location with a new workbook. The sheet contains tables with data. the name of the new workbook should be of today's date. As we do this on a daily basis. Please requesting you to help me with this.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
509
Insurance Dave
I
willow1985
  • Solved
VBA error handling - File already exists in location
Replies
9
Views
292
NateSC
NateSC
B
  • Question
Save workbook to a specific location and override file with same name.
Replies
5
Views
238
jkpieterse
jkpieterse
J
  • Question
VBA code to save active sheet in new file
Replies
3
Views
773
Jason1H
J
R
  • Question
VBA to Copy Multiple sheets to new workbook & save as .xlsb or .xlsx
2
Replies
16
Views
1K
rahildhody
R

Forum statistics

Threads
1,217,371
Messages
6,136,172
Members
449,996
Latest member
duraichandra

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top