Go To Start > Settings > Control Panel then Choose Add / Remove Programs from Control Panel Choose File Location in the Options Box from the Above Menu Now Choose Word

Thanks.

After download, the wizard will guide you through what needs to be done. Dim wkbDest As Workbook Dim TP As Worksheet Set wkbDest = Workbooks("Table Plan for Cameron.xlsm") Set TP = Worksheets("TablePlan") wkbDest.TP.Range("A1:H24").Clear ' This is where the error 438 happens Formatting tags added Developing web applications for long lifespan (20+ years) Can two integer polynomials touch in an irrational point? Run Time Error 438 Vba Access Click Here To Download A Free Scan

Important update!

Click here to view the relaunched Ozgrid newsletter. Join Date 1st September 2010 Posts 10,911 Re: Run-Time error '438': Object Doesn't support this property or method vba Comment out the 'On Error...' statements and go to the Tools/Options menu. How to add an sObject to a sublislist? You may have to register before you can post: click the register link above to proceed.

I would suggest: 1. Microsoft Visual Basic Runtime Error 438 Excel Reply Cheryl says: May 29, 2015 at 6:23 pm Thank you! Another scenario would be misspelled method or property names, and this scenario is described in the following Microsoft Knowledge Base article: This may be as simple as adding a reference for How To Fix Runtime Error 438 Step 1 - Uninstall Microsoft Works Add-in Since this Microsoft works add in can be the problem, uninstalling it will be a logical option.

This is what seems relevant to me, especially since the access database I'm migrating from is '97 and I'm using excel 2003. Page 1 of 3 1 2 3 Last Jump to page: Results 1 to 10 of 28 Thread: Run-Time error '438': Object Doesn't support this property or method vba Thread Tools Microsoft Visual Basic Runtime Error 438 Excel 2010 How to convert a set of sequential integers into a set of unique random numbers? Excel Visual Basic Runtime Error 1004 How to cope with too slow Wi-Fi at hotel?

Are there any rules or guidelines about designing a flag? click site There are some more possibilities to occur this error is if you want to work in office latest version on windows old version computers. Rory Theory is when you know something, but it doesn’t work. Does anyone know why? Excel Vba Runtime Error 438 Combobox

Programmers combine theory and practice: nothing works and they don’t know why April 15th, 2011 #3 cytop View Profile View Forum Posts . 438 "object Doesn't Support This Property Or Method" Vba Reply Vladimir says: August 20, 2015 at 3:57 pm I did this, first close all office application then find the file C:WindowsSysWOW64fm20.dll and delete or rename, next try to open you That is Cool!

Remove all the On Error Resume Next statements.done, cheers, I'd copied the code, hadn't noticed the on error, I normally do avoid those Originally Posted by cytop Comment out the 'On

This all works, and then the formulas do with various vba's, however, the white label and the full screen settings don't work on open when opened through the other spreadsheet and I know it's probably something easy, but my brain is smoldering. Step 3 - Scan For Viruses -Â Download this virus scanner Viruses are a big problem for Windows, as they continually cause a variety of problems for your PC. Object Doesn't Support This Property Or Method Vba Access You can use this cleaner to stop viruses, errors and faults with your system.

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 The registry is basically a central database which stores vital settings and information for your system, allowing Windows to remember a huge number of details for your PC. Thank you!! More about the author I have tried searching for the solution, but I have not found it and I can't figure it out.

That person will be receiving the message which we have given above. This causes the files to become unreadable, leading Windows to be unable to process the commands you need, leading to it showing the error. Method 1 : Uninstall Microsoft Works Plugin Follow below given steps to uninstall the microsoft works plugin as this is the cause of the problem. It will occur in Word 2002 if the Microsoft Works 2001 add in is not properly configured for the new Word.

It is highly recommended to clean the windows registry files to fix various kinds of errors being generated on windows computers. Reply Karla says: February 4, 2015 at 12:58 am It really works!!! Bit of background, I am doing a task for work as told. Please use at least Office 2013 SP1.

There is an alternative method to Fix Run Time Error 438 Object Doesn't Support This Property or Method. In this case, meaning of the ‘Object Does Not Support This Property' is Microsoft works plugin does not support to proceed.