VBScript Needed Import TXT File to Excel Check Column A for Data. VBScripting Experts,I require a VBScript that will perform the following 1  Import a Tab Delimited TXT file into an Excel sheet. Surround Sound Speakers Placement Ceiling. If this is possible, prior to import, the following columns need to be formatted as Text Only A, E, H, I, J, T, X and Y. Otherwise Excel will truncate leading zeroes from the data. Now that the sheet is formatted and populated, check each cell in Column A starting at A2 for blankempty. If blankempty, end the routine, save file as Tab Delimited Text file original formatsame file name. If not blankempty, then add the current date format MMDDYYYY to the corresponding cell in Column O. The part I am confused over is getting the Excel sheet cells formatted properly so that the data is copied over as Text. If it is easier in the script to simply format the entire sheet as Text Only prior to importing the data, that is perfectly fine too. I can do this within Excel using the Macro Recorder to record importing a tab delimited file, but truly need this accomplished with a VBScript rather than a VBA. At this point I have tried many things and probably over thinking it. Maybe a fresh set of expert eyes can bang this out quickly. Thank You all in advanceHi EE, I have written a code in VBscript. Now I want to also autofit the columns of excel. Sending a text email with an attached file. Maya Rigged Character S. By repeating the. Panda Cloud Antivirus Pro Keygen Crack Serial. AddAttachment method you can attach more than one file.