Microsoft Visual Basic Runtime Error 438
Contents |
360 games PC games microsoft visual basic runtime error 438 excel Windows games Windows phone games Entertainment All Entertainment run time error 438 access vba Movies & TV Music Business & Education Business Students & educators run time error 438 vba excel 2010 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet 438 object doesn't support this property or method vba Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All
Error 438 Object Doesn't Support Vba
Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
doesn't support this property or method If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before
Microsoft Visual Basic Runtime Error 438 Excel 2010
you can post: click the register link above to proceed. To start run time error 438 word viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of run time error 438 excel mac 3 Thread: [RESOLVED] Runtime error 438 Object doesn't support this property or method Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to https://support.microsoft.com/en-us/kb/175616 Threaded Mode Mar 30th, 2007,04:42 AM #1 marktheman View Profile View Forum Posts Thread Starter Lively Member Join Date Feb 2007 Location Dublin, Ireland Posts 120 [RESOLVED] Runtime error 438 Object doesn't support this property or method Hi, I'm doing a simple excel project and part of it is updating fields in a table. Say the recordset has 500 entries. For some entries, when http://www.vbforums.com/showthread.php?460591-RESOLVED-Runtime-error-438-Object-doesn-t-support-this-property-or-method I update I have no issue but when I update older entries from an access database, I get the following error. "Runtime error 438 Object doesn't support this property or method". I'm using ADO connectivity and excel as a database Example: Code: rs.Open "SELECT * FROM [tblfissection$] Where RequestNo = " & requestNoSubstringed, conn, adOpenStatic, adLockOptimistic, adCmdText On Error GoTo updateFISTable 'rs.Fields(1) = "" 'rs.Fields(2) = DTEvaluationDate.Value rs.Fields(3) = TextProposedSolOutline.Text Any ideas Reply With Quote Mar 30th, 2007,08:44 AM #2 sparbag View Profile View Forum Posts Hyperactive Member Join Date May 2006 Posts 361 Re: Runtime error 438 Object doesn't support this property or method Hello, From Microsoft website: Run Time Error 438 - Object Doesn't Support this Property or Method The most common cause of error 438 is not maintaining binary compatibility between successive versions of your components. Each COM interface has an associated GUID that is called an interface ID (IID). Each coclass has an associated GUID that is called class ID (CLSID). When you compile an ActiveX component in Visual Basic, the CLSIDs and IIDs are compiled into the component's type library. Example A program tha
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta http://stackoverflow.com/questions/21902577/run-time-error-438-object-doesnt-support-this-property-or-method Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping error 438 each other. Join them; it only takes a minute: Sign up Run-time error '438' Object doesn't support this property or method up vote 0 down vote favorite I have a macro with VBA, but my program fail. The Visual Basic Application show me this missatge : "Run-time error '438' Object doesn't support this property or method" My time error 438 code is : Sub MACRO() bAlerts = Application.DisplayAlerts Application.DisplayAlerts = False For i = 1 To Sheets.Count ***Sheets(i).Cells.Replace What:="C:\", Replacement:="C:\Gestion\"*** Next Application.DisplayAlerts = bAlerts End Sub In the line Sheets(i).Cells.Replace What:="C:\", Replacement:="C:\Gestion\", my program doesn't work. What is the problem ? My excel file it has the Microsoft Excel 97-2003 Format. Finally, I could fix this. My new code is : Attribute VB_Name = "RemplazoString" Sub MACRO() Dim Sht As Worksheet bAlerts = Application.DisplayAlerts Application.DisplayAlerts = False For Each Sht In Worksheets Sht.Cells.Replace What:="C:\", Replacement:="C:\Gestion\", LookAt:=xlPart, MatchCase:=False Next Application.DisplayAlerts = bAlerts End Sub Thanks! excel vba share|improve this question edited Feb 20 '14 at 9:02 asked Feb 20 '14 at 8:49 Mr.Beto 5029 do you have Chart sheets? –simoco Feb 20 '14 at 8:51 Yes, I find my error! Does it! Thank you! –Mr.Beto Feb 20 '14 at 9:07 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted It seems that you have chart sheets. Try to change your code a