Integrating xls with vba
 

Hi

I have program that generates a .xls file with only one cell of data
(number)
And nother program that generates the VBA macros into a .bas file that
sets the format for the number.

I am integrating both using the VB editor of Excel.
But i want to integrate them from the code and generate only one .xls
file instead of two (.xls and .bas).

I know that in case of Excel 4, we write the macro tags in BIFF 8
format... what is the corresponding format required in VBA.

Also in Excel 4 to run the macros i call the "Auto_Open" macro, what is
the entry point in VBA and how to i set a auto run when the sheet
opens.

Thanks and Regards
Arun


--
coder_arun
------------------------------------------------------------------------
coder_arun's Profile: http://www.excelforum.com/member.php...o&userid=33811
View this thread: http://www.excelforum.com/showthread...hreadid=574193