make money

jav online; jav streaming; 1pondo; caribbeancom; heyzo - tokyo hot

Award Winning Design Blog

SPPID

Excel VBA – Create A Basic Array Part 2

By on June 1, 2011 in Programming, SPPID, Tutorial with 1 Comment

‘Yesterday, we learned how to create a basic array in Excel VBA. ‘Today we are going to actually do something with it. ‘Let’s highlight the rows of the people that are over 35. Here we go. Sub CollectRowValuesInAnArray() Dim startrow As Long Dim lastrow As Long Dim myArray() Dim a As Long Dim i As […]

Continue Reading »

Excel VBA – Create A Basic Array Part 1

By on May 31, 2011 in Programming, SPPID, Tutorial with 4 Comments
Excel VBA – Create A Basic Array Part 1

Most design software output’s to Microsoft Excel in some form or fashion. In this 2 part tutorial, I will show you how to collect an array of cell values in M$oft Excel VBA. There a few ways to loop through each row in excel VBA. For me, the quickest way is to dump the data […]

Continue Reading »

How To: Loop through all project piperuns using filters with Smartplant P&ID automation and VB6

By on January 14, 2011 in Programming, Smartplant, SPPID, Tutorial with 9 Comments
How To: Loop through all project piperuns using filters with Smartplant P&ID automation and VB6

Programming using Smartplant P&ID’s Logical Automation Layer is actually very easy and intuative after you do it a few times.  This example of a what I start with a lot. What this little routine will do is loop through all the active (non stockpile) piperuns in your project and print their ItemTags in the immediate window. […]

Continue Reading »

Top