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

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