Thread: Save Botton
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mallycat
 
Posts: n/a
Default Save Botton

Wrote:
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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=557525

Reply With QuoteReply With Quote