I want to pull data from a document - document/location saved as variable name FullPullFromPPTFileName.
generally I want to
- start with one file
- do yes - individual actions as below
- change FullPullFromPPTFileName to next document and repeat process
my desired steps are
- check to see if document exists in folder
- yes - exists
- individual actions will be added later...
- reset value of FullPullFromPPTFileName variable and start again with the new document
- no - does not exist
- ask user if they want to load file or skip this step
- load file
- let user load file
- user hits an option "reload file"
- recheck if file is in folder (start loop over again)
- skip step
- user hits option of "skip document"
- reset value of FullPullFromPPTFileName variable and start again with the new document
This is the part I need help on
If Dir(FullPullFromPPTFileName) <> "" Then
'actions - to be added later
Else:
'***** This is the part I am not sure about***
'ask user if they want to load file or skip this step
'Load file
'let user load file
'user hits an option "reload file"
'recheck if file is in folder (start loop over again)
'Skip step
'user hits option of "skip document"
'reset value of FullPullFromPPTFileName variable and start again with the new document
End If