Web query on Open
Hi RogueIT,
My suggestion fails because I included the : (colon) character, which is not
allowed in file names.
However, your code ran without problem for me.
---
Regards,
Norman
"RogueIT" wrote in message
...
I am still getting a VBScript runtime error
type mismatch: 'format'
on that line at the first char, even after the change...;-(
thanks,
RogueIT
"Norman Jones" wrote:
Hi RogueIT,
fname=Format(now,"MMDDYYYY_hhmmss")
Try:
fname = Format(Now, "mm-dd-yyyy hh:mm")
---
Regards,
Norman
|