Member Avatar for modom

I'm trying to do something in this thread but I might have posted it in the wrong forum so forgive me for asking the same question in 2 areas but this problem is kicken' my tail.

See here please
http://www.daniweb.com/techtalkforums/post380764.html#post380764

Any help would be mac-daddy great!

  • 2 Contributors
  • 2 Replies
  • 75 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by modom
Member Avatar for PVBert

1. Those brackets "(" and ")" should leave.

sFileName = sDir & ActiveDocument.Name & "(" & CStr(Month(dDate)) & "-" & CStr(Day(dDate)) & "-" & CStr(Year(dDate)) & "_" & CStr(Time(dTime)) & ")" & ".pdf"

2. I would try this (lookup the format function in vbhelp):

sDir & ActiveDocument.Name & Format(dDate,"mm-dd-yyyy_hhnn) & ".pdf"

Succes!

Member Avatar for modom

Thanks PVBert,

I'll try it out and let ya know. Thanks again I really appreciate this

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.