Microsoft Office Forums - View Single Post - [Solved] VBA Novice

Thread: [Solved] VBA Novice

View Single Post

Old

06-29-2018, 08:00 PM

gmayor

gmayor is offline

gmayor uses Windows 10

Windows 10 gmayor uses Office 2016

gmayor uses Office 2016

Office 2016

Expert

Join Date: Aug 2014

Posts: 4,137

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

What does it produce for you?
I added a hyphen after the date, but you can remove it if you wish

Code:

strName = Format(Date, "yy-mm-dd-")

You will need the Windows path of the network drive rather than the IP address to write to it with this code.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote