Ben,

Have a look at this post..

You should be able to do something similar without importing the file, but rather "reading" it in..

READEXCEL - Read an Excel Spreadsheet and return results

We use this with a Vendor-Supplied COM Object and it works beautiful!

HTH,

- Kent

_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's