Office VBA - Powerpoint + Sharepoint

F

frank387

Hello,
I wrote a vba macro to help my users to save office documents (word, excel
and powerpoint) to windows sharepoint document libraries.

The macro shows the "save as" filedialog with a InitialFileName as my
sharepoint url.

It works fine with word and excel, but I have a problem in powerpoint with
document libraries with mandory fields (without mandory fields, the
presentation will be saved)

When I save a document in excel or word in a document library with mandory
fields, then a popup windows (webdialog) appears with my mandory fields to
input.

When I save a powerpoint presentation in a document library with mandory
fields,
the popup windows doesn't appear and the presentation will not save.

There is no error message in my vba code

vba code
========
Dim dlgSaveAs As FileDialog
Dim strPath As String

Set Pres = ActivePresentation
Set dlgSaveAs = Pres.Application.FileDialog(msoFileDialogSaveAs)

With dlgSaveAs
.InitialFileName = "http://SERVERNAME/SHAREPOINT_SITE/"
.Show
.Execute

End With


Is there an alternativ methode.

Best regards

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top