Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filenames and formulae | Excel Worksheet Functions | |||
getting filenames | Excel Programming | |||
Open workbooks - filenames change daily | Excel Programming | |||
Getting filenames via VBA | Excel Programming | |||
Filenames In Loops | Excel Programming |