Inserting 0 into file name

[Sebas123]

Hello,

Currently i am trying to export files row by row into a text file. This is working, but i am having problems with the file name of the textfile.

I am trying to insert a "0" into the filename. This is the only number that doesnt work.

Here is the layout of my sheet:

A B
S110015-0001 1
S110015-0001 2

I am trying to get my filename as following:
S110015-0001-01.txt
S110015-0001-02.txt ect.

Please Login or Register  to view this content.

Hope you can give me some pointers.

Thanks,
Sebas123

[Richard Buttrey]

Hi,

Dim your part2 as a String

Regards

[Sebas123]

haha it worked

Sometimes it are the simple things!

thx for your help