Maybe my google searches are utterly rubbish but I need to filter out the
code one would use to open a specified Excel file from within Access, save
it to the latest Excel format (NOT xlsx), check if the top row is empty (if
so delete that row and save), then finally close the file.

Is this a few lines of code or a bit more complicated?

thanks
Martin
- am feeling a bit stupid today...

Hi Martin,

Automating Excel is pretty simple. Most of what you want to do is most
easily achieved by first recording a macro in Excel to do the things
that you want to handle internally to the document, then simply copy /
paste that code across into Access for use in your automation routine.

To get Excel up and running for example is easy:
Dim xl as Excel.Application
You need to set a reference to Excel in Tools>References for that to
work. This becomes your copy of Excel to play with. If you want to
check a large number of cells for the existance of values you are
probably better to collect the entire worksheet you want into an array
and check that by looping through the elements, as looping through
Excels cells is quite slow:
Dim x as Variant
Dim ws as xl.Worksheet
set ws = xl.ActiveWorkbook.Sheets(1) 'You can also use a sheetname
in quotes
x = ws.range("A1:IV65536")

What you end up with here is a two dimensional array in R1C1 format
(ie/ 1,1 is the first cell). To capture this takes only a fraction of
a second, and looping through each cell of the first row maybe another
fraction of a second in total.

Dont forget to clean up the objects you create as they can end up
using some decent amounts of memory if left running. Also, when you
instantiate your application object for Excel it doesnt have to be
visible to the user either. If you get stuck just open a new workbook
in Excel, start recording a macro, then open the workbook you want to
work on and do your things, save the way you want to and close the
workbook; now stop your macro and paste the code here - maybe we can
help.

Cheers

The Frog

"The Frog" <mr.frog.to.you (AT) googlemail (DOT) com> wrote

Thanks dude, that's useful and I shall make a start from there!

thanks again.

Anytime. Drop a note in this thread if you need help.

Cheers

The Frog