excel - Return Value From One Workbook' VBA To Another Workbook' VBA -
i have 2 workbooks vbas. pass value returned wba!vba1 wbb!vba2; both workbooks running under same excel application.
for example, in wba!vba1, there
x = function()
, return integer 0 if run successfully;
i want pass returned value 0
wbb!vba2 other operations.
from can see asking. want able store variable wba inside of vba , view in vba in wbb. knowledge not possible variables created @ run time. once process has finished variables cleared. 1 thing run vba in wba , store ever variables need in hidden sheet. way in wbb can call vba , variables have stored in hidden sheet.
so getting variables not @ run time. have call each macro seperatly.
or way have code stored in personal macro book or workbook, need set references wba , wbb. code ran in seperatly , can view variables in vba.
Comments
Post a Comment