ExcelBanter - Excel vx Application

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel vx Application (https://www.excelbanter.com/excel-programming/325067-excel-vx-application.html)

Excel vx Application

Hi all,

I have noticed that there is an object called "Excel". Is it the same as
"Application" object? If No, what's the difference? Please advice.

Frederick Chow
Hong Kong.

Excel vx Application

No. Excel is the library and Application is the class.

? excel.xlFileformat.xlExcel2
16
? application.xlFileformat.xlExcel2
produces an error.

--
Regards,
Tom Ogilvy

"Frederick Chow" wrote in message
...
Hi all,

I have noticed that there is an object called "Excel". Is it the same as
"Application" object? If No, what's the difference? Please advice.

Frederick Chow
Hong Kong.

Excel vx Application

Thanks a lot. Actually I have a vague concept between "Library" and "Class".
I think I have to read more abou this soon.

Frederick Chow.

"Tom Ogilvy" wrote in message
...
No. Excel is the library and Application is the class.

? excel.xlFileformat.xlExcel2
16
? application.xlFileformat.xlExcel2
produces an error.

--
Regards,
Tom Ogilvy

"Frederick Chow" wrote in message
...
Hi all,

I have noticed that there is an object called "Excel". Is it the same as
"Application" object? If No, what's the difference? Please advice.

Frederick Chow
Hong Kong.