Solved replace one line of code with two using the find and replace tool in ms-access 2010/2021 (1 Viewer)

[Alibaba]

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?

I need to replace the one line of code with two line of codes using the find and replace tools
i tried inserting a readable line break but the compiler produces an error ..

thanks!

 

[Josef P.]

Do you really want that?

I would like to replace Set conn = CurrentProject.Connection with Set conn = MyGlobalFunctionToGetOpenConnection.

Topic: Don't repeat yourself


Note: It would be possible with Mz-Tools.

 

[Alibaba]

so how you replace one line of code with two lines using mz-tools. I have just downloaded it. it can find multiline. It cannot replace multiple lines.
thanks!

 

[jdraw]

There was a presentation a few days ago --now on Youtube. Carlos, the author of MZTools,tells all in this video.

 

[Gasman]

Now crossposted at https://www.accessforums.net/showthread.php?t=89374&p=521756#post521756