View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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