trouble with using filesystemobject in vba

Question

I'm having trouble using filesystemobject in a vba function I am writing. I keeping getting the error: Runtime error 424 Object required

I have found lots of stuff online but none of it has done any good. Yes I have checked the References and Microsoft Scripting Runtime is checked. Here is as snippet of code please tell me what I am doing wrong. I have tried changing the first line to Dim objFSO as New FileSystemObject among other things but they are produce the same error. The error occurs on the second line.

Dim objFSO
Set objFSO = CreateObject(”Scripting.FileSystemObject”)

Fionnuala · Accepted Answer · 2012-05-21 19:43:28Z

2

You are using odd quotes, use plain quotes.

Dim objFSO
Set objFSO = CreateObject("Scripting.FileSystemObject")

answered May 21, 2012 at 19:43

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ken Over a year ago

Ahh that's what I get for copying and pasting from the internet. I should have been more aware of that. Thank you

sigil · Accepted Answer · 2012-05-21 23:39:27Z

-1

If you add a reference to Microsoft Scripting Runtime, you don't need to use CreateObject; instead you can just call:

Dim objFSO=new FileSystemObject

answered May 21, 2012 at 23:39

sigil

9,62244 gold badges129 silver badges217 bronze badges

2 Comments

Smandoli Over a year ago

This doesn't address the problem, and it appears to have been posted hours after the true solution was posted and acknowledged. Also the line of code is not accepted in the VBA editor.

sigil Over a year ago

You're right, it should be the line Dim objFSO as FileSystemObject followed by the line Set objFSO = New FileSystemObject. Rookie error from my early days of learning VBA.

Collectives™ on Stack Overflow

trouble with using filesystemobject in vba

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related