I've got the script working great as previously noted, but I'm trying to allow a user to select which file and directory to output to.
-- Paths to Excel file and output directory
set theFile to (choose file with prompt "Select the Excel Spreadsheet to Convert:")
set outputDirectory to (choose folder with prompt "Select Folder to Output To:")
tell application "Microsoft Excel"
activate
set theWorkbook to open workbook workbook file name theFile
set maxCount to count of worksheets of theWorkbook
repeat with i from 1 to maxCount
set theWorkbook to open workbook workbook file name theFile
set theWorksheet to worksheet i of theWorkbook
set worksheetName to name of theWorksheet
activate object worksheet worksheetName
save as theWorksheet filename (outputDirectory & ":" & worksheetName & ".csv") file format CSV file format with overwrite
close active workbook saving no
end repeat
end tell
Its failing at the first open block. Any ideas?