i'm using winwedge to link up a balance to a computer, in order to gather the readings into an excel sheet. i've writen the code that starts winwedge at the press of a button, and created the macro that is supposed to request readings and send them to the excel sheet. Winwedge is configured to request excel to run the macro whenever a reading is sent.
When i initiate winwedge and send data from the balance, it is displayed by winwedge but excel gives an error saying the macro is unavailable or disabled. If i run the macro manually after each reading is sent, it works and displays the values.
Can anyone please give some opinion about what is happening and how i could fix this?
As far as i know i have excel configured to allow macros to work without blocking or asking permission.