DKS
12/20/2006 12:34:00 PM
Charles,
Here is the error message (for the second part of my posting)
Run-time error -'2147467259 (80004005)':
Method 'Execute' of object 'FileDialog' failed
If you know how to solve this error then that will be greatly appreciated.
Thanks for the reply to the first part of my posting.
"Charles Chickering" wrote:
> Trap the cancel on the .Show method:
> If Not .Show Then
> 'User Clicked Cancel
> Exit Sub
> Else
> 'User Clicked Save
> End If
>
>
> For the second question I do need the error information.
> --
> Charles Chickering
>
> "A good example is twice the value of good advice."
>
>
> "DKS" wrote:
>
> > I have two questions on the usage of msoFileDialogSaveAs:
> >
> > (a) in the following code
> > With Application.FileDialog(msoFileDialogSaveAs)
> > .Show
> > .Execute
> > End With
> >
> > when the .execute method is run, a dialog box is saved where one can browse
> > to a folder and save the file. Nevertheless, the dialog box provides a
> > CANCEL option also. How do I trap programatically if the user clicks on
> > CANCEL button?
> >
> > (b) second question
> >
> > My .xls with a macro using the msoFileDialogSaveAs gives an error when run
> > from the PC of my friends and colleagues. The error is on the .execute
> > method where excel gives an error that the method cannot be applied (or does
> > not exist - I forgot the actual error message but can find out if somebody
> > out there needs to know the exact error message).
> >
> > Any idea why this method works on my PC and not on other's PC with exactly
> > same configuration (XP, Excel 2003). I thought that this could have to do
> > something with Add-ins. I removed all add-ins from my PC (by simply
> > deselecting add-ins via TOOLS, ADD-IN ...). After deselecting all add-ins I
> > re-ran the macro on my PC and it works fine. Thus it cannot be add-in (or so
> > I believe).
> >
> > All help appreciated.