I need an AppleScript that does this:
- at 9 a.m., 11 a.m., 1 p.m. and 3:30 p.m. take Document A, copy it to File B. It would leave the original Document A untouched. File B would always have only one copy of Doc A since we are writing over it.
- Then, the copied Doc A inside our target folder would be opened and saved as an Excel 5.0 workbook.
The original Doc A cannot be opened or moved during this process, since it is processing files from multiple computers.
Helpers?
dzelnio
Here’s my sad attempt at it:
tell application “Finder”
activate
select Finder window 1
select Finder window 1
set position of Finder window 1 to {213, 280}
select Finder window 1
end tell
(I couldn’t even get the script to find a specific file in order to move it!)
Model: PowerBook G4
AppleScript: 2.1.1
Browser: Safari 419.3
Operating System: Mac OS X (10.4)
You haven’t said enough, but in general:
- Don’t fiddle with Finder windows. You need a reference to document A of the form:
set DocA to alias (here you put the path to DocA of the form “myHD:Users:Me:Documents:MyFileName.ext”)
the easiest way to get that is to set DocA to (choose file). Same with B if it exists.
-
There is a command “duplicate”. i.e: duplicate alias aPathToFile to alias aPathToTargetFolder with replacing.
The easy way to get the path is with (choose folder).
-
Opening with Excel is just a matter of "tell application “Excel” to open alias pathToItHere. Look at the dictionary of Excel to see how to save it with properties you want.
Read these tutorials on AppleScripting by Craig Smith. They’re brief and informative.
http://macscripter.net/articles/415_0_10_0_C/
http://macscripter.net/articles/428_0_10_0_C/
http://macscripter.net/articles/434_0_10_0_C/
http://macscripter.net/articles/445_0_10_0_C/
http://macscripter.net/articles/452_0_10_0_C/
http://macscripter.net/articles/458_0_10_0_C/
http://macscripter.net/articles/463_0_10_0_C/
http://macscripter.net/articles/467_0_10_0_C/
tell application “Finder”
activate
duplicate,“Big Disk/Other/WordCounts.xls”, to “Big Disk/Other/wcreport”,
replace
tell application Excel to open document file,“Big Disk/Other/wcreport/WordCounts.xls”, save
This is another sad attempt.
Who can I hire to do this?
dzelnio
