ExcelBanter - sav excel doc in various folders one click

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sav excel doc in various folders one click (https://www.excelbanter.com/excel-discussion-misc-queries/10667-sav-excel-doc-various-folders-one-click.html)

geo

sav excel doc in various folders one click

How to save an excel doc in several folders with one click?

Ron de Bruin

Hi geo

You can use SaveCopyAs, see the Excel help for more information.

Sub test()
ActiveWorkbook.SaveCopyAs "C:\ron.xls"
ActiveWorkbook.SaveCopyAs "C:\Data\ron.xls"
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl

"geo" wrote in message ...
How to save an excel doc in several folders with one click?

All times are GMT +1. The time now is 08:03 PM.