Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Can i get some help on Macros

4 replies [Last post]
Sun, 2007-12-16 08:21
Balu Karunakaran
User offline. Last seen 11 years 47 weeks ago. Offline
Joined: 16 Dec 2007
Posts: 32
Groups: Civil Engineering
How can i learn the fundamentals of macros and from where?
Top

Replies

Tue, 2008-01-08 22:06
#1
K D
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Hi Horlen.
Primavera use Java API to access data. So I think we better learn Java. :-)

But for macro, we can use Primavera SDK to handle it.
THanks
Top
Mon, 2008-01-07 16:39
#2
Andrew Dick
User offline. Last seen 8 years 14 weeks ago. Offline
Joined: 14 Feb 2007
Posts: 295
Groups: Regional Representatives, The GrapeVine
I have taught myself basic macros by planning the steps I need to do, and then recording those actions as I go using the record new macro function.

If you take the time, you can then edit the macro and get an understanding of how the thing works.

Even better if you are doing several worksheets with the same formatting you can do one, then in the edit function you can copy and paste the remainder and just change the worksheet reference number. Always remember when you record your first one to do all the steps from the start up to and including the 2nd step on the next sheet, that way you get the loop.

I have also used them quite successfully in conjunction with HTML batch reports to generate wads of data in very short times out of Primavera, I have found this invaluable.

Andy
Top
Mon, 2008-01-07 08:39
#3
Horlen Astudillo
User offline. Last seen 16 years 1 week ago. Offline
Joined: 3 Jan 2008
Posts: 6
Groups: Petro-Chem / Oil & Gas
Hello,

Macros can run over many applications that complaint with Ms VBA, Visual Basic for Applications, if you know some about Visual Basic, so it will be easier to learn about the specific application that you want automate. e.g. as K.D. said Ms Excel is VBA capable so in this case you have to learn about the objects, methods, events, and fuctions that Excel offer for programing.

Other all Ms Office applications are VBA capable, and other Control software, I dont konw if Primavera is VBA capable.

Regards, Horlen
Top
Sun, 2008-01-06 23:37
#4
K D
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Hi,
I think when you learn Microsoft Excel to advance level, you will get knowledge of Macro.
Material can be found on Microsoft website, or Help function.
Thanks
Top