VBA for MSProject

Microsoft Project
M
Marcio Sampaio 👤 Member for 20 years 7 months
· Permalink

Thanks Michael;



I agree with u.



I already did an Excel x VBA curse. After that, i bought a VBA for MS Project book and learned by myself.



Regards.

M
Michael Bonandrini 👤 Member for 20 years
· Permalink

Hi Marcio



There’s a book for MSProjects that’s called the "Microsoft Projects 2002 Bible" by Hungry Minds inc. This book isn’t specifically for VBA for Microsoft Projects, but there is a couple of chapters dedicated to VBA (but you will struggle if you don’t have any serious VBA experience).



I still recommend getting a book on VBA programming for Excel first, this will guide you properly (especially considering the multitude of books that you can get on Excel VBA).



I would recommend getting a book called "Excell 2002 Power programming" or a later version. You can find out about this book on www.j-walk.com Once youve gone through the book in detail, you won’t need to get a book on Microsoft Projects, because you will understand it immediately.



I hope the above helps

V
vinod raturi 👤 Member for 19 years 9 months
· Permalink



Hi Michael & Zhang



Thanks for your guidance , i would go as per your suggestion.



regards,

Z
Zhang Haixiang 👤 Member for 21 years 1 month
· Permalink



If you can use Basic, then VBA is easy.

In Excel/MSP try to record macro,then learn the code using the help file.



It’s important to understand the object model (including object,property,method, event...), it’s the main different between basic & VBA

M
Michael Bonandrini 👤 Member for 20 years
· Permalink

Get yourself the book "Power programming for Excel with VBA"... I used this book to learn VBA. If you can use this book you’ll understand how to use VBA in MS Projects without any trouble whatsoever. It’s comprehensive enough for you to understand MSProjects VBA without the need for a book. Alternatively go to www.vbexplorer.com, download the tutorials and go through them (otherwise just ask & I’ll assist where possible)



If anyone questions what I’m saying... feel free to ask for assistance & I’ll tell.



Regards



Michael Bonandrini

Planning Engineer

V
vinod raturi 👤 Member for 19 years 9 months
· Permalink



hi all ,



I am quite new in planning by software. I am interested in learning VBA , can someone tell me where i can find free tutorial on net for VBA .



it must be quite interesting to make your own commands , as i find people discussing here in this forum.



thanks,

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts