Results 1 to 5 of 5

Thread: [RESOLVED] Vernum Not Defined?

  1. #1
    Hyperactive Member
    Join Date
    Jun 12
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    315

    Resolved [RESOLVED] Vernum Not Defined?

    Hello Folk, When I'm trying to compile my project i have error msg. as shown in attachment and code below. The fact is i have same formula in other report it's work fine. So please any advice regarding? Thank you all

    xlwk.SaveAs "F:Reports\Shop" & vernum & Format(Date, "~mm-dd-yyyy") & Format(Time, "(h-mm-ss)") & ".xls"
    Last edited by brss; Aug 2nd, 2012 at 01:21 AM.

  2. #2
    Hyperactive Member
    Join Date
    Jun 12
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    315

    Re: Vernum Not Defined?

    Should I defined as

    Dim vernum, am i right?

  3. #3
    PowerPoster
    Join Date
    Feb 12
    Location
    West Virginia
    Posts
    4,948

    Re: Vernum Not Defined?

    Code:
    Dim vernum As String
    Of course you also have to assign it a value

  4. #4
    Hyperactive Member
    Join Date
    Jun 12
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    315

    Re: Vernum Not Defined?

    [RESOLVED] Could anyone show me how to put Thread on resolved because I'm not able to found Resolved option in Thread Tools. Thank you All

  5. #5
    PowerPoster
    Join Date
    Jan 08
    Posts
    6,753

    Re: Vernum Not Defined?

    It's not there so I guess they don't want you to resolve a thread
    The better the information you give to begin with and the sooner you reply the sooner you will get help and get your problem resolved


    When I was young and in my prime I used to program all the time but now I'm old and getting gray I only program once a day

Posting Permissions

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