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)
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Hi, Nitefox,
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
http://www.mrexcel.com/forum/excel-q...-file-mac.html
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Sorry Holger, here is a link to a similar question I asked a few days ago, from which I was not able to find an answer. I have been looking all over the internet on how to do this on a Mac, but I cant find an answer anywhere:
http://www.excelforum.com/excel-prog...-computer.html
Thank you for your response Roy. I tried that code but it didnt seem to do anything. But it didnt come up with an error of any kind either. I tried a different file but still no luck.
Would it make things easier if i was to put it in the root directory of the computer? I was just hoping I could put it in the same place as the Workbook, but is that confusing things?
Thanks,
James
First test - does the correctfile variable have the right value?
Im not sure, how would I test that? The file name and extension is correct.
The MacScript command will only run a file that contains an AppleScript.
Typicaly, those files have a .scpt pseudo-tag. (Mac treats tags like part of the file name)
Last edited by mikerickson; 10-19-2013 at 06:34 PM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I tried changing it back to a script file, and ran the following:
correctFile = ThisWorkbook.Path & Application.PathSeparator & "Camera Log Backup.scpt"
However it had the same effect. Nothing happened, but there was no error.
See my prevous post.
Sorry im not following you. I tried using an apple script as you recommended in your pervious post but that did not work.
What's actually in your script file?
To test the file name variable you can add a
line to the code.Please Login or Register to view this content.
When i add that line the message box displays the correct extension for the location of the file, but it doesn't run the file. I tried using different files, but it still isnt running them.
What is in the file?
How was the file created?
Unless the file was created with Macintosh's Script Editor program (or the equivalent), the VBA MacScript function won't cause it to run.
If the file will run on a Windows system, the VBA MacScript function won't cause it to run.
Its an apple script I created with the AppleScript Editor.
The apple script checks for an internet connection, then uses the FTP Application Transmit to backup the Excel workbook to my online server:
Please Login or Register to view this content.
I created a simple AppleScript file "test.scpt" and it worked for me
Please Login or Register to view this content.
When i first ran that code (with the name of my script file on the third line) it asked for the location of the file, which I gave it. It then came up with a Run Time 5 error on the last line (MacScript myPath). When i run it now, it no longer asks for the location of the file, it just comes straight up with that run time 5 error.
It sounds like the AppleScript is interfearing with the Excel somewhere.
Have you tried running that script (not from Excel) with the application "Transmit" not open?
When i run the apple script in the finder it works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks