text file

Hello, I use the following expression to write Excel data in a text file. Mid(MyStr, 14) = " EH=" & Cells(MyRow, 6).Value If the cell contains a number with many decimals all is printed to the textfile. Is it possible to round the number before writing it to the text file?

For text files such as abcde.cls and doIt.bas how best in VBA to edit write dates (created modified etc )..

I want to have text files (.bas, .cls) with the updated version of my codes in a xls file. I guess I can't do a reference from the xls to the files and run the codes from the text files. The code must be in a module in the xls. So my idea was to write a Sub Workbook_BeforeSave. So, everytime I...

I have 3 types of files that I need to import. They are named item_blah1.txt, item_blah2.txt and item_blah3.txt. A list of the 50+ "item" are maintained in another text file. What is the best way to open each group of 3 item text files and import them as worksheets into a new workbook. Note...

I have a text.CVS file I down load daily off a server. I have used Get External Data From Text. Works well. I want to write a VBA sub to refresh the link as part of a large reporting package What I have is: Selection.QueryTable.Refresh BackgroundQuery:=False But when it runs it...

Hey Everyone, I previously posted a request to help me automate play list creation from a filtered list here. In my first post, I asked for way too much help and my second post, I posted way too much code. Never got a reply, so I'm going to keep it simple this time. I need to know how to...

Dear all I'm working with tab-separated data from .txt files, imported into Excel for statistical processing. I'm having the following problem with two of the columns in the tab-separated files I am importing. The tab-separated .txt files are generated in the phonetic-analysis program Praat...

Hi all, Importing text files into excel is farely simple having googled round the topic. The text file i'm importing is awfully big though, so I wondered if I could just read in the columns I need to speed things up. (I could import the whole thing then delete the columns I don't want after...

Maybe its late in the day but this one is doing my head in. I have a .txt file Im seeking to import to an Excel worksheet where wierd and wonderful macros will do fascinating things to it. But the actual text import is erroring and my brain has screamed that its after 4pm and then gone to the...

i have a excel file which I want in .txt output. In EXCEL sheet1 A1 contains number, B1 contains name, C1 contains Amount, D1 contains particulars. When I run Macro in text file to be created. In text out put I want spacing for A1 data is 14 {the account number varies from 5 digit to 14...

I'm using a macro to import a series of fixed-width text files. The problem I'm having is that for some lines of data the name field will drop all the spaces in the name and screw up those lines of data. For example something like this: John Moe Doe 1003 10000 Will get imported as...

I thought this would be easy. I can't figure out how to paste a portion of a worksheet so, here's what I have: A B C D E F 1 123 ABC 1 123 Joe Smith 1234 N. Elm 2 123 ABC Tommy Jones 59th Street When I save it as a .txt...