PDA

View Full Version : [SOLVED:] Using a VBA code to change another VBA code



susanreynold
02-04-2024, 01:47 AM
Hello,

I have an Excel project, and I'd like to change a part of my code using another VBA code, created in a different workbook. Is it possible? it being possible, someone can help me?

June7
02-04-2024, 02:27 AM
So you want the workbook that is open to be modified by code in another workbook that is closed?

susanreynold
02-04-2024, 02:36 AM
So you want the workbook that is open to be modified by code in another workbook that is closed?
Yes

June7
02-04-2024, 02:57 PM
I have to ask again to verify - code in open workbook that calls a procedure in a closed workbook to modify the open workbook? Sounds bizarre at least. I have no idea if that can be done.

For a start, look at options that call a procedure in another workbook. Review https://stackoverflow.com/questions/10012463/how-to-call-function-from-another-specific-workbook-in-vba

susanreynold
02-04-2024, 06:17 PM
I got it! Thanks for your answer.

uno online (https://uno-online.io)