Solved

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

Posted on 1998-10-01
14
2,884 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
Comment Utility
Edited text of question
0
 
LVL 3

Expert Comment

by:arnond
Comment Utility
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
Comment Utility
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
 
LVL 3

Accepted Solution

by:
frazer earned 100 total points
Comment Utility
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
Comment Utility
'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
Comment Utility
my e-mail is :
<<e-mail deleted>>
hope I can help...
0
 

Author Comment

by:rlagerwaard
Comment Utility
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 3

Expert Comment

by:frazer
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now