tab delimited

Hi all, I've seen this topic discussed, but not sufficient to answer my question. Your help is appreciated. My goal is to export a worksheet to a new workbook, save the new workbook in a specific location with a specific file name. The next part is where I'm struggling. I then want to take...

What I'm trying to achieve should be simple, but Excel keeps making it very difficult for me. All I want is a macro that does exactly the following and nothing else: Export all of the data in the active sheet to a text file in the active workbook directory The filename should be the name of...

I have a spreadsheet that I need to convert into a tab delimited text file. I am writing some vbs code in notepad++ and I just cant get the last line to work, everything else runs perfect, but I just cant get it to save as a tab delimited text file :/ Set ExcelObject =...

Ok so I'm new to VBS, and sorry in advance for the simple question :laugh: I'm in notepad++ and I need to remove the first two lines of a file and then save the file as a tab delimited value .txt file. The name of the file I'm using is Snowfall.xls I got this code to do work in the vba...

So I have some data exported from an ecommerce store. Tabe delimited file. I've created two delimiters, ^ and ##: ^ is before each order number. This indicates notes are over, or new order number ## indicates notes begin. If there is nothing after this across the row (say, 5 rows over) then...

I using Microsoft Access (2013) and Excel (2013) Automation and VBA inside an Access module to open an Excel "xls" file which I was given. That xls file is evidently a report with tab delimiters which was someh0w converted to an xls file. Wehn the file is opened I get a cautionary message to...

Hi all - head is twisted in a knot... I have the following: NameProduct 1 Product 2 product (n) Name 2Product (p) Product (k) Name 3 To the right of each product I have amount. I want to do basic analysis by sales per product per client. I don't know how to get this data in a table. I could...

Hi, Hope you are all well. I was wondering whether it is possible to export Excel files to Text (tab delimited) (*.txt) without inserting unwanted " 's please? The task I am trying to automate is the removal of unwanted characters, one of which is the double-quotation mark. I have written...