Question Accessing VBA Modules in Access 2003 with VB.NET

bathyphen

Member
Joined
Aug 19, 2011
Messages
11
Programming Experience
5-10
I current have the following code to connect & open a .mdb file:
VB.NET:
[SIZE=2]Dim cn [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] OleDbConnection
[/SIZE][SIZE=2]cn = [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] OleDbConnection([/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] & f & [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]";Persist Security Info=False"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2])
cn.Open()
[SIZE=2][COLOR=#008000][SIZE=2][COLOR=#008000]'NEED CODE TO AMEND VBA'
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]Call[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] LogState(Microsoft.VisualBasic.Right(f, Len(f) - Len(vFilepath)) + [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]" | Access 2003 Changed | "[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] & i)
cn.Close()
GC.Collect()[/SIZE][/SIZE]

But I need to access the vba code to find & replace a certain string to something else.

Does anyone know what I need to add to do this?
 
Back
Top