File Save Dialog gives RunTime Error 445

File Save Dialog gives RunTime Error 445

Post by V2luc3Rvbi » Thu, 01 Apr 2004 08:21:08


When I use the following code
Private Sub cmdFileDialog_Click(
Dim FileDialog As Office.FileDialo
' Set FileDialog = Application.FileDialog(DialogType:=msoFileDialogSaveAs
Set FileDialog = Application.FileDialog(DialogType:=msoFileDialogFilePicker
FileDialog.Sho
With FileDialo
.Filters.Clea
.Filters.Add "Excel Files", "*.xls
End Wit
End Su

It works like a charm with the msoFileDialogFilePicker but gives run time error 445 "Object doesn't support this action" for the commented out msoFileDialogSaveA
And yet, VBA shows it as a prompt option. All I want to do is be able to save a file

Any ideas? I have installed the MS Office Object 10.0 Runtime Library as a referenc

Thanks
Winsto
 
 
 

1. Getting Run-time error '445'

2. Error 67 on port 445 connection attempt

Hi!

I have the following problem on just one computer (Windows XP SP3):

net use * \\<ip>\<share> /u:<user> <pass>

produces "Error 67 - Network path not found". Works ok on all other computers.

It seems that SMB is not served on port 445, i.e.

netstat -an

on the "bad" computer shows no activity on port 445 ("UDP 0.0.0.0:445 *:*", or
"TCP 0.0.0.0:445 0.0.0.0.:0" rsp. don't even show up).

The mapping - for security reasons - has to be made via CIFS (DMZ, Firewall).

Actions so far:

1) Reinstalled TCP/IP
2) Checked HKLM\System\CurrentControlSet\Services\NetBT\Parameters\TransportBindName
=> value is correct with "\Device\"
3) Checked settings under WINS tab => CIFS is allowed (NetbiosOptions = 0)
4) Client for Microsoft Network is installed and running (even reinstalled them)
5) File and Print Services are installed and running (even reinstalled them)
6) No errors in the event log.

Any ideas?

Axel

3. there is an error in xml document (1_ 445).;hash='1505820932'

4. [PHP] not parsing php files, giving us a save dialog.....

5. Sharepoint - RMS : modifying rights on documents gives "save as" dialog box when saving

6. VB6 works fine on XP but not Vista - Error 445

7. Vista VPN Host TCP Port 445 error

8. not parsing php files, giving us a save dialog.....

9. run time error 445 - Object doesn't support this action

10. Netopia 3500-LinkSys-Port 135 and 445 in Log Files??

11. Visual C++ Runtime Library Runtime Error dialog box - prevent it?

12. Visual C++ Runtime Library Runtime Error dialog box - prevent

13. Append from "Excel File" TYPE XL8 give 1661 error if file saved from Excel 2007

14. MM-Exporter gives Runtime 5 error; Cannot open or back up DW files

15. Which function displays this save dialog or how is this save dialog called?