Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Tue Sep 25, 2018 7:37 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: Create a AddIn for MS Office
PostPosted: Fri Jun 08, 2012 11:01 am 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
Is it possible to create a AddIn for MS Office ?
I saw some examples in VB6 and VB.NET, they use "interop" and things alike.

Any ideas ?

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
 Post subject: Re: Create a AddIn for MS Office
PostPosted: Fri Jun 08, 2012 12:29 pm 
Offline

Joined: Sat Oct 01, 2005 5:19 pm
Posts: 3216
Are you asking if RB compiles to .ECF, XLL ... filetypes?


Top
 Profile  
Reply with quote  
 Post subject: Re: Create a AddIn for MS Office
PostPosted: Fri Jun 08, 2012 3:29 pm 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
No... Not create the those files exactly, since RB cannot compile DLL or other kind of files to be used under ms windows.

XLL would be very nice to have but is very difficult to create, I bought book on the subject , Excel add-in C++ from Steve Dalton
It is very detailed, but I was not willing to learn C++ to create specific DLLs, known as XLL for Excel.

I would like to create a component or something similar to .OCX file, or kind of COM Add In..., please take a look in this link below it explain what I do want
http://www.cpearson.com/Excel/CreatingCOMAddIn.aspx

Doesn't need to be exactly the same but at least similar...
I want to control MS Office Application from inside as well, with a Command Bar.

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
 Post subject: Re: Create a AddIn for MS Office
PostPosted: Fri Jun 08, 2012 7:39 pm 
Offline
Real Software Engineer

Joined: Sat Dec 24, 2005 8:18 pm
Posts: 7858
Location: Canada, Alberta, Near Red Deer
Quote:
A CAI is an ActiveX DLL that is compiled into native machine code


Since RS cannot create DLL's - no you can't do this.

Not that we don't want to be able to create dll's / .so's / dylibs its just not trivial to do and we have a LOT of other things already under way and simply do not have the resources to devote to making this happen (it's a big job all by itself)

_________________
Norman Palardy (Real Software)


Top
 Profile  
Reply with quote  
 Post subject: Re: Create a AddIn for MS Office
PostPosted: Fri Jun 08, 2012 8:00 pm 
Offline

Joined: Sat Oct 01, 2005 5:19 pm
Posts: 3216
Search for Add-In Express


Top
 Profile  
Reply with quote  
 Post subject: Re: Create a AddIn for MS Office
PostPosted: Sat Jun 09, 2012 8:35 am 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
Jym wrote:
Search for Add-In Express



Jym,

I know add-in express, it doesn't create any add-in by itself,
http://www.add-in-express.com/add-in-net/index.php,
it can be used under .NET MS software programming package.

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
 Post subject: Re: Create a AddIn for MS Office
PostPosted: Sat Jun 09, 2012 8:59 am 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
npalardy wrote:
Quote:
A CAI is an ActiveX DLL that is compiled into native machine code


Since RS cannot create DLL's - no you can't do this.

Not that we don't want to be able to create dll's / .so's / dylibs its just not trivial to do and we have a LOT of other things already under way and simply do not have the resources to devote to making this happen (it's a big job all by itself)


There is a great book, "Data Analysis & Decision Making" by ALBRIGHT, WINSTON and ZAPPE.
It comes with 3 CDs, and a development called "Decision Tools" version 4.5

You can find the same tool here : http://www.palisade.com/risk/ for the version 5.7
Take a good look and see what that company was able to develop in MS Excel... (it has DLLs, and a EXE that control the whole thing)
It is amazing !!!

That is what I want to be able to do with RB, the "@Risk" which is one of the modules of DT has this .EXE that interact with the Excel...
Any suggestion, how I could accomplish something like that with RB ?

For what I have received as response I believe I will not be able to do any of this with RB, which I will have to think about it.

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group