Excel VBA not recognised

[dhiraj]

Hi,

I have a java application. his application stores data in the form of a
CSV file. Im opening it in excel. everything fine so far. Later when i
try to run a macro from another open worksheet by going to
Tools-Macro-Macro, i dont find the other macros.
I think that as this file is saved as a CSV file &
opened in excel it does not recognise the other worksheets.
Else is there a possibilty that i write a macro in
VBA,save it as a VBA/Text file. import this to the worksheet (doing
this from java).It would be great if you can help me & tel me how to
overcome this issue.

 

[Tom Ogilvy]

While you have a CSV file open in Excel, you can treat it like a workbook,
including inserting modules and writing code. However, if you then save it
as CSV, all but the basic data will be discarded.

Not sure if this is the nature of your problem or not.