Save Data to a Closed Workbook.

[adamsm]

Hi,

I'm trying to figure out a code that would save data in workbook1 sheet1 to workbook2 sheet1 when the workbook2 is closed; through a macro button.

Any help to do so would be kindly appreciated.

[Simon Lloyd]

Why not open workbook2 first via code then save?

[mdmackillop]

Why not open workbook2 first via code then save?
I tend to agree.

[adamsm]

I tend to agree.

I do agree your suggestion. But how can it be done without letting the user know that the workbook2 opens & then closes by saving data.

[Simon Lloyd]

Application.screenupdating=False

[mdmackillop]

We don't know the circumstances, but you could also consider not saving to Book 2, but taking the information into Book 2 from Book 1 when Book 2 is opened.