Macro for auto archiving a version of a workbook and harcoding formulae within it

C

catzeyes

New Member
Joined
Aug 27, 2013
Messages
4
I am really new to Macros. I have devised a workbook which I would ideally like to archive a hardcoded version of at a particular time every Monday and to a particular network path. Is this possible to do? I am not sure how to write macro codes and seem to be struggling with finding the relevant code online. Any help would be appreciated. I am working in Excel 2012.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
You must log in or register to reply here.

Similar threads

B
  • Question
Event code to give message box and change color of auto-shape
Replies
4
Views
229
bh24524
B
M
  • Question
Custom Ribbon Macros point to old workbook
Replies
4
Views
90
Jeffrey Mahoney
Jeffrey Mahoney
R
  • Question
VBA to pull data from closed workbooks
Replies
3
Views
520
Logit
Logit
E
  • Solved
Excel VBA Macro for Cell Formatting
Replies
6
Views
324
kevin9999
K
M
  • Question
Workbook Event Macros Triggering in Other Workbooks
Replies
7
Views
869
Anthony P Rose
A

Forum statistics

Threads
1,215,327
Messages
6,124,294
Members
449,149
Latest member
mwdbActuary

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