Reading Excel Data from Project

[glenn]

Using the following code from Project's VBE, you can launch Excel
automatically.

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Sub showexcel()
' You can also use the return value of the Shell function.
ReturnValue = Shell("c:\EXCEL\EXCEL.EXE", 1) ' Run Microsoft Excel.
AppActivate ReturnValue ' Activate Microsoft
' Excel
End Su
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

My question is this. Is it possible to read data from a UserForm
in Project's VBA without actually launching an Excel spreadsheet?

Thanks,
glenn

 

[JackD]

If you mean a project user form, then yes, you can have project userforms
just like you have in excel.
If all you need is data from a userform why bother with excel at all?
Perhaps I am not understanding your question.

 

[glenn]

Jack,

Let me clarify. I want to read Excel data while in Project from a Project
UserForm without actually opening Excel.

Thanks,
glenn

 

[JackD]

Here is an example which uses the Jet OLE 4.0 DB provider to read and write
to excel files:
http://support.microsoft.com/kb/278973/EN-US/
It requires some structure in the files (named ranges etc.) but if you
structure your file correctly this should work.