Variable in a VB Code

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

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
 
Mike,

Use something like

FileLoc = Range("DirLoc").Text & "\testing.xls"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top