![]() |
|
#1
|
|||
|
|||
![]()
Hello,
This code currently does NOT exit gracefully when clicking cancel. It causes a "Run time Error '5': invalid proedure call or argument." I am thinking the problem occurs because there is no possible value to assign to 'Fldr', but then I also would have thought 'Exit Sub' meant Exit Sub now!! Code:
With Application.FileDialog(msoFileDialogFolderPicker) .InitialFileName = "G:\Admin - MASTER\Customers\" .AllowMultiSelect = False .Title = "Select Destination Folder for the SWMS" If .Show = -2 Then Exit Sub Fldr = .SelectedItems(1) End With Regards from a brisk Queensland |
#2
|
||||
|
||||
![]()
As we've previously discussed, you could use the GetFolder function I've previously supplied and demonstrated...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
I really struggled with understanding the code you supplied. I couldn't work out how to preset the starting folder. Neither do I understand about Functions. (keeping in mind the whole project has been developed by semi-mindless fingers crossed copy paste and hope..)
I'll give it another shot though. The code above presumes the user will select OK to continue. Would it work if the code presumes the user selects cancel and only explicitly continues on OK. I am thinking something like: If .Show = -1 then continue, Else End Sub. ( I am not sure how to write this correctly, I'll try again tomorrow) Regards from Queensland |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Refering figure number too text | danzi | Word | 1 | 01-20-2012 12:13 PM |
Refering to photos on other pages | woodfind | Word | 1 | 05-17-2010 01:52 AM |