How can I use date format in Hyperlink?

[Wouldsman]

With help from many on here; I got this to work and it work great. Thank you
It takes my file and names it and places it into the "in this case" November folder with the click of a button

Please Login or Register  to view this content.

Now I'm trying to create a Hyperlink to the same file but my date ends up as a (number "42326") or (full date "11/18/2015") but not November folder where the code above placed the file.

Any ideas?

[:) Sixthsense :)]

Something wrong stored in F6 cell. Check it out because its working fine for me.

[AlphaFrog]

If F6 just has Today's date, you could replace this...

Please Login or Register  to view this content.

With this...

Please Login or Register  to view this content.

[Wouldsman]

I must have not explained myself correctly.
The Code works great. it saves it just like it should.


The HYPERLINK is the problem.

BUT the hyperlink date ends up as a (number "42326") or (full date "11/18/2015") but not November folder where the code above placed the file.

[skywriter]

Share your full code.

[xlbiznes]

Hi,

why are you doing this :->

Please Login or Register  to view this content.

your passing a date into a string and then trying to convert it into date formatted month.
you have to do this directly :->

Please Login or Register  to view this content.

[Wouldsman]

Something wrong stored in F6 cell. Check it out because its working fine for me.

F6 holds TODAY()