tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
so i need a bit of help with this complex macro
I want to be able to have a macro that does this
the macro is contained in its own documet along with another called update.
when we run the macro it does this.
opens the file explore and asks the user to select the document they wish to open,
if possible check the selected document is xlsm
open the document (it will need the password "Password1234"
then run the othe macro "update" on the opened document and save it.
please help if you can
thabks
tony
so i need a bit of help with this complex macro
I want to be able to have a macro that does this
the macro is contained in its own documet along with another called update.
when we run the macro it does this.
opens the file explore and asks the user to select the document they wish to open,
if possible check the selected document is xlsm
open the document (it will need the password "Password1234"
then run the othe macro "update" on the opened document and save it.
please help if you can
thabks
tony