Renaming a filepath within a Macro script

--------------------------------------------------------------------------------

Hi,

First off, Im extremely new to VBA.
I have a macro script in development at the moment to automatically send emails with attachments through Lotus Notes and I need a piece of code that can automatically change the 'date' (eg. 24-02-10) in each of the filepaths on my UserForm Sub.

Any help on this would be greatly appreciated.
Cheers

Tony

Originally Posted by Andy Pope

It would help if you posted your existing code. Remember to use code tags.

HEy Andy,
Im useing variations of the below code.

Please Login or Register  to view this content.

This code is running against a userform such as below

Please Login or Register  to view this content.

I just need a code that can change the dates (e.g 17-02-10) as needed.

Thats great man, cheers very much.
Ill bang it in to my code now and do afew tests but it should work fine.

Will this code change any date informortion in the Module code aswell as the Userform code?

Cheers man your a star.

If i wanted to apply

Please Login or Register  to view this content.

to a UserForm with a text box and command button, so that the date entered into the Txt box would become the " & strDate &", is there a code for that?

Cheers again man, youve been a great help