I am having problems with running Macros in 2003 and 2007 formats.

I am having problems with running Macros in 2003 and 2007 formats.
I have created a new workbook and saved it as 97/2003 format and created the macro using the Record Macro tool.
This runs fine from 2007 but if I try and run it in 2003 I get an error at the following point in the VB.
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False.
if I change it to
Selection.QueryTable.Refresh BackgroundQuery:=False
it will then run.
I have found some code to detect which version of Excel it is running but I have a lot of spreadsheet with many macros in.
Is there some code that can be used on opening the file to then run the macros correctly, or are we doing something wrong?
 
Would appreciate your expert guidance.

Anwsers to the Problem I am having problems with running Macros in 2003 and 2007 formats.

Download SmartPCFixer for Free Now

I you need to write code that needs to run in multiple versions, it's best to develop and test the code in the oldest version that you need to support.
That way you won't use features that were introduced in a later version (such as ListObject).
 
Also, references to code libraries other than the standard ones will generally be converted automatically if you open the workbook in a newer version than the one it was created in, but not always if you open it in an older version.

Because of this I am having problems with running Macros in 2003 and 2007 formats. error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error I am having problems with running Macros in 2003 and 2007 formats. can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve I am having problems with running Macros in 2003 and 2007 formats. error or repair the corrupted and damaged Windows files, you will need a I am having problems with running Macros in 2003 and 2007 formats. error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

1. Start the computer and log in as administrator
2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
4. On the new confirmation window that appears, click Next
5. Restart your computer after the restoration has been completed

Recommended Method to Fix the Problem: I am having problems with running Macros in 2003 and 2007 formats.:

 

 

How to Fix I am having problems with running Macros in 2003 and 2007 formats. with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Run it, and it will scan your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.

Related: accelerometerst exe hp download Icsetup ExeComputer Error Svchost Exe Svchost Exe System Error ERROR CANNOT EXECUTE FILE IN TRANSACTION Free Ntoskrnl Exe For Windows7 Download Explorer Exe Error On Shut Down Windows Search Exe Bad Image Hphmon exe Msnnm exe InboxTool Scanpst Exe ntoskrnl exe bsod keygen exe updater exe Odometer exe firefox exe entry point not found Sqlmangr exe Download Regtlib exe unwise exe Driver For Hpoipm07 exe Wmp54gv4 exe Download sndvol exe,Blue Screen error BCCode d1 Windows 7 64 bit Pro realtek hd audio drivers High memory usage on Windows Explorer realtek hd audio driver Is there a way to have pages be normal size ie cover the entire screen when viewing on Windows 7 realtek sound drivers Right Click Libraries Windows explorer has stopped working realtek drivers windows 7 Start Menu Windows Explorer has Stopped Working Realtek Audio Drivers Windows XP Windows 7 Professional cannot find my External Drive realtek high definition audio driver Windows won t maximize from task bar and won t show preview realtek high definition audio driver nVidia Graphics Driver Version V9.18.13.3349 , 379.77 MBytes
Read More: [Solved] External storage usage possible with Office Live?,[Solution] lost bluetooth, webcam, and possibly other items,How to Fix Problem - Backup and restore from an external hard disk?,[Solved] How to plot a concetric circles Chart in excel 2007?,Troubleshooting:windows experience index of gaming graphics is 3.4 Error,Network Key help,why its says expe win 32 application not valid,why can't I go to another computer to see my msn portfolio,What is ESENT, and what do I do about this ESENT Error occurring once on Win7(64)SP1?:,I made XMAS address labels last year and now I just want to have the addresses on the labels wiith no clip art. How do I do it without retyping 4 pages of addresses?