View Full Version : Save Data to a Closed Workbook.
adamsm
06-16-2010, 05:20 AM
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
06-16-2010, 10:30 AM
Why not open workbook2 first via code then save?
mdmackillop
06-16-2010, 03:04 PM
Why not open workbook2 first via code then save?
I tend to agree.
adamsm
06-20-2010, 05:47 AM
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
06-20-2010, 12:58 PM
Application.screenupdating=False
mdmackillop
06-20-2010, 01:16 PM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.