Excel 2003 Vba Runtime Error 438
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
Run Time Error 438 Excel 2003
policies of this site About Us Learn more about Stack Overflow the excel vba runtime error 438 combobox company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags excel vba runtime error 438 object doesn't support Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only
Excel Vba Runtime Error 438 Object Doesn't Support This Property Or Method
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 code is : Sub MACRO() bAlerts = Application.DisplayAlerts Application.DisplayAlerts =
Run Time Error 438 Vba Excel 2010
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 as follows: Sub MACRO() bAlerts = Application.DisplayAlerts Application.DisplayAlerts = False For i = 1 To Worksheets.Count Worksheets(i).Cells.Replace What:="C:\", Replacement:="C:\Gestion\" Next Application.Di
here for a quick overview of the site Help vba runtime error 438 object doesn't support this property or method Center Detailed answers to any questions you might have Meta
Run Time Error 438 Excel Macro
Discuss the workings and policies of this site About Us Learn more about Stack run time error 438 vba access Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question http://stackoverflow.com/questions/21902577/run-time-error-438-object-doesnt-support-this-property-or-method x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Excel VBA: Run-time error '438' Object doesn't support this property or method up vote 1 down http://stackoverflow.com/questions/25572021/excel-vba-run-time-error-438-object-doesnt-support-this-property-or-method vote favorite 1 Please help debug: Run-time error '438' Object doesn't support this property or method I'm not sure why my the Function ConvertToStdDateFormat(InputRange As Range) is not accepting the range 'ThisRange' Here's what my input looks like 201301 201401 201301 201401 201302 201402 201302 201402 201303 201403 201303 201403 201304 201404 201304 201404 201305 201405 201305 201405 Below is the code Sub trythis() Dim ThisRange As Range Dim MonthYear_array As Variant start_date_row = 1 end_date_row = 12 With ActiveSheet Set ThisRange = .Range(Cells(start_date_row, 1), Cells(end_date_row, 2)) MonthYear_array = .Range(Cells(start_date_row, 4), Cells(end_date_row, 5)).Value End With Call ConvertToStdDateFormat(ActiveSheet.Range(Cells(start_date_row,1), Cells(end_date_row, 2))) Call ConvertToStdDateFormat(ActiveSheet.ThisRange) End Sub Public Function GetMonthYearFormatted(InputDate) 'InputDate should be in the format "201401" i.e. year(2014)month(01) IPString = CStr(InputDate) monthval = CInt(Right(IPString, 2)) yearval = CInt(Left(IPString, 4)) opDate = DateSerial(yearval, monthval, 1) OPFormatDate = Month(opDate) & "-" & Year(opDate) GetMonthYearFormatted = OPForm
VBA Code & Other Help Excel Help run time error '438' - Object 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 you can post: click the register link http://www.vbaexpress.com/forum/showthread.php?34908-run-time-error-438-Object-doesn-t-support-this-property-or-method above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: run time error '438' - Object doesn't support this property or method Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-09-2010,03:58 PM #1 Hathman View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Sep 2010 Posts 14 Location error 438 run time error '438' - Object doesn't support this property or method Hi all, I have what looks like a compatibility problem between Excel 2003 and Excel 2007. The gist of it is that I spawn data from MS Access to MS Excel and kick off an Excel macro to do a LOT of formatting. When my users have Excel 2003 it halts the formatting macro and gives them the run time error '438' - object doesn't support this property time error 438 or method. If my users have Excel 2007 then it completes successfully. Where the code halts is random so I can't seem to glean any knowledge from the location it fails. I'm sure this has to do with my vba references and the fact that I need to assign different ones for different versions of Excel. How do i figure this out? I tried to take a copy of the excel spreadsheet, assign Excel 2003 (Excel 11.0) references and run that but it still failed. Maybe it's something else? Here are the references I currently have: Visual basic for applicationsMicrosoft Excel 12.0 Object Library (I tried replacing with 11.0)OLE automationMicrosoft Office 12.0 Object Library (I tried replacing with 11.0)Any ideas? Reply With Quote 11-09-2010,04:34 PM #2 xld View Profile View Forum Posts View Blog Entries View Articles Distinguished Lord of VBAX VBAX Grand Master Joined Apr 2005 Posts 24,522 Location You would need to show the code for us to make any headway on this. ____________________________________________ Nihil simul inventum est et perfectum Abusus non tollit usum Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen! James Thurber Reply With Quote 11-11-2010,05:58 AM #3 Hathman View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Sep 2010 Posts 14 Location Sure thing. I didn't post this originally because it's lengthy and the crash rarely occu