Save of CSV Formatted File Fails on Excel 15.36 under Sierra
Save of CSV Formatted File Fails on Excel 15.36 under Sierra
- Subject: Save of CSV Formatted File Fails on Excel 15.36 under Sierra
- From: Thomas Maffucci <email@hidden>
- Date: Thu, 20 Jul 2017 14:05:37 -0400
I have written a System with Many Related excel Files in both xlsx and csv
formats.
The following script will drill down to the basic save issue.
Please make the necessary changes to this script to allow it to run properly.
Thank You Very Much
set Testlst to {"Test 11", "Test 12", "Test 13", "Test 21", "Test 22", "Test
23"}
repeat with curTest in Testlst
set Prenam to curTest
my BuildPortal(Prenam)
end repeat
on BuildPortal(Testno)
tell application "Microsoft Excel"
set newBook to make new workbook
activate
--global Shtno
set NewbkNme to name of active workbook
set value of cell ("A1") to Testno
set value of cell ("B1") to "Data Follows"
set value of cell ("A2") to "100"
set value of cell ("B2") to "200"
set thePath to (path to desktop as text) & "Goog Ports:UPL" &
Testno & ".csv"
save workbook as newBook filename thePath file format CSV file
format with overwrite
end tell
end BuildPortal
_______________________________________________
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