Moving macro from Excell 2003 to Excell 2010

[JanoT]

Hi,
my macro Excell 2003 starts:
.
.
Dim fso As New FileSystemObject
Set co = CreateObject("Scripting.FileSystemObject")
Set wf = Application.WorksheetFunction
Set fs = Application.FileSearch
.
.

I have tried run in Excell 2010 and there appeard error message:

Compile error:
Can´t find project or library.

Could somebody advice me?

 

[Sektor]

Why do you want to create to FileSystemObject variables? To "Dim fso As New FileSystemObject" to work, you need to go here: Tools -> Reference -> Microsoft Scripting Runtime.

 

[JanoT]

Hi,
my macro Excell 2003 starts:
.
.
Dim fso As New FileSystemObject
Set co = CreateObject("Scripting.FileSystemObject")
Set wf = Application.WorksheetFunction
Set fs = Application.FileSearch
.
.

I have tried run in Excell 2010 and there appeard error message:

Compile error:
Can´t find project or library.

Problem is with code "Dim fso As New FileSystemObject".

Could somebody advice me?

 

[JanoT]

I have marked this refference.
I´d like add picture but wthout success.

 

[JanoT]

Why do you want to create to FileSystemObject variables? To "Dim fso As New FileSystemObject" to work, you need to go here: Tools -> Reference -> Microsoft Scripting Runtime.

I have merked this reffernces.

 

[Sektor]

N/A.

 

[JanoT]

N/A.

Yes, read. In list of my marked reffernces is allready Microsoft Scripting Runtime.

 

[Sektor]

Can you post workbook?

 

[VoG]

Application.Filesearch is not available in Excel 2007 or 2010. If you do a search of the board you should find some alternatives.

 

[JanoT]

Can you post workbook?

Yes, I can. But how? I am first time in this forum, excuse my low
level of expiriences.