Ошибка 438 в vba excel
Люди часто предпочитают ссылаться на «Object doesn't support this property or method» как на «ошибку времени выполнения», также известную как программная ошибка. Разработчики Microsoft Corporation обычно оценивают Windows Operating System с помощью серии модулей для удаления ошибок в соответствии с отраслевыми стандартами. Как и во всем в жизни, иногда такие проблемы, как ошибка 438, упускаются из виду.
Почему происходит ошибка времени выполнения 438?
Ошибки выполнения при запуске Windows Operating System - это когда вы, скорее всего, столкнетесь с «Object doesn't support this property or method». Мы рассмотрим основные причины ошибки 438 ошибок:
Ошибка 438 Crash - Ошибка 438 может привести к полному замораживанию программы, что не позволяет вам что-либо делать. Если данный ввод недействителен или не соответствует ожидаемому формату, Windows Operating System (или OS) завершается неудачей.
Утечка памяти «Object doesn't support this property or method» - ошибка 438 приводит к постоянной утечке памяти Windows Operating System. Потребление памяти напрямую пропорционально загрузке ЦП. Потенциальным фактором ошибки является код Microsoft Corporation, так как ошибка предотвращает завершение программы.
Ошибка 438 Logic Error - Вы можете столкнуться с логической ошибкой, когда программа дает неправильные результаты, даже если пользователь указывает правильное значение. Это может произойти, когда исходный код Microsoft Corporation имеет уязвимость в отношении передачи данных.
Как правило, такие Microsoft Corporation ошибки возникают из-за повреждённых или отсутствующих файлов Object doesn't support this property or method, а иногда — в результате заражения вредоносным ПО в настоящем или прошлом, что оказало влияние на Windows Operating System. Основной способ решить эти проблемы вручную — заменить файл Microsoft Corporation новой копией. Более того, поддержание чистоты реестра и его оптимизация позволит предотвратить указание неверного пути к файлу (например Object doesn't support this property or method) и ссылок на расширения файлов. По этой причине мы рекомендуем регулярно выполнять очистку сканирования реестра.
Ошибки Object doesn't support this property or method
Object doesn't support this property or method Проблемы, связанные с Windows Operating System:
- «Ошибка в приложении: Object doesn't support this property or method»
- «Недопустимый файл Object doesn't support this property or method. «
- «Извините за неудобства - Object doesn't support this property or method имеет проблему. «
- "Файл Object doesn't support this property or method не найден."
- «Object doesn't support this property or method не может быть найден. «
- «Ошибка запуска в приложении: Object doesn't support this property or method. «
- "Файл Object doesn't support this property or method не запущен."
- "Отказ Object doesn't support this property or method."
- «Ошибка пути программного обеспечения: Object doesn't support this property or method. «
Причины проблем Object doesn't support this property or method
Заражение вредоносными программами, недопустимые записи реестра Windows Operating System или отсутствующие или поврежденные файлы Object doesn't support this property or method могут создать эти ошибки Object doesn't support this property or method.
Точнее, ошибки Object doesn't support this property or method, созданные из:
This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Answered by:
Question
I have an Office 2007 Excel workbook which has some TextBoxes on the spreadsheet and some VBA code that access the TextBox.Text property. This workbook has been working for years, and still works for me if I open it with Office 2007 Excel, but if I open it with Office 2010 Excel, a VBA error dialogbox pops up:
run-time error '438' Object doesn't support this property or method
if I click [Debug] button on the dialog, the debugger highlights a line that assigns an empty string to the TextBox:
I already deleted all the .EXD files on the computer by doing a search from the c:\ root
but the error doesn't do away when opened with Excel 2010. With Excel 2007 the workbook works and its forms work
I suspect this is caused by some Microsoft Update that changed the Office Forms somehow, and now the new version can't interpret the forms created with Office 2007 .
Please help. I'll appreciate it
Answers
Have your tried to use the tool provide in KB3025036 to fix this issue?
>> We have another pc where the same workbook does work. The curious thing is that both pc's have Windows 7 SP1, and Office 10 installed.
Do you have all of the latest updates installed on both machines?
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
- Proposed as answer by L.Hl Tuesday, February 24, 2015 8:10 AM
- Marked as answer by Fei Xue Microsoft employee Monday, March 2, 2015 1:36 PM
All replies
I still suspect that the update is the problem. What version of windows are you using? If win 7 then try the following.
Ensure you have all office programs closed. Can close any other programs that are not required but not essential.
Click the Windows colored ball bottom left of screen.
In the Search programs and files box enter the following and then press Enter.
Select all of the files and folders and then delete.
If you get a message re unable to delete any of them because of Admin permission or in use etc (and you will probably get quite a few) then just click the Skip button.
Provided you entered %temp% correctly then you won't do any harm deleting all the files that can be deleted because they are only temporary files and any that are required get re-created when you open the applications.
If using Win 8 or 8.1 then just click the magnifying glass icon (Search icon) on the main screen and type %temp% in the field that gets displayed and then press Enter (don't click the magnifying glass icon) and then as above.
I did as instructed by OssieMac, but the problem persists.
We have another pc where the same workbook does work. The curious thing is that both pc's have Windows 7 SP1, and Office 10 installed.
Any help will be appreciated. TIA
Have your tried to use the tool provide in KB3025036 to fix this issue?
>> We have another pc where the same workbook does work. The curious thing is that both pc's have Windows 7 SP1, and Office 10 installed.
Do you have all of the latest updates installed on both machines?
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
- Proposed as answer by L.Hl Tuesday, February 24, 2015 8:10 AM
- Marked as answer by Fei Xue Microsoft employee Monday, March 2, 2015 1:36 PM
I should have added to my previous post to repeat the procedure for each user id on the computer including the Administrator because it may depend on whether Office was installed via an administrator id for all users on the computer or if it was installed for a specific user.
Jeffrey was right. The old laptop had a ton of updates, but when infrastructure set up the new laptop they just installed Office 10 w/o any updates. Nobody foresaw that installing a brand new software out of the box would break an essential component, like the Office forms or VBA code. So after almost 1000 MB of updates, the VBA code started to run as expected w/o errors.
I can't understand what's going on with Microsoft: they're not supporting older versions. like XP. gone! but we're all using it. who cares. gone! Microsoft is not keeping backwards compatibility (just try to move an AnyCPU project that used to build and run in Win 32 bit, and try to build it in Win 64 bit it's DLL nightmare all over again with the dreaded "bad image format exception"). On top of all that they've broken the Office forms and VBA code with several of the updates. What's going on? Too many new people? Missing Gates? Too much Opening the Software and losing control? Having inexperienced / outside people writing code? Depending too much on 3rd party? I wasted 5 days on this! Get your act together Microsoft!
i seem to get a run-time error 438: Object doesn't support this property or Method every time i try running my macro to automatically attach a PDF file called "Statement.xlsm"
Please assist, i am new at this VBA
here is my code:
Dim objOutlook As Object
Dim objNameSpace As Object
Dim objInbox As Object
Dim objMailItem As Object
Set objOutlook = CreateObject("Outlook.Application")
Set objNameSpace = objOutlook.GetNamespace("MAPI")
Set objInbox = objNameSpace.Folders(1)
Set objMailItem = objOutlook.CreateItem(0)
'Declare a String variable for the recipient list, and an Integer variable
'for the count of cells in column A that contain email addresses.
Dim strTo As String
Dim i As Integer
strTo = ""
i = 1
'Loop through the recipient email addresses to build a continuous string that separates recipient addresses by a semicolon and a space.
With Worksheets("Statement") 'change sheet name where list is kept.
Do
strTo = strTo & .Cells(i, 25).Value & "; "
i = i + 1
Loop Until IsEmpty(.Cells(i, 25))
End With
'Remove the last two characters from the recipient string, which are
'an unnedded semicolon and space.
strTo = Mid(strTo, 1, Len(strTo) - 2)
'Display the email message with the attached active workbook.
With objMailItem
.To = strTo
.CC = "Eutychus@gcis.gov.za"
.Subject = "Media buying Statement"
.Body = _
"Hello everyone," & Chr(10) & Chr(10) & _
"Here's an example for attaching the active workbook" & Chr(10) & _
"to an email with multiple recipients."
Dim Attachment1 As String
Attachment1 = "http://ecms.gcis.gov.za/sites/docs/fin_mngmnt/47 Systems/4-7-3 Media Buying System/4-7-3-1 Media Buying Statements/Statement.xlsm.pdf"
.addAttachments Attachment1 ' (this is were is says i must debug)
.Display 'Change to Send if you want to just send it.
End With
'Release object variables from system memory.
Set objOutlook = Nothing
Set objNameSpace = Nothing
Set objInbox = Nothing
Set objMailItem = Nothing
Thank you in advance
Answers
The correct would be:
- Proposed as answer by Fei Xue Microsoft employee Thursday, January 22, 2015 3:34 AM
- Marked as answer by Fei Xue Microsoft employee Thursday, January 29, 2015 10:47 AM
All replies
i seem to get a run-time error 438: Object doesn't support this property or Method every time i try running my macro to automatically attach a PDF file called "Statement.xlsm"
Please assist, i am new at this VBA
here is my code:
Dim objOutlook As Object
Dim objNameSpace As Object
Dim objInbox As Object
Dim objMailItem As Object
Set objOutlook = CreateObject("Outlook.Application")
Set objNameSpace = objOutlook.GetNamespace("MAPI")
Set objInbox = objNameSpace.Folders(1)
Set objMailItem = objOutlook.CreateItem(0)
'Declare a String variable for the recipient list, and an Integer variable
'for the count of cells in column A that contain email addresses.
Dim strTo As String
Dim i As Integer
strTo = ""
i = 1
'Loop through the recipient email addresses to build a continuous string that separates recipient addresses by a semicolon and a space.
With Worksheets("Statement") 'change sheet name where list is kept.
Do
strTo = strTo & .Cells(i, 25).Value & "; "
i = i + 1
Loop Until IsEmpty(.Cells(i, 25))
End With
'Remove the last two characters from the recipient string, which are
'an unnedded semicolon and space.
strTo = Mid(strTo, 1, Len(strTo) - 2)
'Display the email message with the attached active workbook.
With objMailItem
.To = strTo
.CC = "Eutychus@gcis.gov.za"
.Subject = "Media buying Statement"
.Body = _
"Hello everyone," & Chr(10) & Chr(10) & _
"Here's an example for attaching the active workbook" & Chr(10) & _
"to an email with multiple recipients."
Dim Attachment1 As String
Attachment1 = "http://ecms.gcis.gov.za/sites/docs/fin_mngmnt/47 Systems/4-7-3 Media Buying System/4-7-3-1 Media Buying Statements/Statement.xlsm.pdf"
.addAttachments Attachment1 '(this is were is says i must debug)
.Display 'Change to Send if you want to just send it.
End With
'Release object variables from system memory.
Set objOutlook = Nothing
Set objNameSpace = Nothing
Set objInbox = Nothing
Set objMailItem = Nothing
I have an Office 2007 Excel workbook which has some TextBoxes on the spreadsheet and some VBA code that access the TextBox.Text property. This workbook has been working for years, and still works for me if I open it with Office 2007 Excel, but if I open it with Office 2010 Excel, a VBA error dialogbox pops up:
run-time error '438' Object doesn't support this property or method
if I click [Debug] button on the dialog, the debugger highlights a line that assigns an empty string to the TextBox:
I already deleted all the .EXD files on the computer by doing a search from the c:\ root
but the error doesn't do away when opened with Excel 2010. With Excel 2007 the workbook works and its forms work
I suspect this is caused by some Microsoft Update that changed the Office Forms somehow, and now the new version can't interpret the forms created with Office 2007 .
Please help. I'll appreciate it
Answers
Have your tried to use the tool provide in KB3025036 to fix this issue?
>> We have another pc where the same workbook does work. The curious thing is that both pc's have Windows 7 SP1, and Office 10 installed.
Do you have all of the latest updates installed on both machines?
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
- Proposed as answer by L.Hl Tuesday, February 24, 2015 8:10 AM
- Marked as answer by Fei Xue Microsoft employee Monday, March 2, 2015 1:36 PM
All replies
I still suspect that the update is the problem. What version of windows are you using? If win 7 then try the following.
Ensure you have all office programs closed. Can close any other programs that are not required but not essential.
Click the Windows colored ball bottom left of screen.
In the Search programs and files box enter the following and then press Enter.
Select all of the files and folders and then delete.
If you get a message re unable to delete any of them because of Admin permission or in use etc (and you will probably get quite a few) then just click the Skip button.
Provided you entered %temp% correctly then you won't do any harm deleting all the files that can be deleted because they are only temporary files and any that are required get re-created when you open the applications.
If using Win 8 or 8.1 then just click the magnifying glass icon (Search icon) on the main screen and type %temp% in the field that gets displayed and then press Enter (don't click the magnifying glass icon) and then as above.
I did as instructed by OssieMac, but the problem persists.
We have another pc where the same workbook does work. The curious thing is that both pc's have Windows 7 SP1, and Office 10 installed.
Any help will be appreciated. TIA
Have your tried to use the tool provide in KB3025036 to fix this issue?
>> We have another pc where the same workbook does work. The curious thing is that both pc's have Windows 7 SP1, and Office 10 installed.
Do you have all of the latest updates installed on both machines?
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
- Proposed as answer by L.Hl Tuesday, February 24, 2015 8:10 AM
- Marked as answer by Fei Xue Microsoft employee Monday, March 2, 2015 1:36 PM
I should have added to my previous post to repeat the procedure for each user id on the computer including the Administrator because it may depend on whether Office was installed via an administrator id for all users on the computer or if it was installed for a specific user.
Jeffrey was right. The old laptop had a ton of updates, but when infrastructure set up the new laptop they just installed Office 10 w/o any updates. Nobody foresaw that installing a brand new software out of the box would break an essential component, like the Office forms or VBA code. So after almost 1000 MB of updates, the VBA code started to run as expected w/o errors.
I can't understand what's going on with Microsoft: they're not supporting older versions. like XP. gone! but we're all using it. who cares. gone! Microsoft is not keeping backwards compatibility (just try to move an AnyCPU project that used to build and run in Win 32 bit, and try to build it in Win 64 bit it's DLL nightmare all over again with the dreaded "bad image format exception"). On top of all that they've broken the Office forms and VBA code with several of the updates. What's going on? Too many new people? Missing Gates? Too much Opening the Software and losing control? Having inexperienced / outside people writing code? Depending too much on 3rd party? I wasted 5 days on this! Get your act together Microsoft!
«Excel Error 438» обычно является ошибкой (ошибкой), обнаруженных во время выполнения. Разработчики программного обеспечения, такие как Microsoft Corporation, обычно принимают Microsoft Excel через несколько уровней отладки, чтобы сорвать эти ошибки перед выпуском для общественности. Ошибки, такие как ошибка 438, иногда удаляются из отчетов, оставляя проблему остается нерешенной в программном обеспечении.
Что запускает ошибку времени выполнения 438?
Сбой устройства или Microsoft Excel обычно может проявляться с «Excel Error 438» в качестве проблемы во время выполнения. Рассмотрим распространенные причины ошибок ошибки 438 во время выполнения:
Ошибка 438 Crash - Ошибка 438 остановит компьютер от выполнения обычной программной операции. Это возникает, когда Microsoft Excel не реагирует на ввод должным образом или не знает, какой вывод требуется взамен.
Утечка памяти «Excel Error 438» - ошибка 438 утечка памяти приводит к увеличению размера Microsoft Excel и используемой мощности, что приводит к низкой эффективности систем. Потенциальные триггеры могут быть «бесконечным циклом», или когда программа выполняет «цикл» или повторение снова и снова.
Error 438 Logic Error - Ошибка программной логики возникает, когда, несмотря на точный ввод от пользователя, производится неверный вывод. Он материализуется, когда исходный код Microsoft Corporation ошибочен из-за неисправного дизайна.
Microsoft Corporation проблемы файла Excel Error 438 в большинстве случаев связаны с повреждением, отсутствием или заражением файлов Microsoft Excel. Как правило, самый лучший и простой способ устранения ошибок, связанных с файлами Microsoft Corporation, является замена файлов. Запуск сканирования реестра после замены файла, из-за которого возникает проблема, позволит очистить все недействительные файлы Excel Error 438, расширения файлов или другие ссылки на файлы, которые могли быть повреждены в результате заражения вредоносным ПО.
Типичные ошибки Excel Error 438
Типичные ошибки Excel Error 438, возникающие в Microsoft Excel для Windows:
- "Ошибка приложения Excel Error 438."
- "Excel Error 438 не является приложением Win32."
- «Извините, Excel Error 438 столкнулся с проблемой. «
- «Excel Error 438 не может быть найден. «
- "Excel Error 438 не найден."
- "Ошибка запуска программы: Excel Error 438."
- «Excel Error 438 не работает. «
- «Excel Error 438 остановлен. «
- «Неверный путь к программе: Excel Error 438. «
Корень проблем Excel Error 438
Проблемы Excel Error 438 могут быть отнесены к поврежденным или отсутствующим файлам, содержащим ошибки записям реестра, связанным с Excel Error 438, или к вирусам / вредоносному ПО.
Читайте также: