Hi All, Is there any way to access a different program (in my case..its business objects) using excel macro. I have a business object (BO) document which has 2 tabs and also an template excel file also with 2 tabs. BO Document name: Test.rep Excel template name: Template.xls What I want to do with excel the macro is: I want to copy the contents of the 1 st tab of the BO to the A1 cell of1 st tab & 2 nd tab of BO to A1 cell of the 2 nd tab of the template excel file. Is this possible? Thanks in advance.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Accessing a different program using excel macro

Thread starter krishna334
Start date Jun 20, 2011

krishna334

Active Member

Jun 20, 2011

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

>
<o

></o

>
Is there any way to access a different program (in my case..its business objects) using excel macro.<o

></o

>
<o

> </o

>
I have a business object (BO) document which has 2 tabs and also an template excel file also with 2 tabs.<o

></o

>
<o

> </o

>
BO Document name: Test.rep<o

></o

>
Excel template name: Template.xls<o

></o

>
<o

> </o

>
What I want to do with excel the macro is:<o

></o

>
<o

> </o

>
I want to copy the contents of the 1st tab of the BO to the A1 cell of1st tab & 2nd tab of BO to A1 cell of the 2nd tab of the template excel file.<o

></o

>
<o

> </o

>
Is this possible?

Thanks in advance.<o

></o