Export data from Excel to Microsoft Project

Report
Posts
2
Registration date
Wednesday December 2, 2020
Status
Member
Last seen
February 24, 2021
-
Posts
2285
Registration date
Monday November 25, 2019
Status
Administrator
Last seen
April 6, 2021
-
Hi Guys,

Could someone help me in telling a way to export the data from excel to Microsoft Project automatically without having to use the import wizard in Project again and again to make a timeline.

I mean, I just want a button which upon clicking exports everything from excel to the Microsoft project.

May be with some macros VBA. I am not sure and I am very new to it.

Please help me ASAP and explain it to me in a simple way

I shall be highly thankful

Besy regards,
Anup

1 reply

Posts
2285
Registration date
Monday November 25, 2019
Status
Administrator
Last seen
April 6, 2021
3,860
Hello, in most of the guides that I've had a quick look at, they include the import wizard.

Although I did find this on Stackoverflow. The are using VBA to import excel into MS project. There is some code that could help you out.

Regards

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!