Opening password protected excel workbook - Issue

Scripting Forums AppleScript | Mac OS X
#1

Hi All,

while trying to develop a droplet. I have some issues in opening password protected excel workbook. Below code works fine opening “.xlsx” extension files, but does not work with “.xls” files. But the thing is, most of our files are “.xls” file.
Any help will be appreciated to open the “.xls” password protected excel.


on open dropped_file
	set getFileDetail to POSIX path of dropped_file
	set AppleScript's text item delimiters to "/"
	set NameOfFile to last text item of getFileDetail
	tell application "Microsoft Excel"
		activate
		open workbook workbook file name NameOfFile password "abc"
[more codes here to do other actions from the spreadsheet]
	end tell
end open

Many Thanks In Advance

Browser: Safari 533.19.4
Operating System: Mac OS X (10.6)

#2

Further information:

I have noticed that this script does not work with .xls file originated from WIndows excel.

When i drop .xls file to the droplet, it throws a an error message "Can’t continue .

Still not sure how to address the issue.

Any help will be much appreciated.