open excel and get the data

[BradWong]

Good morning

I have an other problem, I want to update the data which I get for my oracle
database but I don't know how to do it.
So if you know how doing this you will help me a lot.
But if we can't i would like to know how I can't make with VBA a copy of all
my data of the excel file and paste it in project

Thank you

 

[Stephen Sanderlin]

This does not belong in this newsgroup.



Try microsoft.public.excel.programming.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[Jan De Messemaeker]

Hi,

I wouldn't copy paste.
If you want to do an all in one operation rather look to the FileOpen method
in project (after making a map manually, that is too heavy in VBA)

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]

Can you read your data in Excel using MSQuery? Then you can look at reading
it from Excel to Project. How many Tasks? If less than a 1000 reading data
directly using OLEDB and creating Tasks etc on the fly doesn't take long.

--

Rod Gill
Microsoft MVP for Project

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

 

[Stephen Sanderlin]

My mistake, I missed where you mentioned project. I thought you were
only asking about getting information from Oracle into Excel )



Rod and Jan's answers should help you out!


--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com





"Stephen Sanderlin" <stephen NS-DOT sanderlin A-NS-T msprojectexperts
DOT-NS com

wrote in message <news:[email protected]>:

This does not belong in this newsgroup.



Try microsoft.public.excel.programming.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com