Stack Overflow
Stack Overflow

Questions tagged [xla]

.xla is the file extension for pre-Excel 2007 addins written using VBA. XLA Addins are a special type of workbook that contains VBA code or functions integrated into the Excel or VBA environment.

.xla is the file extension for pre-Excel 2007 addins written using . XLA addins are a special type of workbook that contains code or functions integrated into the Excel or VBA environment. This VBA code is meant to add or extend the built-in functionality provided by Excel.

XLA addins are created in Excel's VBA IDE. After inserting code into a VBA module, the workbook is saved in XLA format. This file may then be loaded by Excel to enhance existing or add new functionality which is integrated into the Excel frontend or development environment.

A common use for XLA addins is as a repository for often used VBA functions. The most frequently used user-defined functions () are placed into a separate workbook, which is saved as an Excel addin (.xla). These functions can then be used as native functions after installing the addin.

Related Tags:

Links: - Build an Excel Add-In

72 questions
0
votes
1 answer

Tensorflow XLA AOT: Eigen related Error Building Project

I'm currently trying to work through the tensorflow XLA ahead of time compilation work flow for the first time, and I've hit a problem while trying to build the final executable binary which includes the AOT compiled object. I've used the tutorial…
PeteBlackerThe3rd
  • 651
  • 5
  • 12
0
votes
1 answer

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 directly.
Marcus Mangelsdorf
  • 2,852
  • 1
  • 30
  • 40
0
votes
1 answer

How is text value stored in Excel cell that references an xla add-in function?

I have an xlsx file that I am trying to parse and one of the cells references an xla add-in function. ='C:\Program Files (x86)\abc\Query and Analysis\LsAgXLB.xla'!AG_SMRT("0,Summary Report 1,1") That file does not exist on my local machine but…
mrab
  • 1
  • 2
0
votes
1 answer

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 people with the same problem, e.g. MS-Excel VBA…
Roland
  • 7,525
  • 13
  • 61
  • 124
0
votes
1 answer

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 update it (ie update the data then save the XLA Add-In)…
Tibo
  • 383
  • 5
  • 27
0
votes
1 answer

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 + ((i - 1) *…
amanized
  • 9
  • 5
0
votes
0 answers

Tensorflow with XLA hangs with both GPU and CPU at ~0% usage

I wanted to try out the XLA backend on tensorflow 1.1.0 which I built from source to support the XLA compiler. Also I am using Ubuntu 16.04. My model runs fine without the XLA backend. It takes about 0.8 seconds to compute a single training step…
chasep255
  • 11,745
  • 8
  • 58
  • 115
0
votes
3 answers

VBA: detecting if a library is available at run-time

I have an xla file that refers to some other Excel add-ins that may or may not be present on the target machine. Currently Excel fails on loading the xla with a "Compile error: Can't find project or library". Code is something like: Dim result as…
John Pickup
  • 31
  • 2
0
votes
1 answer

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 copyFromXLAtoXLSX() temp.Sheet1.Copy Workbooks(1).Sheets(1) End…
Daniel Bonetti
  • 2,306
  • 2
  • 24
  • 33
0
votes
1 answer

Recover from fatal error in excel VBA Workbook_Open?

I stumbled on a way to crash excel in Workbook_Open while making an .xla It's still a toy project, so I've been able to just delete it and start over (and now I'm coming back with version control and baby steps.) However, assuming I didn't have…
Justin Love
  • 4,397
  • 25
  • 36
0
votes
1 answer

How to protect Excel xla from editing with password

I want to give users the ability to use the xla module without specifying the password but whenever someone tries to edit or view the VB source code of the module it should ask for a password. Is this possible to do in Excel? If so how can this be…
Datageek
  • 25,977
  • 6
  • 66
  • 70
0
votes
2 answers

Why is IE 7 renaming downloaded XLA files as XLS when saving?

I have an Excel Add-In file I'm publishing on an intranet (plain ol' HTTP download, not an attachment in Sharepoint, etc.). With IE 7, the user click the link and selects "Save", only to have the file renamed from "myaddin.xla" to "myaddin.xls".…
richardtallent
  • 34,724
  • 14
  • 83
  • 123
1 2 3 4
5