Move Open File to Different Folder

Scripting Forums AppleScript | Mac OS X
#1

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
#2 
--Select Location for new file
set FileLocation to choose folder with prompt "Select Folder to Store file in"
# FileLocation is an alias, you must coerce it as string to concatenate with file Name
set destinationpath to (FileLocation as text) & ":" & workbookname

Yvan KOENIG running High Sierra 10.13.6 in French (VALLAURIS, France) mercredi 1 mai 2019 09:59:08

#3

Great thank you very much, I still have a lot to learn,:slight_smile: