Having some difficulty in in manupulating some Excel Worksheet functions from an external VBSript application (either standalone or client-side web page).
In general, I am not able to get a 'row insert' to work and a succeeding copy and paste.
Specifically, I am using a function to insert a new row above the row of the cell that is currently active and selected. After that, I want to take the contents of the row I was on (formats and formulas etc) and paste that onto the new row.
At this point, the code has an excel.application object set and the required worksheet object set, and it know the specific cell locations, row numbers etc.
looking for a snippet of code that will do this. The code created for VBA to do this is not able to be run under VBScript.
Thanks,
Martyn s-)
In general, I am not able to get a 'row insert' to work and a succeeding copy and paste.
Specifically, I am using a function to insert a new row above the row of the cell that is currently active and selected. After that, I want to take the contents of the row I was on (formats and formulas etc) and paste that onto the new row.
At this point, the code has an excel.application object set and the required worksheet object set, and it know the specific cell locations, row numbers etc.
looking for a snippet of code that will do this. The code created for VBA to do this is not able to be run under VBScript.
Thanks,
Martyn s-)