Appending to workbook and worksheet
I have two related questions:
Precondition: the code has to be late bound because I won't know if the
client has a reference to excel. I am doing the coding from Word VBA -
exporting data from Word to Excel.
1. If a workbook is open, what would the code to append a new sheet to
the activeworkbook ( and get a reference to said worksheet)
2. If a workbook is open, what would the code be to append to the
activesheet - I need to put the data starting where the data on the
sheet ends.
TIA.
P.S. How can I tell if no excel is running at all, so none of the above
errors out?
|