I’m trying to control some aspects of an excel spreadsheet from word.
What I need to do is copy some text from word into certain cells in excel using VBA. This I can do no problem. Before I insert the data into the cells I need to create a new row in the spreadsheet which is where I’m getting stuck.
So how do I insert a new row, preferable copying all the formula from the row above by selecting the row and then inserting copied cells.
This would be easy enough from excel as I would just record a macro but even by doing this and trying to get that code to work in word VBA it does not accept it.