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

Thread: Hey VBA types. Thanks for all the Help, Sbirro Cornuto, Iva

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here's the situation
    I am running Office 2000 which, as you know, includes VBA 6.0.
    VB or VBA 6.0 has a new way of dealing with files and directories called the file system object.
    The dll file is scrrun.dll
    Also call Microsoft Scripting Runtime

    Anyway, here is the question. I am fairly new to VBA but am familiar with the File System Object from my experience with VB and do not wish to have to learn a whole new set of rules for dealing with files. I want to make this reference available to someone who is running Office 97. I am creating a workbook for them. Do they simply need to copy the dll to their system directory? Will Office 97 work with the newer dll?

    I appreciate the help!

    Tom

    [ This Message was edited by: TsTom on 2002-03-25 03:01 ]

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

    Default

    Hi

    Intresting comsept co[y or shoul;d i ssay replace dll files???

    I woould not excel i doubt would even know its there unless geristry tells it and i NEVER suggest regedits...

    My call is backwards never work so well forwards will.. E97 is superpowerful and shold do all you wnt bar a few flash bits can you not code in 97 and use on both?


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-24 13:55, Jack in the UK wrote:
    Hi

    Intresting comsept co[y or shoul;d i ssay replace dll files???

    I woould not excel i doubt would even know its there unless geristry tells it and i NEVER suggest regedits...

    My call is backwards never work so well forwards will.. E97 is superpowerful and shold do all you wnt bar a few flash bits can you not code in 97 and use on both?


    What? I'm sorry dude, but what are you saying? I can't make any sence in your post...

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Office 97 should work with newer version of scrrun.dll with no probs, at least mine does. Not so sure just copying that dll makes the FSO reference available, though. Try it and let me know, like I said there shouldn't be problems with that newer dll and Office 97, so if it doesn't give it sure won't take either, right?

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Sbirro Cornuto.

    The dll is self registering.
    Does that mean it will regisiter itself when first called upon.

    Thanks Again

    Tom


  6. #6
    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-03-24 14:55, TsTom wrote:
    Thanks Sbirro Cornuto.

    The dll is self registering.
    Does that mean it will regisiter itself when first called upon.

    Thanks Again

    Tom

    Tom either reference it in your Project via
    the Tools > reference OR Create an object
    link via [CreateObject] eg

    Sub RemoveDir_WithFiles()
    Dim Fs As Object

    On Error GoTo DelErr
    'CAUTION: Will delete entire Folder NO PROMPT
    Set Fs = CreateObject("Scripting.FileSystemObject")
    Fs.DeleteFolder "C:mydir", True

    Exit Sub
    DelErr:
    MsgBox Err.Number & vbCr & _
    Err.Description
    End Sub


    fairly straight forward to use....just look
    up commands in the Project viewer.

    Jack I understood what you were saying and
    yes you are correct in that it should work
    in Excel97....and better to work backwards
    then forwards......




    Ivan

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    As far as I know .dll`s wil register themselves when first being called upon.
    However this only works when they are compatible with the programme ofcourse.

    I shoud say give it a shot.

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
  •