Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I can't get the Execut method to work.
I have this code: Sub SaveAsDialog() 'Other workbook then this should be active Dim fd As FileDialog On Error GoTo OnError Set fd = Application.FileDialog(msoFileDialogSaveAs) With fd .AllowMultiSelect = False .InitialFileName = ActiveWorkbook.Name If .Show = -1 Then .Execute End If End With Exit Sub OnError: Debug.Print "Errnumber: " & Err.Number & " " & "ErrDesc: " & Err.Description End Sub 'I get this: 'Errnumber: -2147467259 ErrDesc: Method 'Execute' of object 'FileDialog' failed Eaven if I just save as C:\MyFile.xls the error ocurres, so the problem is not write protection or similar error. Please Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |