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
8
votes
5 answers

Possible to tell which workbook called a function in an Excel Add-In (xla)

I want to write a little logging function in an excel add-in that I will be calling from many different workbooks. I'd like to be able to just call it by passing only the log text, and the log function itself could handle the timestamp,…
tbone
  • 5,715
  • 20
  • 87
  • 134
7
votes
2 answers

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. Unfortunately by default Excel does not apply a timestamp…
davidm_uk
  • 658
  • 6
  • 19
7
votes
1 answer

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 Studio, but sadly I do not have visual studio. Is…
DasPete
  • 831
  • 2
  • 18
  • 37
6
votes
5 answers

How to stop Excel storing the absolute path to an XLA?

I have an XLA file that is to be deployed to a number of users in the organisation as an Excel add-in. My intention is to deploy it to a directory in the user's "documents and settings" folder in "Application Data\MyCompany". (In fact this is all…
John Pickup
  • 5,015
  • 2
  • 22
  • 15
6
votes
1 answer

Excel 2003 - How to build my own XLA?

How can you make the .xla file if you want to create your own xla? I have the code, classes, shapes, etc....what is the process to making an xla file to point to? I know that I have to put it in my program files folder, and then go through the steps…
Justin
  • 4,461
  • 22
  • 87
  • 152
4
votes
3 answers

Change .xla File with MSBuild

I'm trying to create a build script for my current project, which includes an Excel Add-in. The Add-in contains a VBProject with a file modGlobal with a variable version_Number. This number needs to be changed for every build. The exact…
David J. Sokol
  • 3,456
  • 3
  • 31
  • 25
4
votes
0 answers

Visualize TensorFlow graphs before and after Grappler passes?

I've been trying to visualize the graph of a tf.function with and without Grappler optimizations but so far I’m not managing to see any difference in the generated graphs. Here is the process I followed: I took the code used in the “TensorFlow graph…
Paul Delestrac
  • 41
  • 3
4
votes
2 answers

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 can't find the path to the file in the IDE. I have…
Hoppe
  • 6,508
  • 17
  • 60
  • 114
3
votes
1 answer

How do I sign an XLA (Excel add in)?

And is is possible to do that from code?
Arve
  • 7,284
  • 5
  • 37
  • 41
3
votes
3 answers

Excel VBA Recalculate Selection

I've got some Excel spreadsheets that are hitting the database pretty hard (100+ queries against the general ledger table... yikes!). Refreshing just the sheet I'm on (SHIFT+F9) is helpful in some spreadsheets, but I wanted a way to refresh just the…
Scott
  • 6,411
  • 6
  • 39
  • 43
2
votes
0 answers

Tensorflow XLA Conv1D operator not supported?

I would like to compile a tensorflow (2.3) keras model using tfcompile. The model uses the conv1d operator. During compilation I get the following error: INVALID ARGUMENTS: Detected unsupported operations when trying to compile graph tfcompile on…
lucgig
  • 31
  • 3
2
votes
1 answer

torch_xla rendezvous at the end of a function causes "Failed to meet rendezvous" error

I'm currently trying to run some code on multiple tpu cores on Google Colab but I seem to get an error when the synchronization code (xm.rendezvous) is called at the end of the target function but now when the synchronization code is at the top.…
btomtom5
  • 842
  • 8
  • 16
2
votes
0 answers

How can I gdb tfcompile by using bazel build?

tfcompile is a binary file to compile an inference graph into executable code for tensorflow XLA which created by bazel build. If I want to gdb tfcompile file on ubuntu 16.04, it will return message Reading symbols from /PWD/tfcompile...(no…
Sam Huang
  • 21
  • 2
2
votes
2 answers

XLA vs COM vs Automation vs Managed-Code Add-in

I need your help in deciding the best strategy and technology to choose from for the continuing development of a successful in-house VBA application. In our company (a web-based distributor of financial information), over the years, we have…
FACamargo
  • 154
  • 9
2
votes
1 answer

Excel Add in VSTO don't work when other XLA add in are installed

I have developed an Excel Add in with C#, and was working fine. But since i had installed another Add in written in VBS in XLA file, my C# Add in doesn't work anymore... Does anyone faced this situation before? how can i proceed to resolve that? Can…
Sabri ghazi
  • 31
  • 4
1
2 3 4 5