data not exporting to excel

Hi

We are running a series of measures, normally we are able to export to excel. For some reason this is not happening, even shutting down the program and restarting the application did not help. Please advise

Best Answers

  • Accepted Answer
    Thank you Yuri,

    I ran this macro and restarted office 365. The data is now exporting into excel.

  • Accepted Answer
    Thank you, YuriG,
    I ran the macro and rebooted office 365. The data is exporting into excel as expected.

Answers

  • Image-Pro automatically detects Excel and if it's available, can send data. 
    Do you have Excel on your computer? What version?
    Did it work before?
    What table are you trying to export?
    Are you able to save table to XLS file?

    Yuri
  • Yes, I have excel and it was working fine a couple of days ago. I am using office 365, we can copy and paste the data but we were able to forward the measures from the data table.


  • Can you please run the 2 macros below, so we can see where the problem is?

        Public Sub ExportExcelCommandTest
            Dim c As MediaCy.Commands.Export.ExportToExcel
            c = New MediaCy.Commands.Export.ExportToExcel
            c.Run("Line 1", "Line 2")
        End Sub
    
        Public Sub HelloExcel
            Dim xlApp As Microsoft.Office.Interop.Excel.Application = CreateObject("Excel.Application")
            If xlApp Is Nothing Then Exit Sub' no excel
            With xlApp
                .Visible = True
                .Workbooks.Add.Activate
                .ActiveCell.Value="Hello!!!"
            End With 

    Please let us know which macro starts Excel and places some text in Sheet1.

    Thanks,

    Yuri


  • Error message
  • I don't see the left part of the macro, so it could be a problem with copy/paste.

    Please try the attached macro project, that has these 2 functions.

    Yuri

Sign In or Register to comment.