VBA for MSProject
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
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.
Hi Marcio
Theres a book for MSProjects thats called the "Microsoft Projects 2002 Bible" by Hungry Minds inc. This book isnt specifically for VBA for Microsoft Projects, but there is a couple of chapters dedicated to VBA (but you will struggle if you dont 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 wont need to get a book on Microsoft Projects, because you will understand it immediately.
I hope the above helps
On Amazon u can find books about VBA for MSP.
Regards.
Hi Michael & Zhang
Thanks for your guidance , i would go as per your suggestion.
regards,
If you can use Basic, then VBA is easy.
In Excel/MSP try to record macro,then learn the code using the help file.
Its important to understand the object model (including object,property,method, event...), its the main different between basic & VBA
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
you can start with MS-Project vba help file. there are a lot of sample code.
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,
Excellent, thanks very much.
MyRow = Application.ActiveCell.Task.GetField(pjTaskID)
regard
Hannes de Bruyne