rhk001
04-19-2009, 01:54 PM
Hi there,
I am very very new to VBA but am loving what it can do, albeit very basic stuff I am doing at the moment.
I do a lot of importing into excel from another programme(Primavera P6).
The fields from the imports vary depending on the fileds open on the layout, so do their column positions. The first row of data holds the column headings, There are two date coulmns that I am interested in they are always called "start" and "Finish", I need to do a some tidying up to get them turned into proper date fields as some come in as text strings, and others dates. ( I have sub routing to do this bit)
What I am looking at doing in VB is looking to the right to find the last column, then work backwards to find Start & finish and select them as a range before I run my routine to tidy them up. Can anyone help my with some code to find "Start", and select all the data below as a range, then the same for "finish"
Thanks in advance for your help
Rob
I am very very new to VBA but am loving what it can do, albeit very basic stuff I am doing at the moment.
I do a lot of importing into excel from another programme(Primavera P6).
The fields from the imports vary depending on the fileds open on the layout, so do their column positions. The first row of data holds the column headings, There are two date coulmns that I am interested in they are always called "start" and "Finish", I need to do a some tidying up to get them turned into proper date fields as some come in as text strings, and others dates. ( I have sub routing to do this bit)
What I am looking at doing in VB is looking to the right to find the last column, then work backwards to find Start & finish and select them as a range before I run my routine to tidy them up. Can anyone help my with some code to find "Start", and select all the data below as a range, then the same for "finish"
Thanks in advance for your help
Rob