Results 1 to 5 of 5

Thread: [RESOLVED] Vernum Not Defined?

  1. Jul 31st, 2012, 05:09 PM #1
    brss
    brss is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2012
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    333

    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.
    Reply With Quote Reply With Quote
  2. Jul 31st, 2012, 05:14 PM #2
    brss
    brss is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2012
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    333

    Re: Vernum Not Defined?

    Should I defined as

    Dim vernum, am i right?
    Reply With Quote Reply With Quote
  3. Jul 31st, 2012, 05:16 PM #3
    DataMiser
    DataMiser is offline
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,206

    Re: Vernum Not Defined?

    Code:
    Dim vernum As String
    Of course you also have to assign it a value
    Reply With Quote Reply With Quote
  4. Jul 31st, 2012, 05:20 PM #4
    brss
    brss is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2012
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    333

    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
    Reply With Quote Reply With Quote
  6. Jul 31st, 2012, 06:01 PM #5
    jmsrickland
    jmsrickland is offline
    PowerPoster
    Join Date
    Jan 2008
    Posts
    11,074

    Re: Vernum Not Defined?

    It's not there so I guess they don't want you to resolve a thread


    Anything I post is an example only and is not intended to be the only solution, the total solution nor the final solution to your request nor do I claim that it is. If you find it useful then it is entirely up to you to make whatever changes necessary you feel are adequate for your purposes.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width