• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

Error exporting Slides from PowerPoint using VB.net

For some reason PowerPoint has started crashing with the following code but has been working for over a year. Any ideas?
Dim DestFile As String = "c:\temp\"
 
        If Not IO.Directory.Exists(DestFile) Then
            IO.Directory.CreateDirectory(DestFile)
        End If
 
 
        Dim objApp As New PowerPointMe.Application
 
 
 
        objApp.Visible = MsoTriState.msoTrue
        objApp.Presentations.Open(FileStr, MsoTriState.msoFalse, MsoTriState.msoCTrue, MsoTriState.msoCTrue)
        objApp.Assistant.On = False
 
        objApp.Presentations(1).SaveAs(DestFile & "Benefit_" & BenefitID & ".bmp", Microsoft.Office.Interop.PowerPoint.PpSaveAsFileType.ppSaveAsBMP, MsoTriState.msoCTrue)
 
        Dim PresentationByte() As Byte = Nothing
        Dim FileArray(objApp.Presentations(1).Slides.Count - 1) As Object
        Dim i As Integer = 1
 
        For i = 1 To objApp.Presentations(1).Slides.Count
            Dim SlideFileStr As String = DestFile & "Benefit_" & BenefitID & "\Slide" & i & ".bmp"
 
            Dim FS As IO.FileStream = IO.File.Open(SlideFileStr, IO.FileMode.Open)
            ReDim PresentationByte(FS.Length - 1)
            FS.Read(PresentationByte, 0, FS.Length - 1)
 
            FS.Close()
 
            'Save File into array, the array will be saved to the db and pulled back out on the client
            FileArray(i - 1) = PresentationByte
 
        Next
 
        Try
            objApp.ActiveWindow.Close()
        Catch
 
        End Try
        Try
            If objApp.Presentations.Count > 0 Then
                objApp.Presentations(1).Close()
            End If
        Catch ex As Exception
            If Debugger.IsAttached Then Stop
        End Try
        Try
            objApp.Quit()
        Catch ex As Exception
            If Debugger.IsAttached Then Stop
        End Try
 
 
        GC.Collect()
 
        Return ConvertObjectToBytes(FileArray)

Open in new window

0
jmarbutt
Asked:
jmarbutt
  • 4
2 Solutions
 
GlennaShawCommented:
Did you upgrade to 2007?
I'm not that good with VB, so I suggest you'll get a quicker answer here:
https://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.powerpoint&lang=en&cr=US
However, make sure you specify which version of PowerPoint you're using and exactly what you're trying to do (are you exporting the images into a database?)
0
 
Chris BottomleyCommented:
I'm not that aware of .net but as Glenna pointed out a change in version could explain teh sudden change.

Which line is failing and with what error code ... we may be able to rationalise it out.

Chris
0
 
jmarbuttAuthor Commented:
Yes it is 2007 but we have been using it a while with out a problem.

It is throwing an error in the when we start to exit the function, it is almost like it doesn't want to let go of the reference and/or the GC is not disposing it correctly.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
jmarbuttAuthor Commented:
The error I get is:


ContextSwitchDeadlock was detected
Message: The CLR has been unable to transition from COM context 0x1bc5bbd0 to COM context 0x1bc5be20 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.

Open in new window

0
 
jmarbuttAuthor Commented:
This actually ended up being something completely different. Thanks for your help, I still rewarded the points
0
 
jmarbuttAuthor Commented:
There was another section of my code that was actually throwing the problem, basically the SQL command was timing out only on certain powerpoints. So not even a valid question
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now