Reading Excel data from Project

[glenn]

Using VBA can I open an Excel file and read the data
from a Project file?

thanks

 

[JackD]

Yes.
I have examples of opening excel and writing to it from project at my
website.

http://masamiki.com/project/macros.htm

There is not much difference between reading and writing or between starting
in excel or project.

 

[glenn]

Jack,

When I put the following line of code into VBA via Project, I
a message stating "Compiler Error - User Defined Type Not
Defined"

Dim xlApp As Excel.Application

Can you help me out?

Thanks,
glenn

 

[Jan De Messemaeker]

Hi Glenn,

In VBE: Tools, References, check on Microsoft Excel
HTH

 

[Glenn]

Hi again,

OK, I selected the Microsoft Excel Object from Tools, References in the VBE

Can you tell me what the syntax would be to create an Excel object?

I tried Dim xlApp As Application.Excel and I got a type mismatch error.

Thanks again,
glenn

 

[Jan De Messemaeker]

Dim xlAPP as excel.application
set xlapp=createobject("Excel.application")
HTH