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)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.