txt

Howdy...Looking for tips to achieve multiple sums. I have a list of criteria along with scores assigned to each criterion, which will be used in drop-down lists in another sheet. <colgroup><col><col><col span="7"></colgroup><tbody> <tbody> Txt 1 for criterion 1 Text 2 for criterion 1...

Morning All, I found the following code online hoping that it would allow me to download multiple txt files onto the same sheet from a memory stick however when I try and run the program it faults out on the underlined line with "Object Doesn't Support This action" any ideas or suggestions...

Hi, Im wanting to save values from: range B2:E20 With a space between each column value anf saved as txt (overwriting existing txt file without prompt) I think i need to use "saveasCopy" but not sure how to save just the range and to a specific location Any help appreciated

Hello, I have been tasked with creating an upload for a business we work with. The file has to be in exact format. I have very little experience working with txt files. I've created the data in Excel pulled from a variety of data sources. The worksheet is then saved as a txt file. I've...

Hello, Trying to get my spreadsheet to work in Excel 2016 for mac, the below works well in the Excel version 2011 but gives runtime error 424 on the line of code "FileNameOut = Application.GetSaveAsFilename" anybody any suggestions how to solve this? If bmac Then 'for mac...

Hello, friends! I've wrote some function that reduces the strings by the last symbol: Function reducer(ByVal txt As String) As String txt = Left(txt, InStrRev(Left(txt, Len(txt) - 1), Right(txt, 1))) reducer = txt End Function Example: <tbody> A B (function) B (result) 1...

Hey everyone, I have a code that works great for importing multiple txt files and copying into one sheet in excel but I have a problem was hoping one of you experts can help with. One of the txt files we have sometimes gets copied into one cell. I'm thinking it's a delimiting issue on the...

Hi guys I'm after some VB to simply select a table within an Excel worksheet (not the full worksheet, just the table including it's headers) and output it as either a txt file or a csv. I did an extensive Google search for this and found loads to try but can't quite get any of them to work -...

Hi All, I have list of text files in sheet1 source location like ColumnA C:\Google\Database\Sandy.txt C:\Google\Database\Marry.txt C:\Google\Database\Bran.txt Need to extract emails from each file and put them in b1 if found 2/3 emails in each file then c1, d1. VBA to go through the list from...

I'm trying to add the name in the first line of the source txt file to each row in a new column and then delete the source row. Source text would go into column A - column title "switch". pushing all the the other columns over by one & joining the now row1 headers "Vlan MacAddress Type Ports"...

Hello! I have an excel file (2010) with a list of hyperlinks that point to txt files. When I open the hyperlink a new instance of Excel is opened with the txt file. I would like to txt file to open in the original instance of Excel. Is this possible? Thanks! Sherry

Ok, at our work we have recently moved from excel 2003 to 2010. I have several workbooks that contain macros that look for different txt files from a users desktop and imports them and then does stuff. For example in 2003 I use the below: Workbooks.OpenText Filename:="C:\Desktop\ADOABS19.TXT"...

Hello, I'm new on this forum and I need a macro to help me to copy the values from multiple "txt" files into a single Excel file. The details are: - I have many "txt" files (could be hundreds or thousands) - the files names are similar to: 1715900115406111-30062017111747.10007-tor (it's a txt...

Hi Folks, I'm pretty new to VBA but confident this is the right place to find some help... I'm trying extract the list of all distinct words from a worksheet, followed by the number of occurrences the same word is found in the complete source sheet. Only words having more than 3 characters...

Dear all, I've been looking for a VBA code to import data from a txt file and delimit it. However, I'm blocked when the txt file needs to be selected. My problem is that the path always change (and the file name as well). An alternative solution might be to use <code style="margin: 0px...

Hi team and good morning! I´ve been looking around to see if I found this kind of thread somewhere, but I can only find the viceversa (from txt to Excel). I basically want to convert an Excel worksheet to a txt file with a pipe delimiter (|) to separate the columns. My Input - Excel sheet -...

Hi there, I have a text file (data.txt) which I'm looking to add data to (either at the bottom or the top, doesn't matter) Basically, I have a userform which, when the update button is clicked, adds the value of cell A1 to the txt file on a new line. I don't want the text file to open up, nor...

Hey guys, I was wondering if you guys would be able to help me out here. I have an employee report which comes to me in txt format. I need to find the rows with yesterday's date under a specific column and transfer that to a diffferent sheet. the problem I'm having is that the data comes...

Hi, Currently the below code snippet is used to save a range of data into a tab delimted text file for upload into a database. I have just found out the file name including extension needs to be uppercase throughout. ActiveWorkbook.SaveAs SaveToDirectory & SaveName, xlText Is there a way to...

Hi all, I had this code working great on my PC. When converting to mac, it will create the text file but fails at the "save-as". I have the newest excel for mac. Can any give advice? Here is the Sub ExportCSV() ' ' ExportCSV Macro Dim MyPath As String Dim MyFileName As String 'The path...