sarduspater
Programmer
Using vb6 I created a DLL with many functions I use in vba.
Now I would know wich program is calling my DLL (within it).
If excel is calling it, GetModuleFileName function of kernel32.dll returns c:\..\..\excel.exe, but I would know wich workbook is running (Application.ActiveWorkbook.FullName).
Same problem is within Access (mdd or accdb name).
Any suggest?
Thanks in advance.
Candu si tene su 'entu es prezisu bentolare.
Now I would know wich program is calling my DLL (within it).
If excel is calling it, GetModuleFileName function of kernel32.dll returns c:\..\..\excel.exe, but I would know wich workbook is running (Application.ActiveWorkbook.FullName).
Same problem is within Access (mdd or accdb name).
Any suggest?
Thanks in advance.
Candu si tene su 'entu es prezisu bentolare.