I have an external application that offers the possibility to export files to excel at which time excel opens (is called) and data is written into a new sheet.
The user is then to save this sheet for further processing in again a multitude of reports and stuff.
Since the date and decimal format is quite bizarre, I want to identify in the _open event what the calling application is (in this case the external application) and change some settings so that dates etc are in the user's default format.
Can I - how do I identify the application that is calling excel ? (this is the opposite of calling another application from excel, which I know how to do).
The exporter is set up in such a strange way that changing the formats /after/ all data is loaded (so not with the _Open even but later) is no option.
Currently 1425 might be 0,1425 or 1,425 or 14,25 or 142,5 or 1425 alltogether, the settings need to be changed /before/ the first record is exported.
Needless to say, I have no means of changing the external calling application.
The user is then to save this sheet for further processing in again a multitude of reports and stuff.
Since the date and decimal format is quite bizarre, I want to identify in the _open event what the calling application is (in this case the external application) and change some settings so that dates etc are in the user's default format.
Can I - how do I identify the application that is calling excel ? (this is the opposite of calling another application from excel, which I know how to do).
The exporter is set up in such a strange way that changing the formats /after/ all data is loaded (so not with the _Open even but later) is no option.
Currently 1425 might be 0,1425 or 1,425 or 14,25 or 142,5 or 1425 alltogether, the settings need to be changed /before/ the first record is exported.
Needless to say, I have no means of changing the external calling application.
