It won't let me open two files with the same name even though they are in different folders!

Yea, that is an interesting one, hehe.

I think the restriction is tied to VBA's being able to reference workbooks by name.

Something like Workbooks.Item("NAME") can be used. I supposed it blow that all to hell if you could open two.

Actually, I just tested it and I am even more certain of this.

If you open another instance of Excel you can do it. Just not within the same instance. ;)

...Different instances of Excel would have different workbook collections, so array indexing by name can exist in harmony.

Warning in Toyota manual: do some fucking obscure reason nobody cares about, no two blue cars can be on the road at the same time. So sorry.

It screws up my automated naming scheme. Now I have to include the host name.

Odd, since I gots me a blue Toyota.

Would your automated naming scheme work if you couldn't reference elements by name?

The thought occurs to me... You should go post on JoS and say it sucks ass. :)

Ah, well, at least you have a work-around.

My version of Excel-97 also only allows 65535 rows, which quite often hoses up my directory/file traversal data.  I hear they've finally fixed that in Office 2007.

> only allows 65535 rows

Probably so as not to compete with SQL server.

Probably because if you had a workbook on a Pentium with more than 65,000 rows...

http://blogs.msdn.com/oldnewthing/archive/2007/03/01/1775759.aspx

Honestly, that's really true today, the increase from 256x65000 to 65000x1,000,000 was honestly mostly because they could. If you really have a million rows of data to crunch, you should be crunching it in an RDBMS, an OLAP cube, or SAS or some other specialized tool on a multi-proc server with lots of RAM...

"I was thinking of driving in the Daytona 500 - which has more horsepower, the Audi A6 or the Honda Accord?"

Actually, it's not that unreasonable. If you record experimental data it's not hard to have more than 65,000 data points; lots of rows but maybe only a few columns. Excel should be a good numerical analysis tool for such data.

Microsoft is great, the fact the Bill Gates wipes his ass with $100 bills is proof positive. If you don't like some Excel feature, you're doing something wrong.

Lotus 1-2-3 Release 9.8 worksheets only supports 65,536 rows

wha, whaa, whaaa, whine, whine, bitch, bitch....

Open Office Calc 2.2 worksheets only supports 65,536 rows

wha, whaa, whaaa, whine, whine, bitch, bitch....

I am so fucking happy I dropped MS Word for latex. No more rejigging everything everytime you fart. The output from the standard templates is awesome. And the rest of it.

I am the most popular poster in the world.

I didn't SAY you should be using an Excel spreadsheet to record File/Directory data, now did I?

Sheesh, you people wouldn't recognize Irony if it kicked down your front door and made off with your cat.