thatoneguy
01-12-2009, 02:06 PM
Background info:
We have a excel file that relies on .dll files to run and we update our .dll files to match the excel sheets. A user must manually run the batch program that simply just runs the .dll in the regsvr32. Using the wrong .dll will result in incorrect data and/or crashing of the excel program.
Looking for:
some help with coding in vba that searches for the .dll used and, at the very least, just displays the .dll path in an excel sheet. Although just the filename would be a bigger improvement.
Notes:
I've tried the application.registeredfunctions with an if null statement and it just returns the null value. This is because the .dll is not installed with the excel file. Maybe some code that searches the registry for the file name? The file will be moved based on the user's preference but never renamed. Also, Excel must be closed and the batch file ran, so a shell statement will not work.
Hope to hear from yall soon. Thanks.
We have a excel file that relies on .dll files to run and we update our .dll files to match the excel sheets. A user must manually run the batch program that simply just runs the .dll in the regsvr32. Using the wrong .dll will result in incorrect data and/or crashing of the excel program.
Looking for:
some help with coding in vba that searches for the .dll used and, at the very least, just displays the .dll path in an excel sheet. Although just the filename would be a bigger improvement.
Notes:
I've tried the application.registeredfunctions with an if null statement and it just returns the null value. This is because the .dll is not installed with the excel file. Maybe some code that searches the registry for the file name? The file will be moved based on the user's preference but never renamed. Also, Excel must be closed and the batch file ran, so a shell statement will not work.
Hope to hear from yall soon. Thanks.