| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import =[test.xls]Sheet1!A1 - help
I'm importing data from .xls reports created each day. The file will
include the date. Is it possible the file is called "Test 01-05-2008.xls", I could create a string something like: =[test +"A3"+ .xls]Sheet1!A1 // Where A3 is 01-05-2008 Help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from file1 sheet1/file2 sheet1 last blank row | Excel Programming | |||
| [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
| How to import data from Sheet1 to Sheet2 in the order I want | Excel Discussion (Misc queries) | |||
| Display Rows From Sheet1 In Sheet2 (Import) | Excel Worksheet Functions | |||
| Sheet1.Activate vs Sheet1.Select | Excel Programming | |||
Threaded Mode
