xlm

Hi everyone, I have an Excel workbook that's created by running some VBA. Whenever i save the file and reopen it, there occurs an error: "Excel was able to open the file by repairing or removing the unreadable content. Repaired Part: /xl/worksheet/sheet31.xml-Part." The file does get...

Over several years, I have been creating and updating an elaborate spreadsheet using VBA and XLM 4 macros. It all works fine. You may wonder why I still use XLM 4 type macros - and my reply is to admit that my detailed experience of VBA is very, very limited and since the XLM macro operates...

Hello all-powerful MrExcel board, I have been dabbling with VBA in Excel for a few years and recently rewrote several routines to make them more bulletproof. Here is what I am attempting to do: Create a new worksheet Copy the information as needed from another worksheet Format the new sheet...

We received an Excel spreadsheet that is actually an XML document. Excel can open it a-ok however we need to consume it using: "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" and when the program accesses this XML document it fails. Modifying the program is not a great option. However...

Does anybody know where I can find a list showing the names/syntax of all the DDE Topics and Commands exposed by Excel ? I gather DDE uses XLM like syntax . If so, is there a standard rule that one should follow to pass from XLM to DDE syntax ? Any help on this much appreciated. Regards.

I know how to read a cell value from a closed workbook using the XLM macro ExecuteExcel4Macro . Is it possible to write to a cell in a closed workbook using a similar approach obviously without opening the workbook. I am not looking for an ADO or other solution . I am specifically asking if...