Technovice
New Member
- Joined
- Jan 12, 2023
- Messages
- 6
- Office Version
- 2019
- Platform
- Windows
Hello,
I need some help with writing a VBA code to add to a button in excel that does the following;
* opens an existing word document (with specified file path)
* Copies and pastes cells from excel into the word document at a set paragraph/line
* When saving the word document, suggest a file name based on cell value in excel
I'm struggling to put all of these things together into VBA.
Thankyou in advance!
I need some help with writing a VBA code to add to a button in excel that does the following;
* opens an existing word document (with specified file path)
* Copies and pastes cells from excel into the word document at a set paragraph/line
* When saving the word document, suggest a file name based on cell value in excel
I'm struggling to put all of these things together into VBA.
Thankyou in advance!