Re: $$Excel-Macros$$ Copy Each Worksheet in a workbook and save it to Specific Location with time.

Sir, Thanks for the codes. But it lacks two things; 1. Objective is to create Worksheet with Value,Format JPEG image attached in the source worksheet but the Macro copies the worksheet along with formula and excludes JPEG image . 2. If possible is it possible to ask from user to specify which

$$Excel-Macros$$ Copy Each Worksheet in a workbook and save it to Specific Location with time.

Hi, I want a macro to copy each worksheet in a Workbook in specific folder Say H:\31.03.2011_10.04.2011 with File name as name of the active worksheet time of generation. For Example: My Workbook contains 35 sheets named (Brazil,India,US etc) and i ran the macro at say 04:00 then it should Save

Re: $$Excel-Macros$$ Copy Each Worksheet in a workbook and save it to Specific Location with time.

see if it helps change pathbk = C:\Documents and Settings\achamanlalko\Desktop\eforms\eform reports\test workbook\ to the destination folder Sub createworkbooks() Dim i As Long Dim a As Workbook Dim z As String Dim pathbk As String pathbk = C:\Documents and