Save Botton

[tr2usa]

I have a Packing list on Sheet1,inventory Sheet2 and Customer info
Sheet3.
Sheet1 linked and formulated to pull data from sheet2 and sheet3. I
added save botton to save each packing list to another
folder(C:\Paking_List06) I would like to know how to write a VBA code
to export Sheet 1 to packing list folder.

Thanks

 

[Mallycat]

I would like to know how to write a VBA code
to export Sheet 1 to packing list folder.

Thanks

the easiest way to learn is to turn on the Macro recorder
TOOLS\MACRO\Record new macro

Then do what you want to do.

right click sheet1, move/copy, SAVE new book AS in the required
location.

Then turn off macro recorder

Alt F11 to open VBA Editor
Find the Module in the browser window on the left and open it.

Edit the code.

Matt