Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Saving to text file - tabs from empty cells ignored


Hi,

Wondering if anyone can point me in the right direction.

I have macro that creates a text file and saves it so that it can b
read by another program. This other program requires arguments at th
beginning of the text file.

So I set up the macro to enter the needed text for the argument in cel
A1 then enter the data in the following rows

For example:

A B C
-----------------------------------------
Mesh AutoCreate
1 2 3
2 2 2
4 4 4

When I save the file as txt and try to open it with my other software,
the argument is ignored because there are 2 tabs (in the empty cell
B1,C1).

If I manually open the text file in notepad and remove the tabs then i
works great.

So I need to figure out a way to append that text to the beginning o
the file "without" tabs.

thanks for any help,
Lui

--
li
-----------------------------------------------------------------------
lif's Profile: http://www.excelforum.com/member.php...fo&userid=3574
View this thread: http://www.excelforum.com/showthread.php?threadid=56334

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving file without empty cells iashorty Excel Discussion (Misc queries) 2 July 10th 08 01:37 PM
Text file saving, setting file origin mauddib Excel Discussion (Misc queries) 0 May 25th 06 02:50 PM
Save trailing empty cells in a tab delimited text file osios Excel Discussion (Misc queries) 3 April 24th 06 08:54 AM
Saving multi-tab excel file created from comma delimited text file Marcus Aurelius Excel Programming 2 December 19th 05 05:16 PM
saving an excel file as an ASCII text file without delimiters Sewellst Excel Programming 4 January 7th 05 01:41 PM


All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"