Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: WorkBook Naming

  1. #1
    Guest

    Default


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Thats blank that one.. please try again

    Rdgs
    ==========
    Jack

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK what I ment was is it faster to use a
    Publicconst workbook as string _ = "workbookname.xls
    or is there another way???
    This is to reference a workbookname through all procedures!

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-20 16:39, brettvba wrote:
    OK what I ment was is it faster to use a
    Publicconst workbook as string _ = "workbookname.xls
    or is there another way???
    This is to reference a workbookname through all procedures!
    I don't think speed is the issue with this declaration....it is just more efficient
    and better programing if you work with this
    particular workbook name over a large project
    to declare it once and use it many times....



    Ivan

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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