Home Image-Pro Automation (Macros, Apps, Reports)

Compatability of Export to Excel function with Office 365

I can manually export data from the Measurement Table directly to Excel, but when I attempt to export using the following code in a macro nothing is exported.

This is the code:

with Measure.Measurements.TableCommands.SendToExcel(MyRoutine)
	.Run(newdoc)
end with

I am running Office 365, is there perhaps a compatability issue?
thanks

Best Answer

  • Answer ✓
    Nan --

    I'm glad to pass along the type of assistance that has helped me so often.

    -- Matt

Answers

  • Nan --

    I use OFFICE 365 and PREMIER seems to work well with it.

    I have worked up a small PROJECT that I believe has some information will help.

    The IPX file is attached as

        Project_Excel.ipx

    On my computer, the IPX file was created from

        "C:\Users\Matt\Desktop\Project_Excel\Project_Excel.ipp"
        "C:\Users\Matt\Desktop\Project_Excel\Module_Excel.vb"

    which also contains

        "C:\Users\Matt\Desktop\Project_Excel\marisa-lerin-polka-dots-08-template-overlay-commercial-use.tif"

    I have attached the TIF FILE also so that you can run the exact same program I have.  Put the TIF FILE in the same folder as the IPP and VB FILES and then run

        OpenImage
        FindObjects
        RecordInExcel

    You may have issues with the MACRODIR command in OpenImage because of the nature of the IPX FILE.  You can resolve this by separating out the IPP and VB FILES or by replacing the MACRODIR with the actual path to the TIF FILE

    I hope this information is helpful.

    -- Matt





  • Nan --

    Here is a SCREEN CAPTURE that shows my computer after running the three subroutines.

    I hope this information is helpful.

    -- Matt


  • Hi Matt,

    Thank you very much. I found the problem in my code. Poor logic on my part.

    Thanks for your assistance!

Sign In or Register to comment.