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

Tom Schreiner · Mar 24th, 2002, 02:43 PM

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 ]

Jack in the UK · Mar 24th, 2002, 02:55 PM

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?

Sbirro Cornuto · Mar 24th, 2002, 03:01 PM

Quote:

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

Sbirro Cornuto · Mar 24th, 2002, 03:18 PM

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?

Tom Schreiner · Mar 24th, 2002, 03:55 PM

Thanks Sbirro Cornuto.

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

Thanks Again

Tom

Ivan F Moala · Mar 25th, 2002, 03:07 AM

Quote:

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

Dinictus · Mar 25th, 2002, 03:14 AM

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.

Mar 24th, 2002, 02:55 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 02:43 PM	#1
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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 ]

Mar 24th, 2002, 03:18 PM	#4
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	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?

Mar 24th, 2002, 03:55 PM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Thanks Sbirro Cornuto. The dll is self registering. Does that mean it will regisiter itself when first called upon. Thanks Again Tom

Mar 25th, 2002, 03:14 AM	#7
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	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.