?
Solved

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

Posted on 1998-10-01
14
Medium Priority
?
3,078 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
[X]
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
  • 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 3

Accepted Solution

by:
frazer earned 300 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
New style of hardware planning for Microsoft Exchange server.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
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…

764 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