ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using xla's on a shared drive (https://www.excelbanter.com/excel-programming/433526-using-xlas-shared-drive.html)

K_Macd

Using xla's on a shared drive
 

I came across a post in 2005 (Thomlinson/RB Smissaert) that suggested have a
loader add-in on the workstation that opened the add-in on a shared drive not
as add-in but as a normal but hidden xls file. There was some suggestion that
excel couldn't handle add-ins remote from the host but I have not tested this.

My question though is if a pseudo xla or a genuine referenced xla on the
shared drive is already open will a second user be greeted by the 'File is in
use/Read only/Cancel/Notify' dialog?

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"

Charles Williams

Using xla's on a shared drive
 
No, it works fine: see my auto-reversioning add-in loader. download from
http://www.decisionmodels.com/downloads.htm

The Add-In Loader is designed to solve some of the problems of maintaining
and loading Add-Ins on a network:

Dynamic reversioning of add-ins with automatic link updating.

Control from a central point which add-ins will be automatically loaded
when Excel starts.

Control from a central point which add-ins will be available for
on-demand loading.

Enable updated versions of an add-in to be placed on a server at the
same time as previous versions are in use.

Optionally specify and/or change the network path for each add-in.

No Registry changes for load and unload.

The Add-In Loader helps the User:

Improve Excel start-up time by bypassing the loading of add-ins that are
only needed intermittently.

Minimize memory use by loading add-ins when needed and easily unloading
them when not needed.

Dynamically load the latest version of an add-in, whilst unloading any
version which is currently loaded.

Dynamically update any links that point to old versions of loaded
add-ins when a workbook is opened or an add-in is loaded.


--
Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"K_Macd" <kmacdonald "A_T" activ8 ''D O T'' net [ST OP] au wrote in message
...

I came across a post in 2005 (Thomlinson/RB Smissaert) that suggested have
a
loader add-in on the workstation that opened the add-in on a shared drive
not
as add-in but as a normal but hidden xls file. There was some suggestion
that
excel couldn't handle add-ins remote from the host but I have not tested
this.

My question though is if a pseudo xla or a genuine referenced xla on the
shared drive is already open will a second user be greeted by the 'File is
in
use/Read only/Cancel/Notify' dialog?

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"





All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com