vba replacing one line of code with two line of codes

75 Views Asked by At

I have this line of code in vba currently:

Set conn = CurrentProject.Connection

I would like to do a global replacement in current project with

conn.ConnectionString =extractConnectionStringADOfromOLE
conn.OPEN

how can i do that using ms-access find and replace tool?

notice: i need to know how vba inserts a line break in the code or another way of doing the replacement.

thanks!

I tried using readable line breaks but the compiler produce errors on the new lines

0

There are 0 best solutions below