Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to export QV report to ppt using macro it is working fine with QV desktop
but it is not working in web mode (access point).
I do have IE plugin installed.
Is there any way I can do it on access point, or any alternative tool/plugin?
Thanks in Advance.
I am not sure, but I think unsafe macro checkbox only applies to Ajax macros.
Add two msgboxes. If you only see the first one, there is a problem with creating the powerpoint object.
sub exportppt
Msgbox "Before CreateObject"
Set objPPT = CreateObject("PowerPoint.Application")
Msgbox "After CreateObject"
objPPT.Visible = True
Set objPresentation = objPPT.Presentations.Add
Set PPSlide = objPresentation.Slides.Add(1,11)
ActiveDocument.ActiveSheet.CopyBitmapToClipboard
PPSlide.Shapes.Paste
Set PPSlide = Nothing
Set PPPres = Nothing
Set PPApp = Nothing
End Sub