Topic: Read excel (intact open files)

[VovKa]

almost. when we read file but from other sheet than file was saved we need to confirm exit - save or cancel.
Patrick_35 solved close here:

thanx
then we shall change

Code: [Select]

(vl-catch-all-apply 'vlax-invoke-method (list BookObj "Close"))to

Code: [Select]

(vl-catch-all-apply 'vlax-invoke-method (list BookObj "Close" :vlax-false))

[kruuger]

almost. when we read file but from other sheet than file was saved we need to confirm exit - save or cancel.
Patrick_35 solved close here:

thanx
then we shall change

Code: [Select]

(vl-catch-all-apply 'vlax-invoke-method (list BookObj "Close"))to

Code: [Select]

(vl-catch-all-apply 'vlax-invoke-method (list BookObj "Close" :vlax-false))

after few tests all seams to be fine
thanks for your effort
kruuger