george hart
Board Regular
- Joined
- Dec 4, 2008
- Messages
- 241
Help....
The code below opens specific spreadsheets within a folder and works fine. However, I need code that when the spreadsheet is open it performas a lookup within the master file to capture the relevant information...Basically, I have numerous files/templates that need almalgamating into the master file...
Dim wbOpen As Workbook
Dim wbNew As Workbook
Const strPath As String = "C:\Documents and Settings\HartG\My Documents\Projects\Operations KPI Stats\Data Provider\"
Dim strExtension As String
Application.ScreenUpdating = False
ChDrive strPath
ChDir strPath
strExtension = Dir("Operations KPI*.xls")
Do While strExtension <> ""
Set wbOpen = Workbooks.Open(strPath & strExtension, UpdateLinks:=0)
Code to go here.....
The code below opens specific spreadsheets within a folder and works fine. However, I need code that when the spreadsheet is open it performas a lookup within the master file to capture the relevant information...Basically, I have numerous files/templates that need almalgamating into the master file...
Dim wbOpen As Workbook
Dim wbNew As Workbook
Const strPath As String = "C:\Documents and Settings\HartG\My Documents\Projects\Operations KPI Stats\Data Provider\"
Dim strExtension As String
Application.ScreenUpdating = False
ChDrive strPath
ChDir strPath
strExtension = Dir("Operations KPI*.xls")
Do While strExtension <> ""
Set wbOpen = Workbooks.Open(strPath & strExtension, UpdateLinks:=0)
Code to go here.....
