VBa Write integer to file

D

davidmorrison

Joined
Aug 11, 2011
Messages
2
Reaction score
0
Hi,

i am wondering if anyone can help.

i am pulling me hair out trying to figure this out.

Basicially i have a macro that reads a line of text from a text file, for example "Davidmorrison=000001" and then splits this text by the equal symbol and creates an array.

Now what i need this to do is to take the array numbered 1 which is "000001" and add 1 digit so it will become "000002" and write this new number to the current line it split from.

But when it becomes 2 digits for example "000010" it loses one of the zeros.

Can anyone help ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel Write integer to file 2
Opening & Reading file in notepad then pasting into excel using VBA 5
fixed length file to excel? VBA macro possible? 16
Write text data to text file without quotes 4
Import Text File Directly to an Array 6
write one column range to text avoiding final linebreak 7
Read/Write variables to XML file using VBA 1
VBA Trim - has no effect in workbook- looking for ideas 8

Top