LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 683
Default Run-Time Error '424': Object required when Saving Document

When I try to save a Document from a User Form Control Button I get the
following Error. It happens when you go to save the Document and hit Cancel.
If you save the Document it works perfect, but not when you Cancel it.

What I want to happen is the Message Pops Up. What did I do wrong & how do I
fix it?

Run-Time Error '424': Object required

' Save Engineering Spec 11 Control Button

Private Sub Save_Engineering_Spec_11_Click()

Dim strFile As String

strFile = "SPEC " & TEO_No_1.Value _
& Space(1) & CLLI_Code_1.Value _
& Space(1) & CES_No_1.Value _
& Space(1) & TEO_Appx_No_2.Value

bk.SaveAs Filename:=Application.GetSaveAsFilename(strFile) (Error
Message)

If FileToSave = False Then

MsgBox "The Close Method Failed, No Document Saved", , "C.E.S."

Exit Sub

End If

End Sub

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Object required Run-time error '424' Ayo Excel Programming 4 August 25th 09 05:36 PM
Run-time error '424': Object Required Doug Excel Programming 2 May 27th 09 11:56 PM
Run-time error '424': Object Required loren.pottinger Excel Programming 7 August 29th 06 03:16 PM
Run time error '424' object required Meltad Excel Programming 8 August 10th 06 09:34 AM
Run-time error '424': Object required Phil Bewig Excel Programming 3 February 1st 04 08:38 PM


All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"