Create folder with current date as name(Done), then save fil

[gene_sc]

Hi
using VBA I created a folder with current date as name(works fine),then in the next bit of code- I create some files, that I want to save in the new folder( with date in title). The problem is telling excel what the folder name is, when the folder name changes each day?
thanks
regards
gene

 

[Jack in the UK]

Hi (I dedicate this post to a guy i never knew a Fire Fighter in the USA New York - this i felt was some of my finest work, and he was fine finer than i he will be on the net somewhere from World Trade Center loss)

I explain nothing --- dedicated to -

TERRY "Manhatton" Hatton (RIP friend)
Remember all the loss

|||||||||||||||||||||||||||||

Taking things forward a bit this was code i wrote in Jack_0_sence in June this year kinda popluar, guys have edited it to their ways of cause but will do as you want with a tweak here and there, has error handles like if DIR exits and so on, this was a back you

Cheek feed
http://www.mrexcel.com/board/viewtopic.php?topic=10750&forum=2

 

[gene_sc]

Hi Jack in the U.K.
Thanks for the link
The code I have now works, but I see some useful bits in your example(like testing to see if the folder exists). So I will play with it some more.
It really helps a newbe(like me) to see different ways of coding. Sometimes looking at code written differently, is easier to understand.
This website has helped me alot.
Thank You All
regards gene