Re^2: Problem opening WriteExcel generated spreadsheets with OLE

Well, crap, that works. The weird thing is, with the same exact code in the same folder, it would open one Excel file with the './' path, but not the others. Oh well. Thanks for clearing that up for me!

Comment on Re^2: Problem opening WriteExcel generated spreadsheets with OLE

Replies are listed 'Best First'.
Re^3: Problem opening WriteExcel generated spreadsheets with OLE by furry_marmot (Pilgrim) on Mar 04, 2010 at 17:31 UTC
Context, young one! Context! Internally, on Win32 (<==a context), Perl sees `'./test.xls'`, `"./test.xls"`, `'.\test.xls'`, and `".\\test.xls"` as the same thing. But if you pass a pathname to something else (oh, say, part of the Windows API known as OLE, another context...), you need to make sure that thing will understand what you mean. To the Windows API, OLE, MS-Office, etc and so forth, `"./test.xls"` has no meaning. Capiche?	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: Problem opening WriteExcel generated spreadsheets with OLE
by furry_marmot (Pilgrim) on Mar 04, 2010 at 17:31 UTC

Context, young one! Context!

Internally, on Win32 (<==a context), Perl sees './test.xls', "./test.xls", '.\test.xls', and ".\\test.xls" as the same thing. But if you pass a pathname to something else (oh, say, part of the Windows API known as OLE, another context...), you need to make sure that thing will understand what you mean.

To the Windows API, OLE, MS-Office, etc and so forth, "./test.xls" has no meaning.

Capiche?

[reply]
[d/l]
[select]