T
Tim Childs
Hi
I am writing a utility to autoformat a number of files downloaded form banks
and financial systems (from an IE browser to Excel 2000 on Windows XP).
There is one bank which offers the opportunity to download an Excel file but
when the file is opened automatically in the Windows temp directory, there
is a mismatch between the displayed name in the Excel application window
header and the "internal" filename.
The filename in the Window displays:
"transactionsummary[1].xls"
The internal name of the file is:
"transactionsummary 1 .xls"
Can someone explain what is going on, please?
The wider issue for me is that these particular files cannot have readwrite
status reset, but not being able to trap the files properly by name is
unsatisfactory. (most other files with a displayed name including "[" can be
trapped using a search for the square bracket.
Any help most welcome. Thanks
Tim
I am writing a utility to autoformat a number of files downloaded form banks
and financial systems (from an IE browser to Excel 2000 on Windows XP).
There is one bank which offers the opportunity to download an Excel file but
when the file is opened automatically in the Windows temp directory, there
is a mismatch between the displayed name in the Excel application window
header and the "internal" filename.
The filename in the Window displays:
"transactionsummary[1].xls"
The internal name of the file is:
"transactionsummary 1 .xls"
Can someone explain what is going on, please?
The wider issue for me is that these particular files cannot have readwrite
status reset, but not being able to trap the files properly by name is
unsatisfactory. (most other files with a displayed name including "[" can be
trapped using a search for the square bracket.
Any help most welcome. Thanks
Tim