Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
***Sorry I'm reposting because I placed it in the wrong category****
I have a macro that goes into a folder, grabs all excel documents and combines into one workbook. I want to move that particular file after its combined to the master file. Basically, I have two folders 1. New 2 Old I use the code below. Once I use the file I would like to move it to the Old Folder. So, the next day it will be ready for the next group of files. Thanks Application.EnableEvents = False Application.ScreenUpdating = False Path = "c:\new" ''Change as needed FileName = Dir(Path & "\*.xls", vbNormal) Do Until FileName = "" Set Wkb2 = Workbooks.Open(FileName:=Path & "\" & FileName) For Each WS In Wkb2.Worksheets WS.Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Cou nt) Next WS Wkb2.Close False FileName = Dir() Loop Application.EnableEvents = True Application.ScreenUpdating = True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pulling pdf files from general folder to specific folder | Excel Discussion (Misc queries) | |||
Copying all files in a folder to new folder | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
How to copy 30 csv files from a folder to another folder | Excel Programming |