mikeburg
05-12-2011, 09:58 AM
(1) How can I cause a file on a CD to automatically play the CD & open the .xls file in excel when it's loaded in a drive of a computer that has excel loaded?
(2) Once the excel file opens, what would be the Auto Open VBA to save it in that particular computer's excel default directory?
(3) Is there a way to not have Auto Open VBA try to run if a computer's security is set too high (open the file without running Auto Open)?
I hope these 3 questions are related enough to be in one post.
Thanks a million for any help. mikeburg
(2) Once the excel file opens, what would be the Auto Open VBA to save it in that particular computer's excel default directory?
(3) Is there a way to not have Auto Open VBA try to run if a computer's security is set too high (open the file without running Auto Open)?
I hope these 3 questions are related enough to be in one post.
Thanks a million for any help. mikeburg