Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Code On Activate | Excel Worksheet Functions | |||
How with VBA, can I activate one of many modules in a VBAProject? | Excel Discussion (Misc queries) | |||
? activate a commandbutton in code ? | Excel Programming | |||
Activate code in cell | Excel Programming | |||
code in VBAProject will not run | Excel Programming |