I am looking for some VB code to run an app script file located in the same directory as the workbook on a mac computer. This is the code I have so far, but it is currently creating a run time 68 error on this line: checker = Dir(correctFile) correctFile = "/Camera Log Backup.app" checker = Dir(correctFile) If checker = "" Then correctFile = Application.GetOpenFilename("Text Files (*.app), *.app") 'not found, open dialog for manually search temp = MacScript(correctFile)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VB to run a file on MAC

Thread starter Nitefox
Start date Oct 18, 2013

Nitefox

New Member

Oct 18, 2013

I am looking for some VB code to run an app script file located in the same directory as the workbook on a mac computer. This is the code I have so far, but it is currently creating a run time 68 error on this line: checker = Dir(correctFile)

Code:

[LEFT]correctFile = "/Camera Log Backup.app"
checker = Dir(correctFile)
If checker = "" Then correctFile = Application.GetOpenFilename("Text Files (*.app), *.app")  'not found, open dialog for manually search
temp = MacScript(correctFile)
[/LEFT]