Help!

VBA - FileDialog SaveAs

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  how do I generate a "movie" background ..  
Author Message
frank387
External


Since: Jun 21, 2006
Posts: 1



PostPosted: Thu Jun 22, 2006 2:56 am    Post subject: VBA - FileDialog SaveAs
Archived from groups: microsoft>public>powerpoint (more info?)

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
Back to top
Vincnet.
External


Since: Jun 22, 2006
Posts: 9



PostPosted: Thu Jun 22, 2006 9:25 am    Post subject: RE: VBA - FileDialog SaveAs [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hello,
I'm sorry I have no answer for you...
I have written such macros to help users to save their documents (worf and
excel so far) under a standardised name. In Excel and Word, it works
perfectly, and the macro are run when the user uses the Ctrl+s shortcut.
Within Powerpoint, I haven't figured out - yet - how to link a shortcut and
a macro (add-in or not). If you have any idea to do such a thing, please let
me know.
Thanks...

Regards,

--
CU

V.


"frank387" wrote:

> 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
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum