All Questions
29 questions
0
votes
0
answers
58
views
Passing user defined variables to xlam file
How can I pass user-defined variables to xlam files?
I have written a macro and saved on an xlam file.
I reference the xlam in an xlsm file and I call the macro from the xlsm.
I want to pass a user-...
1
vote
2
answers
80
views
Flat Text Import: Field size change
We have a spreadsheet that imports flat text from a design program.
A file has changed. Now, our program will not import correctly.
Old text file:
New text file: The Comment field has increased from ...
- 73
0
votes
0
answers
68
views
Suppress an Excel Error message caused by save button before going into `Workbook_BeforeSave` event
While manually saving an Excel Addin file as xla I'm unable to suppress an Excel eror message.
The error measage occurs before the Workbook_BeforeSave event is triggered.
In Workbook_BeforeSave event ...
- 346
7
votes
2
answers
2k
views
How do I sign an XLA from Excel 2016 with a timestamp?
I am struggling to sign an XLA from Excel 2016 with a timestamp. This is important, because without a timestamp the signature becomes invalid when the code signing certificate used expires. ...
- 768
0
votes
1
answer
2k
views
Calling an XLA add-in method (function/sub) when the add-in is not loaded
I need to call a method that is provided by a third-party XLA add-in via my VBA code.
There are already answers for doing this with a loaded XLL add-in, but the intention is to call the method ...
- 3,090
0
votes
1
answer
675
views
XLA file not saving in Excel 2010
I'm using Excel 2010 and I have a .xla file with VBA macros, I edit the macros with the VBA editor, then save it. Later when I reopen the .xla file my changes are lost. On the internet I found other ...
- 7,875
0
votes
1
answer
408
views
VBA : Updating a Sheet in a XLA Add-In
I'm currently updating a Worksheet in the ActiveWorkbook on the fly from a network file.
I'd like to move this Ws from the ActiveWorkbook into an XLA Add-In.
If I do so, will I still be able to ...
- 393
0
votes
1
answer
2k
views
Excel VBA: Solver not working in loop
The Solver in the loop works for the first iteration but not rest. The rest of the loop works fine.
Sub Macro1()
Sheets("model").Select
Dim i As Double
Dim p As Double
For i = 1 To 10
p = -0.1565 + (...
- 9
5
votes
2
answers
3k
views
How to find path to XLA file in Microsoft Visual Basic for Applications 7
When I open Microsoft Visual Basic for Applications 7, I see the project window. I.e. file1.xla, file2.xlam, etc. If I have multiple files names file1.xla, how do I know which one I'm looking at? I ...
- 6,825
0
votes
1
answer
651
views
VBA copy sheet from a .XLSX and insert it into a .XLA file
I'm trying to copy a Sheet from a .XLSX file as a hidden sheet in a .XLA file.
I only managed to copy from .XLA -> XLSX, but not XLSX -> XLA.
Take a look at my two functions:
Sub ...
- 2,426
1
vote
0
answers
2k
views
how to see the source code in this excel5 .xla file
I want to know how to open the source code VBA of this file. It is a .xla file and it was created in Excel 5.
https://www.hightail.com/dl?phi_action=app/orchestrateDownload&rurl=https%3A%2F%2Fwww....
- 55
2
votes
1
answer
404
views
Best way to provide help content along with a .xla add-in
I am about to deploy an excel addin (.xla) for coworkers to use (Office 2007).
Is there a way to embed a help file somewhere?
UPDATE
I've made it by including the .PDF file as an Object embedded ...
- 461
2
votes
1
answer
2k
views
Worksheet_SelectionChange event in xla add-in
Is to possible to trigger Worksheet_SelectionChange event in xla add-in. I put the code in Worksheet module of add-in. but it did not enter into this module. My target is to set the comment box in the ...
- 8,508
8
votes
1
answer
4k
views
Expose class in Excel XLA add-in
I have written an XLA add-in for Excel. This add in includes a class module. I was wondering how I can expose this class module for use. I have searched around and found a way to do it with Visual ...
- 851
1
vote
1
answer
3k
views
how to load sapbex.xla when the workbook opens
I open a query from SAP BW... I make all the changes I need and I even check the box that says Refresh query every time you open the workbook. The problem is that when I reopen the workbook it's just ...
- 1,827