Gerry
A good starting point would be to record the settings you need using the
macro recorder. The next bit would need to be coded manually, but it would
be fairly simple using VBA's Dir Function and a variable to accept the file
name, etc.
Without much more detail it's hard to help more

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@btinternet.com.ANDTHIS
> Hi all, this is not strictly an excel setup question but I
> dont' see any other excel sections. I'll pick your brains
[quoted text clipped - 14 lines]
> Cheers
> Gerry R