xlm

  1. P

    Bank

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top