tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I'd like a macro to do this,
on click Open the folder Dialog Box, showing current file location
ask me to choose a Document to open and open it
copy from opem document active sheet range "A2:E2"
paste into this document active sheet first empty row column H
then if possible, move the select document from its current location to ThisWorkbook.Path & "\" & "Uploaded" (so I know which i've uploaded and which ive not.)
I'd like a macro to do this,
on click Open the folder Dialog Box, showing current file location
ask me to choose a Document to open and open it
copy from opem document active sheet range "A2:E2"
paste into this document active sheet first empty row column H
then if possible, move the select document from its current location to ThisWorkbook.Path & "\" & "Uploaded" (so I know which i've uploaded and which ive not.)