+ Reply to Thread
Results 1 to 1 of 1

Saving a file - syntax error

Hybrid View

  1. #1
    Registered User
    Join Date
    05-28-2009
    Location
    Oakville, ON Canada
    MS-Off Ver
    Excel 2002
    Posts
    75

    Saving a file - syntax error

    I am trying have a macro save the current file include the time I saved the file. e.g. 0 Event Request for -- -- -- - - V20090720 18:37:37

    The way I have the macro written now results when I try to save the file in an error - incorrect syntax. I believe it is caused by the colon between the numbers that make up the time hh:mm:ss. How can I get the time without the colon so that I can save the file? Maybe hh mm ss?

    ' Collect current date
    strVerDate = Range("Ver_Date")
    
    strFileName = strTest & " Event Request for " & strDate & " - " & strCustomer & " - " & strVerDate
    
    Application.Dialogs(xlDialogSaveAs).Show strFileName
    VerDate is =CONCATENATE("V",ED5,ED6,ED7," ",TEXT(ED8,"hh:mm:ss"))
    ED8 is =Now()
    Last edited by Foxcan; 07-20-2009 at 06:37 PM. Reason: figured out my own answer....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1