Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Close
Hi everyone
I have a command button which takes the value of A20, opens another .xls file and pastes the value in A20 of the new file (the new file has been assigned to variable cd). It is then supposed to close and save the new file with the following code: Workbooks(cd).Close SaveChanges = True But it doesn't save the changes. I don't know if it is because the command button is in the first .xls file or not though. Any Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbooks close before | Excel Programming | |||
How to close All Workbooks | Excel Programming | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
close all other workbooks | Excel Programming | |||
Close all other workbooks but this one? | Excel Programming |