Export data from Excel to Microsoft Project

Report
Posts
2
Registration date
Wednesday December 2, 2020
Status
Member
Last seen
February 24, 2021
-
Posts
3179
Registration date
Monday November 25, 2019
Status
Administrator
Last seen
October 7, 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
3179
Registration date
Monday November 25, 2019
Status
Administrator
Last seen
October 7, 2021
6,745
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