| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Needing to select file path with Set command
I'm currently using this piece of code to define my last column.
Set LastColOpen = Worksheets("Dec").Cells(3, "IV").End(xlToLeft) I need to expand this code to show that the Worksheet ("Dec") lives on R:\Something\Something [test.xls]) Something like Set LastColOpen = Worksheets (R:\Something\Something[test.xls]).("Dec").Cells(3, "IV").End(xlToLeft) Any suggetions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
| Embed PDF and select file name and path | Excel Discussion (Misc queries) | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| relative path in shell command (excel) | Excel Programming | |||
| Path command | Excel Programming | |||
Threaded Mode
