Anyone know any VBA (Excel)? - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=40527.0&return_msg=40527.1"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=40527.1">1</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=40527.1">Anyone know any VBA (Excel)?</a> </h3> <div id="messages" data-navigation="40527_1_1_10"> <a name="a40527_1"></a><div class="message" id="message_40527_1"> <div class="message_header"> <div class="message_from"> From: Queeg 500 (JESUSONEEZ)<span class="message_time">18 Jun 2013 09:40</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">1 of 1</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40527.1">40527.1</a></div> <div class="message_body"> I don't know VBA, but I feel that what I want to do should be simple...I've recorded a macro to simply import a TAB delimited text file, and the resulting code is;<br /><br /><div class="quotetext"> <b>code:</b></div> <pre class="code"> Sub Import_Stats_Breakdown() ' ' Import_Stats_Breakdown Macro ' ' Sheets("Breakdown Contacts").Select Range("A2").Select With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;Seatrade Shared:DATABASE (NEW):Contact Extract - Breakdown", Destination:=Range("A2")) .Name = "Contact Extract - Breakdown" .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .TextFilePromptOnRefresh = False .TextFilePlatform = xlMacintosh .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = False .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(2, 2, 2) .Refresh BackgroundQuery:=False .UseListObject = False End With Range("A2").Select End Sub</pre> <p> Now, what I want to be able to do is tell it to import a file based on a filename entered in say, cell C3, so I need to change the 'With...' line to something, and also the '.Name...' line I guess.<br /><br /> Can anyone help? There are some positive thoughts in it for you.</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40527.1&return_msg=40527.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40527.1"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> </div> </body>