Hi experts,
Here is a code snippet that i am using from within an Access 2000 module to copy the end-30 columns of a spreadsheet into the next 30 empty cols:
The first row, which contains the headings, copies fine, but all of the rest of the cells mysteriously (to me) do not copy the contents of the cells from the source, nor the formatting (which I beleive is both the formulae and the color stuff - all of which I want, but offset of course).
Instead, all the cells are default white and contain "0" and have a sum formala for every cell (which does not exist in the source).
So, I want to , for example, copy columns DEF(which have data, and say, F has a formula that utilizes D and E) to GHI, and have GHI be identical to DEF, same color fomatting, same formula in F, but the formula offset of course to reflect the new column locations.
As usual, what am I missing?
TIA,
Jeff
Here is a code snippet that i am using from within an Access 2000 module to copy the end-30 columns of a spreadsheet into the next 30 empty cols:
Code:
objExcelSheet.Range _
(strExistingBegColHeader & "1" & _
":" & strExistingBegColHeader & intNumberOfRows).Copy
objExcelSheet.Paste Destination:=objExcelSheet.Range(strBegNewColHeader & "1" &
":" & strEndNewColHeader & intNumberOfRows)
The first row, which contains the headings, copies fine, but all of the rest of the cells mysteriously (to me) do not copy the contents of the cells from the source, nor the formatting (which I beleive is both the formulae and the color stuff - all of which I want, but offset of course).
Instead, all the cells are default white and contain "0" and have a sum formala for every cell (which does not exist in the source).
So, I want to , for example, copy columns DEF(which have data, and say, F has a formula that utilizes D and E) to GHI, and have GHI be identical to DEF, same color fomatting, same formula in F, but the formula offset of course to reflect the new column locations.
As usual, what am I missing?
TIA,
Jeff