PDA

View Full Version : [SOLVED] How to create xla for Excel from outside



chandansify
07-25-2005, 11:57 PM
Dear All,

I need to know that How can we create xla file from outside of Excel.

Can we create addin xla file using VB.



Thanks in advance.
...........

Killian
07-26-2005, 02:12 AM
I don't see why not.
I would expect something like this to work


Sub MakeXLA()
'save the current workbook as an addin
ThisWorkbook.IsAddin = True
ThisWorkbook.SaveAs "TEST.XLA", xlAddIn
End Sub

Bob Phillips
07-26-2005, 03:44 AM
Dear All,

I need to know that How can we create xla file from outside of Excel.

Can we create addin xla file using VB.

Why would you need to do that?

chandansify
07-28-2005, 09:29 PM
Why would you need to do that?


I need to create addin for excel but not using VBA editor in Excel or by saving xls file as xla from file->saveas->xla fiel.




Can u help me..

Bob Phillips
07-29-2005, 03:44 AM
I need to create addin for excel but not using VBA editor in Excel or by saving xls file as xla from file->saveas->xla fiel.

Killian showed you how, but I am interested in the requirement that drives the question, which you didn't answer you just restated your problem.

So I repeat, why would you want to do this? I cannot imagine a use for it, so enlighten me.

Zack Barresse
07-29-2005, 08:05 AM
Chandansify, it will help others in coming up with a solution if they can wrap their heads around what drives the question and the desired outcome, plus all variables that are going into your situation.

Take care!

chandansify
07-31-2005, 09:45 PM
I don't see why not.
I would expect something like this to work


Sub MakeXLA()
'save the current workbook as an addin
ThisWorkbook.IsAddin = True
ThisWorkbook.SaveAs "TEST.XLA", xlAddIn
End Sub




the code works fine..

here we are writing this code in VBE. ok..

Or we can simply save a file using File-SaveAs-xla manually and manually add addin to excel...

but..



What I am looking is........

Is there any third party tool or any other method available for creating xla???

Like xla addin, is there any other type of thing available -- dll etc that we can use in excel just like xla..



..................................

MWE
08-01-2005, 05:45 AM
the code works fine..

here we are writing this code in VBE. ok..

Or we can simply save a file using File-SaveAs-xla manually and manually add addin to excel...

but..



What I am looking is........

Is there any third party tool or any other method available for creating xla???

Like xla addin, is there any other type of thing available -- dll etc that we can use in excel just like xla..



..................................

but if you are using the VBE to write the code, why not just use the VBE in Excel?

Justinlabenne
08-01-2005, 05:56 AM
I do not understand the point at all, but since I had time to kill at work:

Bob Phillips
08-01-2005, 08:17 AM
I do not understand the point at all

and he seems determined not to tell us

MWE
08-01-2005, 09:29 AM
and he seems determined not to tell us
or, perhaps, there is something lost in the translation ...

Bob Phillips
08-01-2005, 12:39 PM
or, perhaps, there is something lost in the translation ...

My question seems unambiguous to me,



So I repeat, why would you want to do this? I cannot imagine a use for it, so enlighten me.

and Chandansify is showing good English, so I don't think so.

XL-Dennis
08-01-2005, 04:13 PM
Hi,

The short answer is: Create COM add-ins.

If You want to know how then see the section Add-ins links on the following page:
http://www.excelkb.com/article.aspx?id=10008

If You need further help then I strongly recommend You to do the homework first and be polite to answer questions raised.

chandansify
08-07-2005, 10:21 PM
Hi,

The short answer is: Create COM add-ins.

If You want to know how then see the section Add-ins links on the following page:
http://www.excelkb.com/article.aspx?id=10008

If You need further help then I strongly recommend You to do the homework first and be polite to answer questions raised.







Thanks XL-Dennis,

This is something I was looking from the begining but didn't find any clue how to do this.

I am going through the topic from ur link



Thanks


Now its time to study..



Thanks to all