ardadogan
06-14-2007, 08:00 AM
hi,
i've been trying to find a solution to this problem but nothing i could find on the web seem to be able to solve it.
i'll simplify it as much as i can.
let's say i have two workbooks:
TEMPLATE.XLS with two sheets named
SHEET1 & SHEET2
123456.XLS again with two sheets named
SHEET1 & SHEET2
as 123456.XLS is made of the TEMPLATE.XLS, they have exactly same structures.
i want to replace SHEET1 in 123456.XLS with the SHEET1 in TEMPLATE.XLS.
it sounds like a very straightforward process: a macro to copy the sheet accross workbooks should do the trick BUT it doesn't. it does copy, but excel keeps forming references to TEMPLATE.XLS.
i know these references can be removed with a macro - but it's not only cells, i have plenty of buttons, combo boxes, radio boxes etc in the sheet so i just don't know how to have a reference-free sheet.
all i want is a one-to-one copy with no intervention from excel - as if i cut that part of the file and pasted it into the new one / i just want to transfer that EXACT sheet to the new workbook - it really shouldn't be that complicated.
is there a code line that'll just disable excel's supposedly smart reference forming thing?
or how else can i solve this?
i'd really appreciate any answer as i really need this desperately.
thank you so much,
arda
i've been trying to find a solution to this problem but nothing i could find on the web seem to be able to solve it.
i'll simplify it as much as i can.
let's say i have two workbooks:
TEMPLATE.XLS with two sheets named
SHEET1 & SHEET2
123456.XLS again with two sheets named
SHEET1 & SHEET2
as 123456.XLS is made of the TEMPLATE.XLS, they have exactly same structures.
i want to replace SHEET1 in 123456.XLS with the SHEET1 in TEMPLATE.XLS.
it sounds like a very straightforward process: a macro to copy the sheet accross workbooks should do the trick BUT it doesn't. it does copy, but excel keeps forming references to TEMPLATE.XLS.
i know these references can be removed with a macro - but it's not only cells, i have plenty of buttons, combo boxes, radio boxes etc in the sheet so i just don't know how to have a reference-free sheet.
all i want is a one-to-one copy with no intervention from excel - as if i cut that part of the file and pasted it into the new one / i just want to transfer that EXACT sheet to the new workbook - it really shouldn't be that complicated.
is there a code line that'll just disable excel's supposedly smart reference forming thing?
or how else can i solve this?
i'd really appreciate any answer as i really need this desperately.
thank you so much,
arda