Call Excel Function from MS Project

[dbonline]

I want to create a lookup table in Excel that will be used by a macro in MS
Project. Is it possible to run a Macro in MS Project that calls a function
in Excel to return a value? Or is there some other way to look up a value in
Excel without using an Excel function?

 

[Jan De Messemaeker]

Hi,
By all means you will have to connect to the Excel application (f.i. through
CreateObject or GetObject).
Then you can find any value (probvided you know where it is) as follows:
Xlapp.activesheet.cells(Rownbr,ColNbr).value

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Rod Gill]

I would keep the Excel functions in Excel, but create one or more named cell
that provides the data for the function then read the value from the cell
with the function. I do a lot of reporting in Excel and use it a lot.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Mike Glen]

Hi ,

Try posting on the developer newsgroup as this one is closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP