Re: $$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Thanks ITWare for replying. Your answer works too. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thr

$$Excel-Macros$$ Re: VBA to copy data to a template file then save it as a new file

Someone has helped me figure out the code. I just want to share it here, so hopefully someone else may find it useful. Sub CreateBooks() Dim xlBook As Workbook Dim xlNewBook As Workbook Dim xlSheet As Worksheet Dim LastRow As Long Dim i As Long Const strPath As String = "*C:\Path to Save Files\*

$$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Hi, I'm hoping to get some help here to automate the work that I have to do every 2 weeks. The work is repetitive and hopefully a VBA script will help shorten sometimes a day's work to minutes. I'm using Excel 2007. There are 2 files. File A: This file is generated every 2 weeks. The data I