Thread: How to get Cell value and use as file name in macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_320_] mudraker[_320_] is offline
external usenet poster
  
Posts: 1
Default How to get Cell value and use as file name in macro

halarikeyur


This line of code will not work as you have enclosed your variabl
inside halarikey quote marks which makes it text

With ActiveSheet.QueryTables.Add(Connection:="TEXT;File Nm", _


try

With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & FileNm,

--
mudrake
-----------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=27266

Reply With QuoteReply With Quote