filenames and workbooks
Hi all!
I have 2 odd problems in a system where I open 2 more files and process
data in the 2nd one.
1. when opening a file from a script in a excel file, I would asume,
that they file opened would become workbook(2), but by some odd reason
it becomes something else, and "myself" becomed workbook(2). This
problem was not present a few days ago...
2. I have the filename including path, but how do I get the name (of
that string) in order to do like this: workbook(filename)
E..g I have c:\sdgfsda\safsd.xls and I only need the latter part
"safsd.xls"
3. (bonus) how do I set a cell() to a number, but as it was a string?
E.g. a number and a dot? ("1.")
|