I have a master workbook named "workbook1" which a user is required to populate with information from a separate document always called "companydoc" which is downloaded from a program. I am trying to create a macro to perform a copy and paste from this read only file. I know how to assign a shortcut key to a macro which is ideally what I would like to do but I'm not familiar with how to write this kind of code.
The title of the document that is downloaded from the company program is always "companydoc" and defaults to a read only format.
This entire document needs to be Unmerged and Centered and pasted into sheet1 of workbooks starting at cell a1. I am currently clicking paste special-all using source theme.
I am trying to create a macro which does this process automatically. The user would be required to have "workbook1" already open and after clicking the download to excel feature in the company program, the user can simply press a shortcut key to automate the copy and paste feature.
Any suggestions?
The title of the document that is downloaded from the company program is always "companydoc" and defaults to a read only format.
This entire document needs to be Unmerged and Centered and pasted into sheet1 of workbooks starting at cell a1. I am currently clicking paste special-all using source theme.
I am trying to create a macro which does this process automatically. The user would be required to have "workbook1" already open and after clicking the download to excel feature in the company program, the user can simply press a shortcut key to automate the copy and paste feature.
Any suggestions?