Several years ago, I did something similar with a UNIX application
that exported a file in a "spreadsheet" format.
If I understand your problem correctly, your CQCS application is CREATING a file
that is supposed to be in a spreadsheet format (lotus).
You've also written a macro  that manipulates this data and you would like to
have
it automatically  run when you open the file.
The problem is that in order for the macro to run  "automatically", it needs to
be
put in the file and called "Auto_Open" or in the worksheet module as an
Initialize subroutine.
This really can't be done from "outside" the file, for several reasons.
Your macro is a VBA macro module. The file the HP box is creating is in a
format that "resembles" a Lotus 123 file format. Excel recognizes it as a
"spreadsheet" and converts it to Excel when it is opened. It's been many years,
but if I remember correctly, the macros I wrote in Lotus123 did not come across
to Excel when we migrated. So I don't think this approach would work.
The way I got around it is that I created a macro "control" file in Excel.
This file had an Auto_Open macro that in turn, opened the updated data file and
did the file manipulation. So, in essence, instead of opening the data file,
you opened the "control" file and had IT open the data file.