Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to get some data from another workbook, could anyone give me a hand
with this? The following is what I kind of figured would work but I am unsure of the syntax for addressing the actual cell the following calls for the data in C:\Myfilename.xlsHandicap. This is obviously not the correct sytax. 'Dim Location As String 'Location = Range("ReadFromFilename").Text & "Handicap" 'Range("Handicap") = Range(Location) I have searched for this and have had no luck. Thanks In Advance, Dave Marden |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
1.Open workbook. 2 copy data. 3 replace data. 4 save workbook. | Excel Programming | |||
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |