| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve data from external excel document
Hi all,
My aim is to retrieve a data value from an external Excel document using VBA. I have an external document available at C:\src.xls. This contains a cell with the text "PM Ckpt to CRF finish " and this text is unique. I need the number value 4 rows down and 2 columns across from that cell. This data can then be assigned to a long variable "complete". I have no issues with hard coding the location of the file src.xls. Can somone give me any direction on how this can be done? Many thanks in advance Khurram |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I retrieve changes to an unsaved excel document | Excel Discussion (Misc queries) | |||
| External data retrieve timescale | Links and Linking in Excel | |||
| External data retrieve timescale | Excel Programming | |||
| How do I retrieve changes to an unsaved excel document | New Users to Excel | |||
| How can I retrieve an Excel document that I did not save? | Excel Discussion (Misc queries) | |||
Threaded Mode
