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

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
.

Relevant Pages

  • RE: Copying and Pasting---Another question...
    ... "Tia" wrote: ... > and I want cell B14 from every worksheet to all appear in a new worksheet. ... >>>If I have a workbook that has multiple tables, is it possible to select one ...
    (microsoft.public.excel.misc)
  • Add Autofilter to A1:Z1 on workbook
    ... Please can someone tell me how to add an Autofilter on each worksheet in ... my workbook from A1 to Z1. ... TIA ...
    (microsoft.public.excel.programming)
  • Re: Sort Worksheets
    ... >> I have a workbook where each worksheet name is the name of an employees ... >> TIA ...
    (microsoft.public.excel.worksheet.functions)
  • RE: userforms / worksheets
    ... > the help is launched from a button on each worksheet in the workbook ... > how do i detect which worksheet the help was launched from in order to set ... > the mult-page to the correct page? ...
    (microsoft.public.excel.programming)
  • Cells = Worksheet name
    ... For each worksheet in my workbook if there is a value in column "B" ... Sheet1 hgdtw ... TIA ...
    (microsoft.public.excel.programming)