newbie question on app distribution -

J

jon Anunson

Hi.
I've written an excel workbook that contains considerable VBA in it, including
a lot of strings, arrays, SQL, ODBC, etc... obviously, i'm referencing libraries
for the code. Now i want to make this a template and put it on my enterprise's
network. How do i get the workbook to work on someone elses computer if
they don't have the same dlls, etc. installed?
 
J

jon Anunson

Hello jon,
Hi.
I've written an excel workbook that contains considerable VBA in it,
including
a lot of strings, arrays, SQL, ODBC, etc... obviously, i'm referencing
libraries
for the code. Now i want to make this a template and put it on my
enterprise's
network. How do i get the workbook to work on someone elses computer
if
they don't have the same dlls, etc. installed?
Click to expand...


To clarify after more research -
It looks like the chr(integer) function is causing trouble on some systems
that lack that dll (?)
Does early/late binding help me detect this before it errors?
Is there a way to bind references in the project to the file itself so that
i can distribute the file network wide and have it carry the required references
with it?
 
Top