Activate code from another VBAProject

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

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

Programmatically Open Locked VBAProject 5
Excel Move or Copy Stopped Working? 0
VBAProjects remain in memory after workbook is closed 17
Run code from another workbook 7
VBAProject duplicates 5
Visual Basic Personal Notebook? 2
Run macro from active workbook whose name keeps changing 20
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1

Back
Top