Xls to Xlsx LISP updation

[Yamishon_Noah]

Hi

I have attached lisp working with *.XLS files.

is it possible to update lisp to work with *.XLSX ?

Thanks

Yamishon

Xls

[patrick_35]

Hi

Yes, you change "xls" by "xlsx" or "xlsx;xls"

For example

(getfiled " Select Excel File" Pathname$ "xlsx;xls" 20)

@+

[Yamishon_Noah]

Thanks Patrick

Now it is enabled me to select *.xlsx file but lisp is unable to read the file..

Please let me know, what else should I change with it?

Yamishon

[patrick_35]

Normally, you have nothing to do because you call Excel

(setq ExcelApp% (vlax-get-object "Excel.Application"))

So for him, opening an xls or xlsx file makes no difference.

An example to open an Excel file

(setq xl (vlax-get-or-create-object "Excel.Application"))
(setq file (findfile "My_File.xlsx"))
(vla-put-visible xl :vlax-true)
(setq wks (vlax-get xl 'Workbooks))
(setq xls (vlax-invoke wks 'open file))

@+