Function ShowFileAccessInfo Problem (Excel2000)

Topic

New Reply

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?

Reply | Quote

Replies

The function works for me. Is it possible that you have moved to a different computer and your network administrator has disabled runtime scripting?

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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??

Reply | Quote

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.

Reply | Quote