Object Creation Error 424 Object Required
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 22 Oct 2016 06:42:08 GMT by s_wx1157 (squid/3.5.20)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about
Compile Error Object Required Vba
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask run time error 424 object required vba access Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. runtime error 424 object required vba access 2010 Join them; it only takes a minute: Sign up Run-Time Error '424': Object Required on attempting to change definition of object, Excel VBA up vote 0 down vote favorite As it stands now I have it written up where http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/error-424-object-required/17ae8fce-a457-4bd3-bf0d-f3ae77d2bbb3 the code creates a file in the folder that the original file exists in. Once the file is created, I want to have it where wbBK2 is defined as the file that was just created. I figured using the same code to create the file, minus the SaveAs option would work, but it seems that it doesn't like the object. Is there a reason why? For all intended purposes it should be pointing directly at the file, but it http://stackoverflow.com/questions/12281225/run-time-error-424-object-required-on-attempting-to-change-definition-of-obje seems to not agree... can someone see the mistake I've made? Option Explicit Sub OpenOrderReportExport() Dim wsJL As Worksheet 'Jobs List Dim wsPOT As Worksheet 'PO Tracking Dim wsTNO As Worksheet 'Tel-Nexx OOR Dim wbBK2 As Workbook 'New Workbook Dim wsWS1 As Worksheet 'Sheet1 Dim wsWS2 As Worksheet 'Sheet2 Dim wsWS3 As Worksheet 'Sheet3 Dim CurrentFile As String, NewFileType As String, NewFile As String, Dir As String Set wsJL = Sheets("Jobs List") 'Jobs List Set wsPOT = Sheets("PO Tracking") 'PO Tracking Set wsTNO = Sheets("Tel-Nexx OOR") 'Tel-Nexx OOR Set wbBK2 = Workbooks.Add 'New Workbook Set wsWS1 = wbBK2.Sheets("Sheet1") 'Sheet1 Set wsWS2 = wbBK2.Sheets("Sheet2") 'Sheet2 Set wsWS3 = wbBK2.Sheets("Sheet3") 'Sheet3 Application.ScreenUpdating = False ' Prevents screen refreshing. CurrentFile = ThisWorkbook.FullName NewFileType = "Excel Files 2007 (*.xlsx)" Dir = ThisWorkbook.path wbBK2.SaveAs Dir & Application.PathSeparator & "Open Order Report -" & Format(Date, "mm-dd-yyyy") & ".xlsx" Set wbBK2 = Dir & Application.PathSeparator & "Open Order Report -" & Format(Date, "mm-dd-yyyy") & ".xlsx" MsgBox wbBK2 End Sub excel excel-vba share|improve this question asked Sep 5 '12 at 12:16 Matt Ridge 1,209113252 1 You don't need the line Set wbBK2 = Dir..... It is already set. Comment that line and change MsgBox wbBK2 to MsgBox wbBK2.Name to check. –Siddharth Rout Sep 5 '12 at 12:19 Seriously? I hate overanalyzing things like this... thanks. –Matt Ridge Sep 5 '12 at 12:22 You have already s
Questions Technical Articles Product Updates Knowledge Base Documentation Support Request Download SocketTools .NET Edition SocketTools ActiveX Edition SocketTools Library Edition SocketTools Subscription Company About Us Partners https://sockettools.com/kb/runtime-error-424-object-required/ Resellers Customers Contact Us Purchase Order Products Order Support Product Pricing Upgrade Pricing Academic Pricing Refund Policy Account 0 No products in the cart. Products SocketTools .NET Edition SocketTools ActiveX Edition SocketTools Library Edition SocketTools Subscription Customer Reviews Download Free Trial Support Support Options Frequently Asked Questions Technical Articles Product Updates Knowledge Base Documentation object required Support Request Download SocketTools .NET Edition SocketTools ActiveX Edition SocketTools Library Edition SocketTools Subscription Company About Us Partners Resellers Customers Contact Us Purchase Order Products Order Support Product Pricing Upgrade Pricing Academic Pricing Refund Policy Account Runtime Error 424 Object Required September 3, 2014 Comments Closed When executing a program that was created using error 424 object Visual Basic 6.0 and a SocketTools ActiveX control, the following error is returned: Run-time error 424: Object required. This error can occur if the control is not properly registered on the local system, or if the object has not been referenced correctly. More Information If the ActiveX control is being created dynamically using CreateObject, you must use the Set statement to assign the object reference to a variable. If the object variable has been declared as a Variant, an error will not necessarily be returned if you assign it to the return value of a CreateObject call, however error 424 will be generated whenever the application attempts to reference the object. Check to make sure that the control is installed on the system and register it using the regsvr32.exe utility. This utility should be run from the command line, and on Windows Vista or later versions you must open the command prompt with Administrative privileges. To determine the correct filename for the control that you a