1. P


    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...
  2. B

    Cropping a first page header image with VBA

    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...
  3. S

    XML Spreadsheet document.

    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...
  4. Jaafar Tribak

    DDE syntax ?

    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.
  5. Jaafar Tribak

    XLM to read data from a closed workbook. Anybody Knows ?

    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...

Some videos you may like

This Week's Hot Topics