import spreadsheets (column names not always on the first row)

M

mcnews

i need to import a series of spreadsheets where the column names are not always on the first row. they come from different sources, but the column names are consistent from source to source. in other words source one's column names always start on the same row etc.

i'll be looping thru excel.application, workbook, worksheet etc.

any tips?

tia,
mcnewsxp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top