Excel save with overwrite currently not supported
Excel save with overwrite currently not supported
- Subject: Excel save with overwrite currently not supported
- From: Thomas Maffucci via AppleScript-Users <email@hidden>
- Date: Tue, 27 Aug 2019 13:36:08 -0400
Still Get Save Alert Message
A file named '/Users/thomas/Desktop/Quicken/AllQport.xlsx' already exists in
this location. Do you want to replace it? Yes No Cancel
set sd to path to startup disk
tell application id "com.microsoft.Excel" -- Microsoft Excel
try
close sd -- will error
end try
end tell
tell application "Microsoft Excel"
launch
activate
set Shtno to 1
set newBook to make new workbook
set {lft, tp, rgt, bot} to {1142, 25, 2550, 687}
set the bounds of the front window to {lft, tp, rgt, bot}
select range "A1"
--paste Quicken data from clipboard
paste special on worksheet sheet "Sheet1" format Unicode text
display dialog "How does it look"
save workbook as newBook filename "Macintosh
HD:Users:Thomas:Desktop:Quicken:AllQport.xlsx"
end tell
Log As Follows
tell current application
path to startup disk
end tell
tell application "Microsoft Excel"
close alias "Macintosh HD:"
launch
activate
make new workbook
set bounds of window 1 to {1142, 25, 2550, 687}
select range "A1"
paste special on worksheet sheet "Sheet1" format Unicode text
display dialog "How does it look"
save workbook as workbook "Book4" filename "Macintosh
HD:Users:Thomas:Desktop:Quicken:AllQport.xlsx"
end tell
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden