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

L

Legacy 98055

Guest
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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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?
 
Upvote 0
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...
 
Upvote 0
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?
 
Upvote 0
Thanks Sbirro Cornuto.

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

Thanks Again

Tom
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,245
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top