Compatability of Export to Excel function with Office 365

Nan

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

mbatchelor

Nan --

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

-- Matt

mbatchelor

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

mbatchelor

Nan --

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

I hope this information is helpful.

-- Matt

Nan

Hi Matt,

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

Thanks for your assistance!