Convert a dynamic data range into a table

Afteroon Guys,

Great to join! Considering how much I use excel day in day out i'm surprised i haven't joined sooner.

I've had a look through the web, and checked the forums here but can't find a solution.

I have an excel file automatically scheduled to download from a program we use. The data needs to be formatted prior to be inserted into a database. This file will change in size in terms of the number of records it will store, but not the number of columns there will be.

Essentially i'm looking for some code that will select the data range, and then convert this data range into a table.

Any help will be greatly appreciated.

AndyLitch,

Thank you, exactly what I was after.