Solved

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

Posted on 1998-10-01
14
2,917 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
excel - employee availability remaining after scheduled 7 52
Determine Office 2013 Bit Version 3 36
Excel If tests 10 64
PSTOOLS Office Activation Not Working 11 56
Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

920 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

16 Experts available now in Live!

Get 1:1 Help Now