I have been trying to work out how to move a file I open to a different folder. It seems as if it should be simple. But the script I have so far loads to the folder the file was opened from. Any suggestions appreciated I have looked on the web v=but without success. This is my script.
--Download Data from the Web
--Should be the last file in "Downloads"
tell application "Finder"
set latestFile to last item of (sort (get files of (path to downloads folder)) by creation date) as alias
end tell
tell application "Microsoft Excel"
activate
open latestFile
set workbookname to "Data Capture.xlsm"
tell application "Finder"
--Select Location for new file
set FileLocation to choose folder with prompt "Select Folder to Store file in"
set destinationpath to FileLocation & ":" & workbookname
display dialog destinationpath as string
end tell
save active workbook in destinationpath
end tell