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
1
vote
1 answer

Deleting TableStyle from excel

I have added a TableStyle to excel workbook using the statement: ActiveWorkbook.TableStyles.Add("PivotTable SS") I can delete it using: ActiveWorkbook.TableStyles("PivotTable SS").Delete How can I programmatically check if it already exists before…
Rashmi Pandit
  • 23,230
  • 17
  • 71
  • 111
0
votes
2 answers

Creating/using custom VBA libraries in Excel

I've been working on a project for my team at work to use. The Excel 2003 spreadsheet is on an NT NFS so they can all use it. I like XLAs, but one annoying thing about them is it seems that they don't seem to be workbook dependent. Installing it for…
Wes
  • 1,183
  • 3
  • 23
  • 51
0
votes
0 answers

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-defined variable to the macro, the user-defined…
0
votes
1 answer

HLO protobuf to pytorch / tensorflow graph

Assume we have HLO protobuf from a model through Pytorch-XLA or Tensorflow. Is there a way to create computational graph from it? Is it possible to create Pytorch-XLA and Tensorflow model from it? In python, input has following type …
Roy
  • 65
  • 2
  • 15
  • 40
0
votes
1 answer

Enable multiprocessing on pytorch XLA for TPU VM

I'm fairly new to this and have little to no experience. I had a notebook running PyTorch that I wanted to run a Google Cloud TPU VM. Machine specs: - Ubuntu - TPU v2-8 - pt-2.0 I should have 8 cores. Correct me if I'm wrong. So, I followed the…
Adham Ali
  • 81
  • 8
0
votes
0 answers

Get computation cost of running a tensorflow graph

I have a frozen tensorflow graph, and I'm wondering what the best method is to get the computation cost of running it(assuming it only uses deterministic operations and nothing that makes it turing complete like while loops). Is there a way to run a…
Dan8757
  • 53
  • 1
  • 5
0
votes
0 answers

Is there any way to create the xla_client with CPU and GPU?

I'm using this code as a baseline. But in this xla_client, I can only use the GPU resources. However I want to use the CPU swap(unified) memory as a GPU resources. How could I create the xla_client with CPU memory support version? Is there any…
0
votes
0 answers

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 I am setting the IsAddin back to TRUE, and the…
Noam Brand
  • 335
  • 3
  • 13
0
votes
0 answers

what can casue "LLVM ERROR: Trying to register different dialects for the same namespace"

I'm using jax on ubuntu 18.04. Actually I'm using a new backend of jax which is implemented outside from the XLA source tree. The code can be built successfully, but gets a runtime error "LLVM ERROR: Trying to register different dialects for the…
ipe_zyz
  • 3
  • 1
0
votes
1 answer

VBA created with Excel 2003 loaded OK in Excel 2007, but there's nothing in Project tree of VB editor

I have created a VBA in excel 2003 and save it in xla format. This AddIn add a new menu and some submenu in toolbar of Excel. All work well until I upgrade to Office 2007, then I open the xla file. No error message shown, but when I view the macro…
giang.asl.8
  • 313
  • 2
  • 11
0
votes
0 answers

How to get a coarse-grained op-level graph in tensorflow

I want to use tensorflow to get the full computation graph (including forward, backward and parameter update). I tried tf.functions, but the graph I got is too fine-grained, as many ops (Adam for example) are splited into smaller operators (add,…
Jason
  • 1
0
votes
1 answer

Tensorflow with XLA doesn't fully utilize CPU capacity

I have created a Monte-Carlo simulation model implemented in Tensorflow 2.5. The model mostly consists of vector multiplications inside a tf.while_loop. I am benchmarking the performance on a Linux machine with 8 virtual CPUs. When I run the model…
photon1981
  • 11
  • 2
0
votes
0 answers

XLA rng-bit-generator takes too much memory

XLA allocates 4G of memory to this tensor. The size of which seems to scale with the batch size. Which doesn't make sense to me, it doesn't seem to be part of the model graph to be stored in HBM. I use a TPUv3. I don't use any random operation apart…
iordanis
  • 1,284
  • 2
  • 15
  • 28
0
votes
0 answers

Very slow jit compile for XLA when using jax

I am using Jax to do some machine learning jobs. Jax uses XLA to do some just-in-time compile for acceleration but the compile itself is too slow on CPU. My situation is that the CPU will only use just a single core to do the compile, which is not…
0
votes
1 answer

Is XLA Compiler enabled by default in tf 2.2

My system has Tensorflow 2.2 (Python 3.8, anaconda). I read about the Tensorflow XLA Compiler and to my understanding it is an alternative way to precompiled GPU operations that Tensorflow ships with. Even when I run code without eager execution or…