Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I'm using the following function: Function ReadCell(msheet, mCell) 'ReadCell = ActiveWorkbook.Worksheets(msheet).Range(mCell).Val ue ReadCell = Workbooks("this.xls").Worksheets(msheet).Range(mCe ll).Value End Function The remmed out line caused a problem when two instances of Excel were open at the same time, and the replacement line referencing the absolute xls filename fixed this. However, if the filename isn't "this.xls" it fails. Excel knows the filename somehow, as it's used as the main Caption. Can I get at this somehow and use it instead? Thanks - Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Column letter reference as number reference | Excel Programming | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |