Change A Line in A Module Using VBA Code

D

derrick

Hi,

I have about a 100 workbooks all with the same VBA code in them. I
need to change a line in the VBA code in each of them and would like
to use code rather than opening each of the workbooks and changing it.

Can this be done? I just need the code to reference the line and make
the change - I have the code to open each workbook and close it
already in a directory.

Thanks,
Derrick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba code does not run 3
Import multiple workbooks to current workbook in specified row number 0
VBA worksheet references 5
Save As and new workbook new name used in existing code 8
How open notepad.exe and write text line by line via excel vba? 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Trying to delete sheet code with VBA 2
Opening a list of Excel files and run a macro in each 17

Top