VB to save to file of current date

**sroot** · 02-17-2015, 04:30 PM

I have this code that saves the sheet as a pdf document and it works perfect for the most part, I just can't figure out how to get it to save to the folder i need it to. The problem is that i need it to save to a folder that has the current date in it. The folders are already created so i don't need it to create the folder just save in it. the path would be for example G:\Everybody\Daily Reports\2-17-15\rawdata.pdf How would i modify this code to do that? Thanks for the help!

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 02-17-2015, 04:37 PM

Maybe?

Please Login or Register  to view this content.

**sroot** · 02-17-2015, 06:00 PM

That worked great thank you!

**JOHN H. DAVIS** · 02-18-2015, 07:16 AM

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum rules and mark this thread as solved. Use the link below for guidance.

http://www.excelforum.com/forum-rule...rum-rules.html