Export data from Excel to Microsoft Project

Closed
Anup27 Posts 2 Registration date Wednesday December 2, 2020 Status Member Last seen February 24, 2021 - Feb 24, 2021 at 06:27 AM
David Webb Posts 3177 Registration date Monday November 25, 2019 Status Administrator Last seen May 15, 2023   - Mar 11, 2021 at 03:42 AM
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
Related:

1 response

David Webb Posts 3177 Registration date Monday November 25, 2019 Status Administrator Last seen May 15, 2023   6,927
Mar 11, 2021 at 03:42 AM
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