I current have the following code to connect & open a .mdb file:
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?
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?