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

Similar Threads

Make first imported CSV row into column names ? 3
Combine two spreadsheets into one 3
Variable Table 1
Color a cell based on column date and row content 2
Conditional formatting based on the Row Source in another control. 6
Expression errors on an import 1
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
Locate text in range (multiple occurrences) and report other cell insame column? 25

Top