I asked one of my bosses - he uses the docmd.transferspreadsheet command, but he doesn't know how to specify multiple worksheets either. My other boss might know - I'll ask him when he gets in.

I happen to have Access 97 open - the help says this about the Range argument for TransferSpreadsheet Action (i.e. a macro):

The range of cells to import or link. Leave this argument blank to import or link the entire spreadsheet. You can type the name of a range in the spreadsheet or specify the range of cells to import or link, such as A1:E25 (note that the A1..E25 syntax no longer works in Microsoft Access 97). If you are importing from or linking to a Microsoft Excel version 5.0, 7.0, or Excel 97 worksheet, you can prefix the range with the name of the worksheet and an exclamation point; for example, Budget!A1:C7.

Does that help? (I'm guessing the same applies for using VB.)

Does that help?

That only gets me the first worksheet, unfortunately. I tried putting the worksheet name in, but maybe I need Budget!A1:ZZ99999 or something.

Has anyone bought a dvd that plays region 1 and region 4?

(I'm looking at import dvds of Alatriste because I suspect it will never be released here.)

Has anyone bought a dvd that plays region 1 and region 4?

The Philips 642 player can be easily hacked via a remote code to be region free. It costs around $60. For some reason Amazon is charging $189(!!!), but google Philips 642 DVD and you'll find a lot of reputable dealers selling it for $60ish.

It's a good player too. I've had it for years and it's reliably played anything I've thrown at it.

For some reason Amazon is charging $189(!!!)

That's nuts!

I think I bought mine at Target for $64.

Well, I'm looking at a dvd - not planning on getting a new player.

Sumi, I don't have any dual-coded dvd's, but I've run across a few here at work -- it's a sensible solution for the Latin American market, so I'm surprised that they didn't turn up a long time ago. Of course, all our players are region-free, so I have no idea how they play if you have a region 1 player, except that theoretically they should.

Well, I'm looking at a dvd - not planning on getting a new player.

I must be missing something. You're looking for a DVD *disk* that's multiregion? I don't get it.

t edit and amych's answer still leaves me confused.

Not for one, at one -- the South American import version of Alatriste is coded for both regions 1 and 4: [link]

Ahh! i get it. Thanks. Well, if it says it's coded for Region 1, it had better play on Region 1 players. I mean, isn't that the point?