Auto Run and Installation privileges
 

Hi, guys. Two quick (hopefully) questions:
1. Can you tell before an installation of an addin begins whether the
person logged in has installation privileges?
2. How do you do "Auto run" (or whatever it's called) such that the
Excel workbook will automatically "come up" when a CD/disk is inserted?
That is, can I make my "setup" file (which is an Excel workbook with code in
the open workbook event) automatically open when the CD it's on is inserted
into a drive?

I hope this is clear. I'm almost there, thanks to all your wonderful help,
guys. Don't desert me now! :)

TIA

Auto Run and Installation privileges
 

you can create a text file with notepad calling it autorun.inf with th
efollowing
[Autorun]
Open=myfile.xls

I haven't tried this as I haven't got a cg burner

If not try[Autorun]
Open=Startxl.bat

and create another text file called startxl.bat with text like
excel.exe myfile.xls

I'm sure its a simple as this.

As for installation privilidges, they probably don't apply at a
pc/workstation level if your user is only opening a workbook.
You could password protect the workbook so that users with the pwds can
access it maybe?

--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
I Feel Great!
---------------------------------
"zSplash" <zNOSPAMSplash@ gci.net wrote in message
...
Hi, guys. Two quick (hopefully) questions:
1. Can you tell before an installation of an addin begins whether the
person logged in has installation privileges?
2. How do you do "Auto run" (or whatever it's called) such that the
Excel workbook will automatically "come up" when a CD/disk is inserted?
That is, can I make my "setup" file (which is an Excel workbook with code
in
the open workbook event) automatically open when the CD it's on is
inserted
into a drive?

I hope this is clear. I'm almost there, thanks to all your wonderful
help,
guys. Don't desert me now! :)

TIA

Auto Run and Installation privileges
 

Thanks so much, Patrick. I will try the AutoRun code you suggest.

I think my problem is that my "setup" code tries to create a directory in
Program Files to hold the various worksheets of my "program", and if the
user's not an administrators, he can't create a folder in "Program Files".
The quick solution, I guess, is to create the directory somewhere else where
they do have permission. Would have been neat to put it in Program Files,
though.....

Thanks again, Patrick, on the info re AutoRun.

st.

"Patrick Molloy" wrote in message
...
you can create a text file with notepad calling it autorun.inf with th
efollowing
[Autorun]
Open=myfile.xls

I haven't tried this as I haven't got a cg burner

If not try[Autorun]
Open=Startxl.bat

and create another text file called startxl.bat with text like
excel.exe myfile.xls

I'm sure its a simple as this.

As for installation privilidges, they probably don't apply at a
pc/workstation level if your user is only opening a workbook.
You could password protect the workbook so that users with the pwds can
access it maybe?

--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
I Feel Great!
---------------------------------
"zSplash" <zNOSPAMSplash@ gci.net wrote in message
...
Hi, guys. Two quick (hopefully) questions:
1. Can you tell before an installation of an addin begins whether the
person logged in has installation privileges?
2. How do you do "Auto run" (or whatever it's called) such that the
Excel workbook will automatically "come up" when a CD/disk is inserted?
That is, can I make my "setup" file (which is an Excel workbook with
code
in
the open workbook event) automatically open when the CD it's on is
inserted
into a drive?

I hope this is clear. I'm almost there, thanks to all your wonderful
help,
guys. Don't desert me now! :)

TIA