Remalay
09-19-2006, 01:03 AM
Hi Guys,
My objective is to copy a .xls master workbook from one location into another, without opening the file, (I would assume using 'SaveAsCopy',) but I am unable to determine the way of acheiving this.
This is a part of an initial setup function to copy a master workbook from a server onto the users' destop/selected folder without activating the code within the workbook.
I am presently stuck with an 'IF' in the master workbook, but would rather avoid this with the decision effectively being made within the setup file.
Any :help or suggestions would be most appreciated.
thanks
remalay
My objective is to copy a .xls master workbook from one location into another, without opening the file, (I would assume using 'SaveAsCopy',) but I am unable to determine the way of acheiving this.
This is a part of an initial setup function to copy a master workbook from a server onto the users' destop/selected folder without activating the code within the workbook.
I am presently stuck with an 'IF' in the master workbook, but would rather avoid this with the decision effectively being made within the setup file.
Any :help or suggestions would be most appreciated.
thanks
remalay