Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA not recognised
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. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA not recognised
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. -- Regards, Tom Ogilvy "dhiraj " wrote in message ... 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. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.xls not recognised as excel anymore | Excel Discussion (Misc queries) | |||
Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
Numeric copied from webpage can't be recognised by Excel | Excel Worksheet Functions | |||
Is this formula 100*(PRODUCT(1+C3:N3/100)-1) recognised by Excel | Excel Worksheet Functions | |||
Name not recognised | Excel Programming |