Apple extended warranty - good idea or not? (A friend is buying a Mac right now.)

eta: This will be for a MacBook. She generally doesn't take her laptop with her....

She's calling me back in a few minutes....

Definitely, especially for laptops.

Apple extended warranty - good idea or not? (A friend is buying a Mac right now.)

Extended Apple Care? Definitely a good idea.

OK, she's going with the Apple extended warranty thingie....

Thanks.

I'm trying to automate importing a spreadsheet into an Access database, into a table that already exists.

My first angle of attack is creating a macro, using the TransferSpreadsheet action. Problems here are a couple:

• the filename changes weekly, but I guess I can edit the macro every week
• I need information from two worksheets in the spreadsheet, but I can't see how to get anything other than the first one--the help files says it can be done with the Range argument, but doesn't talk about format.

I guess the other option is to do it in Visual Basic and use the DoCmd object, but it's been years since I've been in VB and it skeers me.

Ideas?

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.