Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    New York, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Function ShowFileAccessInfo Problem (Excel2000)

    Quite awhile ago I copied a function from Rory to show information. It worked fine then. I opened it today and all I got was #Value in the cells for the functions. I have a reference to the scripting library.

    I put in a break and it goes to the first Set and then back to the With statement. It does this three times then exits.

    Anybody have a suggection?



    <IMG SRC=http://users.adelphia.net/~tcpeterson/Function.jpg>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Function ShowFileAccessInfo Problem (Excel2000)

    The function works for me. Is it possible that you have moved to a different computer and your network administrator has disabled runtime scripting?
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Location
    New York, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function ShowFileAccessInfo Problem (Excel2000)

    Sam,

    I am on the same computer, no server. Strange behavior for sure. I have attached the file so someone can check if it is my machine.

    Thanx

    Thom
    Attached Files Attached Files

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Location
    New York, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function ShowFileAccessInfo Problem (Excel2000)

    Well I found the problem! I am running scrrun.dll 5.6.0.6626 on Windows 2000. I uninstalled it and registered an older version and everything is OK. I'm thinking something wrote to the dll and so I register scrrun.dll (5.6.0.6626) from Microsoft and same previous problem. It is with that version which can be checked by right clicking the properties of the file. I will try to install another version and will let you know what I come up with.

  5. #5
    Star Lounger
    Join Date
    Mar 2001
    Location
    New York, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function ShowFileAccessInfo Problem (Excel2000)

    What the hay!!!! I thought I found the problem but ends up I didn't!! How much time I spend on these types of things is just amazing.

    I got the new version srrun.dll (5.6.0.6626) from Microsoft and put it back on like it was originally. Opened Excel and the function worked. Shut Excel down and started it back up and presto, it didn't work. I opened another spreadsheet with some VBA code, ran it. Opened up the ShowFileAccessInfo sheet and it works. This goes on and on working and then not working.

    Since the function ShowFileAccessInfo was the only code I added a simple Auto_Open to select cell A1. Now it opens and the cells with the functions display OK. That is until I do a Ctl-Alt-F9 or a F2-Enter and then I get #VALUE errors and the function don't work. I also cannot put in a new ShowFileAccessInfo function without an error.

    Best guess I can think of is some problem with the calculation engine??

  6. #6
    Star Lounger
    Join Date
    Mar 2001
    Location
    New York, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function ShowFileAccessInfo Problem (Excel2000)

    Well I found the problem at last. Rory's function was using GetFile(strFileName). This works if you are referring to the default directory. My VBA stuff is in C:XlsVBA. I changed it to GetFile(strFileFullName) at it works just fine. I guess it would work sometimes because it must see the directory while it is created but then looses it after starting back up.

Posting Permissions

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