I'm writing a vba code which supposed to delete the data on a selected excel sheet, open a dialog box for text file selection, and then import the data from that text file to the same exact sheet I've deleted the data from. So far I can only open the text file into a new workbook but can't open it to the same sheet I've deleted the data from. Here's what I came with so far, will appreciate your help: Dim Filt As String Dim FilterIndex As Integer Dim Title As String Dim FileName As Variant Filt = 'Cst Files (*.prn),*.prn' Title = 'Select a cst File to Import' FileName = Application.GetOpenFilename(FileFilter:=Filt, Title:=Title) If FileName = False Then MsgBox 'No File Was Selected' Exit Sub End If With Application.ActiveSheet Cells.Select Selection.QueryTable.Delete Selection.ClearContents End With Workbooks.Open FileName Thanks! There are many ways you can import Text file to the current sheet. Here are three (including the method that you are using above) • Using a QueryTable • Open the text file in memory and then write to the current sheet and finally applying Text To Columns if required. • If you want to use the method that you are currently using then after you open the text file in a new workbook, simply copy it over to the current sheet using Cells.Copy Using a QueryTable Here is a simple macro that I recorded.

Please amend it to suit your needs. I think here is the simplest solution to what you are trying to do: • Select the cell where the first line of text from the file should be. • Use the Data/ Get External Data/ From File dialog to select the text file to import.

Download Ffh Undone Mp3. • Format the imported text as required. • In the Import Data dialog that opens, click on Properties. • Uncheck the Prompt for file name on refresh box. • Whenever the external file changes, click the Data/ Get External Data/ Refresh All button. Note: in your case, you should probably want to skip step #5.

Another awful decision from the Office team. Having no other choice, I tried the online help for Excel VBA and spent five fruitless minutes trying to find the syntax for a simple VBA function. And you know what, I couldn't find it! I found C++ and other versions of it, but even when I chose VBA from the list,. Dec 19, 2017 OzGrid - Free Excel VBA Help Forum. Hi All, Any thoughts on how to format chart points that contain specific text?