Getting Data from Excel Worksheet

[grovelli]

I'm importing data from the attached Excel file which might have 24 or 25 columns, what's the code to determine how many columns the file has? I've tried using the following in an if...then...else block but it doesn't work
If xlWbk.Worksheets(1).Range("AC9").End(xlToRight).Column = 25 Then

[HansV]

You could look at

xlWbk.Worksheets(1).Range("E3").End(xlToRight).Column

This will be 29 if the range starting at column E has 25 columns, and 28 if it has 24 columns.

[grovelli]

Thank you Hans