Smithy1001
Programmer
Hi,
I am using D2010, Win32, COM to communicate with Excel. The plan for my app is to have an excel template in a folder on our server which is pre-formatted, to open that file, copy the formatting to an open workbook which I create on the fly and then close the template. This gets round the need to copy the template to a location and re-open it, I just have it open but as say Book1 unsaved.
How do I do this?
I was planning on copying a Wbk sheet by sheet but I cannot get the .copy fn to work. So the question is, how do I open a wbk, copy it completely to an open fresh Wbk, then close the original?
Thanks
I am using D2010, Win32, COM to communicate with Excel. The plan for my app is to have an excel template in a folder on our server which is pre-formatted, to open that file, copy the formatting to an open workbook which I create on the fly and then close the template. This gets round the need to copy the template to a location and re-open it, I just have it open but as say Book1 unsaved.
How do I do this?
I was planning on copying a Wbk sheet by sheet but I cannot get the .copy fn to work. So the question is, how do I open a wbk, copy it completely to an open fresh Wbk, then close the original?
Thanks