Hi.


Do I need to use the full path in VBA code i.e.

GetSheet = "FTP " & DailyDate
Set wb = Workbooks.Open("C:\Users\***\***\****\Archives")
Windows("Archives").Activate
Sheets(GetSheet).Select
Sheets(GetSheet).Copy After:=Workbooks("Daily Reports.xls").Sheets(1)
wb.Close False


this if fine while under development on one pc. The code will have a number
of workbooks in one folder on a network. It will be accessed by a number of
pc's. can I shorten this path so that it just looks in the folder where all
the workbooks will be stored?

Thanks,

Albert