Hi,
Being new to Excel VBA programming I am going through exploring era. -
I have a requirement as:
- There are two excel worksheets which are getting populated from two URLs.
These worksheets consist of almost same set of records with different column names.
- I need to store these data into a common table into access, which will be having generic columns.
- To achieve this I have to create column mapping using VBA code.
e.g.: In one of the worksheets "TeamName" is called "Workgroup" while in other its called as "Team".
So this needs to be done in VBA before inserting into table.
Now being newbie to excel VBA, i got messed up. I am trying this out from last couple of days... but landed up in no mans land.
Appreciate any help or suggestion.
Thanks.
Being new to Excel VBA programming I am going through exploring era. -
I have a requirement as:
- There are two excel worksheets which are getting populated from two URLs.
These worksheets consist of almost same set of records with different column names.
- I need to store these data into a common table into access, which will be having generic columns.
- To achieve this I have to create column mapping using VBA code.
e.g.: In one of the worksheets "TeamName" is called "Workgroup" while in other its called as "Team".
So this needs to be done in VBA before inserting into table.
Now being newbie to excel VBA, i got messed up. I am trying this out from last couple of days... but landed up in no mans land.
Appreciate any help or suggestion.
Thanks.