|  | 
| 
			 
			#1  
			 
			
			
			
			
		 | |||
| 
 | |||
|  Help with Folder Picker for Mac 
			
			Hello.  I have a process that works with a PC for a user to select a folder and then process all Word documents in that folder. I need a version that will work with a Mac but don't have a Mac to test with. Hoping someone here can assist. The document is attached, but here is the folder picker code I have cobbled together but can't test. Code: Function fcnFolderPickerMac() As String
Dim strPath As String
Dim strRoot As String
Dim strScript As String
'This is the function that I have no way to test.
  On Error Resume Next
  'Enter the Start Folder, Desktop in this example,
  strRoot = MacScript("return POSIX path of (path to desktop folder) as String") 'How would you change this make the root say "D:\Test" ?
  'Make the path Colon seperated for using in MacScript
  strRoot = MacScript("return POSIX file (""" & strRoot & """) as string")
  'Make the Script string
  strScript = "return POSIX path of (choose folder with prompt ""Select the folder""" & " default location alias """ & strRoot & """) as string"
  'Run the Script
  strPath = MacScript(strScript)
  On Error GoTo 0
  If strPath <> "" Then fcnFolderPickerMac
lbl_Exit:
  Exit Function
 End FunctionThank you. | 
|   | 
|  | 
|  Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
|  Date Picker work-around | enigmaes | Word | 1 | 10-14-2014 07:15 AM | 
| Possible to link a date picker to another date picker? | tubbz | Word | 0 | 05-07-2014 01:23 PM | 
|  Calculating age of something from a Date Picker | BoringDavid | Word VBA | 12 | 01-13-2014 02:40 AM | 
|  Date Picker | Andy2011 | Word VBA | 4 | 11-24-2012 10:07 PM | 
| Date picker | trintukaz | Excel | 0 | 12-30-2011 12:42 AM |