View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Kintner Michael Kintner is offline
external usenet poster
 
Posts: 34
Default 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