View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Reinhard F. Bentrup Reinhard F. Bentrup is offline
external usenet poster
 
Posts: 6
Default Execution of an externally created VBA code

Hi,

how can I execute a VBA code in EXCEL which has been created by an external
application (C Applikations such as LabWindows CVI) as ASCII code file?

My C application acquires a couple of thousand numbers which I like to open
in EXCEL. The C application writes an CSV-File and launches EXCEL. Now EXCEL
needs to execute a VBA code to format data, created charts etc. which also
has been created by the application as ASCII file (can't be a fixed makro
since the formatting depends on the settings and results of my application).
Once the VBA code is in EXCEL I can launch it via DDE or similar.

Alternatively, can I execute VBA code transfered to EXCEL via DDE?

Thanks - Reinhard