| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in a VB Code
I have a simple question.
I have a Cell named "DirLoc" and in that cell the value: "c:\fileinfo" How can I put that in a vb string? Example: FileLoc = Cell(RangeName) & "\testing.xls" So: FileLoc = "c:\fileinfo\testing.xls" Thank you in advance for any help. Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in a VB Code
Mike,
Use something like FileLoc = Range("DirLoc").Text & "\testing.xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Michael Kintner" wrote in message ... I have a simple question. I have a Cell named "DirLoc" and in that cell the value: "c:\fileinfo" How can I put that in a vb string? Example: FileLoc = Cell(RangeName) & "\testing.xls" So: FileLoc = "c:\fileinfo\testing.xls" Thank you in advance for any help. Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for variable sort order | Excel Discussion (Misc queries) | |||
| keep variable value after code quits | Excel Discussion (Misc queries) | |||
| can i link a variable cost code with a variable sum | Excel Discussion (Misc queries) | |||
| VBA Code - NAME SEVERAL VARIABLE cells | Excel Worksheet Functions | |||
| variable code?? | Excel Discussion (Misc queries) | |||
Linear Mode
