Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Creating a Macro

Misticles · 2011-10-12 11:11:55

I have to compile a macro that does the following.... Extracts around 50 columns from a file.... ie the header and its corresponding data underneath. It needs to be used on two files (V9 and V12) - the headers do not appear in the same order in each file. When used on V12 it needs to order the headers and data the same way…

12-10-2011 12:11PM

#1

Misticles

Registered Users, Registered Users 2 Posts: 13,746 ✭✭✭✭

Join Date: July 2005

Posts: 13260

I have to compile a macro that does the following....

Extracts around 50 columns from a file.... ie the header and its corresponding data underneath.

It needs to be used on two files (V9 and V12) - the headers do not appear in the same order in each file.

When used on V12 it needs to order the headers and data the same way it is in V9.... I don't know if that's possible...

Trade IdProduct TypeProduct DescriptionTrade DateTrade Settle DateBookCounterParty

Thanks

0

Comments

#2 12-10-2011 01:04PM

homer911

Registered Users, Registered Users 2 Posts: 5,067 ✭✭✭

Join Date: September 2007

Posts: 4683

Will the columns in each file always be in the same order?

Can you make a permanent change to the column orders in one of the files?

About how many rows are you talking about?

0