Activate code from another VBAProject
 

I have several workbooks each with two sheets, one data & the other is
upload. I copy data to upload sheet. If cell value changes a flag is put in
the row in column 1. I am trying to automate this. I wrote a macro in a new
workbook. I am opening the file, copying the data and pasting the data in
upload sheet. I want to call in the flagging subroutine from the book i am
modifying.

I can reference the vbaproject of the book to my vbaproject, but hten I
can't clos that book before opening the next book. I appreciate, ideas,
suggestions ..
thank you
Murthy

Activate code from another VBAProject
 

Is it possible to park the macro in personal.xls file in which case i
will be avialbale for any workbook you open??

hope i have understood your questiion

--
venkat1926Posted from - http://www.officehelp.i

Activate code from another VBAProject
 

Thank you Venkat:
The problem here is - flgging function calls two macros hidden in that
workbook we are modifying. Probably late binding approach may work, I am
trying that.
Flagging is important because only flagged rows will be uploaded. Oracle
Financials creates these templates to which we copy some data and upload. we
need to invoke template hidden macros.

Any ideas?
Murthy

"venkat1926" wrote:


Is it possible to park the macro in personal.xls file in which case it
will be avialbale for any workbook you open??

hope i have understood your questiion.


--
venkat1926Posted from - http://www.officehelp.in