P
Pass-the-Reality
I am trying to use a Macro to run a query and update an exisiting Excel
Spreadsheet. I have the following actions
OpenQuery
RunCommand (SelectAllRecords)
RunCommand (Copy)
RunApp
The above actions open the query, select all, copy and then my Excel
Spreadsheet opens. What do I need to add to get the Macro to paste the data
in A1 on my spreadsheet?
Spreadsheet. I have the following actions
OpenQuery
RunCommand (SelectAllRecords)
RunCommand (Copy)
RunApp
The above actions open the query, select all, copy and then my Excel
Spreadsheet opens. What do I need to add to get the Macro to paste the data
in A1 on my spreadsheet?