import

I'm trying to import some text from a CSV file, but I don't want to include the headers, which the CSV file contains. I've been told on a previous thread I posted that there's a "start import at row" option where you can select the topmost row to import. That thread seems to have died a few days...

I use Excel 2019 and I'm trying to import some data from text/CSV, but the data I'm importing has headers, and I don't want them. Is there a way I can remove the headers and their formatting from the text before importing? I don't want to just delete the row with the headers after I import the text.

I have been trying to set up formula below on 3 line using a _ in between but code changes to red "=IF(ISNUMBER(MATCH(RC[-7],'[BR1 Import Template." & C & ".xlsm]Data Import'!C1,0)),VLOOKUP(RC[-7],'[BR1 Import Template." & C & ".xlsm]Data Import'!C1:C7,7,FALSE),VLOOKUP(RC[-7]+0,'[BR1 Import...

Hello, I have a process where users combine data in a single spreadsheet. That data then needs sent to a text file where it will imported into a server database process. I can get the process to create the text file, save changes and then close the text file with a workbook.close statement...

Hi Guys, I’ve got some code that imports “Sheet1” from a file I needto select from a pop up box. Sub ImportReport() Dim Fname As String Dim Wbk As Workbook For Each Sheet InActiveWorkbook.Worksheets If Sheet.Name ="Sheet1" Then Sheet.Delete End If Next...

Hi, I have some vba code that a former colleague created and said there wasnt a way for us to change the code to stop it asking for the file name. Its a static file that we download each day and overwrite the previous one. However, each day we need to navigate to the folder to select it. The...

Hi guys I am using the below code to import a specific range of data from another spreadsheet into my current workbook I have open. The below code works perfectly. However, what I am trying to achieve is to amend the code so that my current Msg box presents the following: Instead of simply...

I am trying to create a Macro in VBA to Import data from either single or multiple PDF forms in to an Excel workbook. Adding each form as a new row in the sheet. I am thinking of a Button with the macro attached on the Sheet, which then identifies a folder containing the forms. It then pulls...

Hi everyone, I'll try to explain as best as possible. I have table of data that I export from a site on a daily basis that lists all incoming messages in a table (message reference, date & time, title etc.) I want to record some additional information against each row on a separate master...

Here's the question: is there a way to retrieve the range name created by the Import External Data feature? Now, here's a little background: I am creating a spreadsheet that will let me retrieve my bank credit card transactions in CSV format and then output a QIF file that I can import into...

I have a "Master" workbook and worksheets in it. Sometime I have two a worksheet tab named "Helper" and "Summary", but sometime I have three worksheets in it (like "Analyze", "Helper" and "Summary"). In the 'Temp' folder I have between 80 and 100 workbooks (all depends on the current month). I...

With ActiveSheet.QueryTables.Add(Connection:="TEXT;T:\JICU20190512123222.txt" _ , Destination:=Range("$A$1")) .Name = "JICU20190512123222" .TextFilePlatform = 850 .TextFileStartRow = 4 .TextFileParseType = xlDelimited .TextFileSemicolonDelimiter =...

HI I want to Import last saved record of particular Name from access database to excel userform. It give me the first record saved for particular name. (FIFO) I want to import using LIFO method/ code please help Regards Manish

I'm trying to execute this line of code: DoCmd.TransferText acLinkDelim, "TheUploadSpec2", "ltUpload", upPath & upFileNm, True I keep getting Error '3625' -- Specification Does Not Exist. But I swear it absolutely does! When I go to External Data>New Data Source>From File>Text File...I click...

Hi there. Like many before me, I’m having issues with Excel converting dates to the US format when importing files to Excel via macro. I’ve found various solutions that claim to work but I am stuck and have been unable to find a solution for my application. I’m certainly no expert with macros...

Hi Guys, I'm trying to write some code to simply import Sheet1 from a file. The file name will change and so will the location, so it needs to: Run the macro from the existing file Load a dialogue box so the file can be selected by the user Copy Sheet1 from the selected file and add it into...

Dear Community, I am in the process of building my first database for all kinds of lubricants that my employer sells. However, I am now stuck trying to figure out how I can import the data from excell into a dropdown list with 7 values total. These values are: Can, Spray Can, Pail, Drum, Drum...

Hi Everyone, I am looking for ideas getting an HTML document into Excel. I've tried the standard "Get Data" but I end up with a 4MB file and have 30-35 tables daily. If its possible to import the entire HTML document to one worksheet with a one click solution that would be great. Any...

Hi, I have a VBA macro that imports data from a saved csvfile into an excel report, however, I'm having problems applying it to a newset of data because the new data has the date in American fomat, not UK. I need to be able to export the data file with the date in American format,save it as it...

Hi. How do I get excel to not auto format my csv data to columns on import, without changing the *.csv extension to *.txt? I have tried to google an answer but did not find a solution. I would like all *.csv files to have to go through the "data to columns" wizard. THank you in advance, Jenny