Get a workbook to import data when openeing and export when closi.

[Guest]

How can I get excell to import data from a closed workbook. Then when changes
have been made, export and save the data to the workbook the data came from,
overwriting what is contained in it.

 

[Guest]

why not just open the closed WB with code, make all the
changes with code the save and close the WB with code.

ChDir "S:\PUBLIC\Some"
Workbooks.Open Filename:="\\data\PUBLIC\youfile.xls"
put code to make changes goes here
ActiveWorkbook.Save
ActiveWorkbook.Close

 

[Guest]

I cant do that as the code that is in the current workbook is written in a
way that it has to be the only one open. Otherwise it falls over with Run
Time errors. If it where that easy I would not be bald from pulling my hair
out.