Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Can't remove '.XLA ' file from Excel (VBA) project.

Posted on 1998-10-01
14
2,975 Views
Last Modified: 2010-07-27
There is a file called 'XLQUERY.XLA' placed in my VisualBasic for Applications (Excel) project. How can I remove this file? It is protected with a password.
"The file is a sort of convertor for Excel 5.0 or so."

I can remove it in one way (menu ~Tools~Add-Inss and then the checkbox), after it is gone I save the project, but the
XLQUERY.XLA file comes back the next time I load the project.XLS file again.

I WANT THIS FILE OUT OF MY PROJECT!

Thanxs,

Ron Lagerwaard <<e-mail deleted>>
0
Comment
Question by:rlagerwaard
  • 8
  • 2
  • 2
  • +2
14 Comments
 

Author Comment

by:rlagerwaard
ID: 1613847
Edited text of question
0
 
LVL 3

Expert Comment

by:arnond
ID: 1613848
try this:
after removing the file from the project and saving it, close Excel and open the windows explorer (if you're using windows 9x), go to the directory where 'XLQUERY.XLA' and rename it or delete it altogether (if you don't need it at all).
P.S.: what version of Excel are you using ? can you send me your .xls file ?
0
 

Author Comment

by:rlagerwaard
ID: 1613849
Thanxs Arnold, but it didn't help me...
If you give me your email adress I send you the XLS-file and some extra information.

Greetings,
Ron
rla@mediasys.nl
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 3

Accepted Solution

by:
frazer earned 100 total points
ID: 1613850
Hi,

Addins are linked to excel itself not individual projects or spreadsheets.  remove it by going to tools, addins, then uncheck  MS Query Add-in for Excel 5 Compatability.
Close excel.
When you open next time it should be gone.
If it is still there check any auto open sub routines to see if it automatically starts the xla, if so delete the relevant lines.

Hope this hellps

Frazer
0
 

Author Comment

by:rlagerwaard
ID: 1613851
'If it is still there check any auto open sub routines to see if it automatically starts the xla, if so delete the relevant lines.'

How and where can I remove this lines?

Ron
0
 
LVL 3

Expert Comment

by:arnond
ID: 1613852
my e-mail is :
<<e-mail deleted>>
hope I can help...
0
 

Author Comment

by:rlagerwaard
ID: 1613853
Hello Frazer,

I hope you can tell me how to remove the auto open sub routines that automatically starts the xla, because the xla stay's in my project.

Thanxs,

Ron
0
 
LVL 3

Expert Comment

by:frazer
ID: 1613854
Hi,

OPen excel then press Alt+F11, this will open the VBA editor.  Look in the project explorer for any modules.  If there are any open themby double clicking on them and look for a line that looks like....

Sub Auto_Open

If this exists check for a line that contains....

XLQUERY.XLA

If you find it either comment out the line or delete it altogether.

Failing this I would suggest a reinstall of office

Hope this helps

Frazer
0
 

Author Comment

by:rlagerwaard
ID: 1613855
Reinstall will not work, because the problem is in my XLS file . If I start Excel there is no XLQUERY.XLA at all. After opening my XLA file it auto opens the XLQUERY.XLA. I can see the auto open commando if looking with a editor in the XLS file.

p.s. the problem is not in my modules (code).

Ron.

0
 

Author Comment

by:rlagerwaard
ID: 1613856
Reinstall will not work, because the problem is in my XLS file . If I start Excel there is no XLQUERY.XLA at all. After opening my XLA file it auto opens the XLQUERY.XLA. I can see the auto open commando if looking with a editor in the XLS file.

p.s. the problem is not in my modules (code).

Ron.

0
 

Author Comment

by:rlagerwaard
ID: 1613857
Reinstall will not work, because the problem is in my XLS file . If I start Excel there is no XLQUERY.XLA at all. After opening my XLA file it auto opens the XLQUERY.XLA. I can see the auto open commando if looking with a editor in the XLS file.

p.s. the problem is not in my modules (code).

Ron.

0
 

Expert Comment

by:rauchs
ID: 1613858
instead of using the addins function in Excel. Try going to Tools > references and deselecting the XLQuery as a reference to your project. This should remove the XLQuery from your Project.

Bear in Mind that when a file is referenced in Excel VBA, Excel actually opens it.
0
 

Author Comment

by:rlagerwaard
ID: 1613859
The XLQUERY.XLA file is still in my project.
All the tips above did not work.

I don't no what to do.

Ron.
0
 

Expert Comment

by:garypalmer
ID: 10107229
I have it too.  Since Excel queries about opening files with macros, I get the prompt for my file, and then a prompt for the xlquery.xla file.  If I say no to that I get a message about xlquery.xla being an excep 95 format and as such it cannot be disabled.  If I want it disabled then my files do no open.  So I have to enable it.

When I am in the VBA editor, I see my file and it's module and I see a "Project (XLQUERY.XLA) line.  If I try to expand that I am prompted for a password.

What follows is a BACK DOOR HOLE to get to the sheet and the macros without having the password.

In VBA the tools->References the few selected do not include Project which adds a reference to XLQUERY.XLA.
In Excell, the tools-Add Ins are all unselected.

I have 2 sheets that do an SQL query if that helps.  I would like to eliminate the XLQUERY.XLA file from my project also.

When I select the XLQUERY.XLA project and look in the menus, there are almost no options.  But when I select the tools menu the macros option is available, so I selected it.  The one available macro is Compiler so I ran it.  I can now see the content of the XLQUERY.XLA file, it opens as another workbook.  Note the trick is to select the project in the project window.  This allows viewing of the old style macros in the file...  

Then I went into that file and deleted the names and then the macro sheet.

But I still have references somewhere... HELP?

Gary
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
copy same as above data 18 37
HOW CAN I TRANSFER AN COLUMN DATA TO ROW FOR ANALYSIS 7 21
vba to flip column 14 18
NEED TRANSFER  DATA 59 20
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question