PDA

View Full Version : Generating one .TXT archive from the Sheet.



GGS
03-28-2011, 07:47 AM
Hi guys,

This is my first time here and I hope that u can help me.

Here is the problem, I need to make one code to generate one .txt from a sheet.

What I've done: I got the VBA codes from here, one that was already done and it helped me a lot (thx, matthewspatrick). But, there still one issue that I'm unable to solve.

The template that the macro is saving, as set by me, is like this:


#24/3/2011##C#N#BOVESPA#VICT1#V#Zpadrao#Zpadrao#10#5#80#s###RV1#


And, what I wish to do, is like this:


0#RV
#24/3/2011##C#N#BOVESPA#VICT1#V#Zpadrao#Zpadrao#10#5#80#s###RV1#
99#RV


I cant afford to have more "#" on the first or the last line of the txt, so, i just CANT only select one row above and under the table.

The add-in that I'm using, is here:vbaexpress.com/kb/getarticle.php?kb_id=80
(I'm not linking because I cant, the rules doesnt allow.)

That's all, looking foward for a help from you guys.

Thx very much!