I'm getting an error with filesearch object (office.core)

[Lokean]

At the top of my module I have

Imports Microsoft.Office.Core
Imports VBA

Public Function rpu_process_files(Optional ByVal sFolderString As String = "", _
Optional ByVal sSearchString As String = "", _
Optional ByVal sInExt As String = "", _
Optional ByVal sInPart As String = "", _
Optional ByVal iList As Integer = 0) As Integer



Dim fs3 As Microsoft.Office.Core.FileSearch
fs3.newsearch()



the program errors out at

fs3.newsearch()

"Object reference not set to instance of an object."

what am I doing wrong?

[SammyB]

>what am I doing wrong?
I suspect you need a New

But, what you are really doing wrong is not using the Net Framework classes. Why not use System.IO.Directory.GetFiles?

[Lokean]

>what am I doing wrong?
I suspect you need a New

But, what you are really doing wrong is not using the Net Framework classes. Why not use System.IO.Directory.GetFiles?

When I use a 'new' I get

"New cannot be used on an interface"


as to your question, I am trying to flip a vba program into VB.net without recoding it from scratch.

I have a user form where the user can select any of the MSOFiletypes from a listbox.

[SammyB]

When I use a 'new' I get

"New cannot be used on an interface"


as to your question, I am trying to flip a vba program into VB.net without recoding it from scratch.

I have a user form where the user can select any of the MSOFiletypes from a listbox.

Assuming you are using Excel:

Imports Microsoft.Office.Core
Imports Excel
.
.
.
Dim fs As Microsoft.Office.Core.FileSearch
Dim xlApp As New Excel.Application
fs = xlApp.FileSearch
 

[Lokean]

actually,

I am using VB.net.

I'm trying to convert a program I wrote in MS Excel into a vb.net standalone.

[SammyB]

actually,

I am using VB.net.

I'm trying to convert a program I wrote in MS Excel into a vb.net standalone.

That what I thought. My code above was written in VB.NET. You have to add a COM reference to the Microsoft Excel Object Library, so that you can use the Excel.Application object to get the FileSearch. Your migration is going to be difficult. --Sam