Solved

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

Posted on 1998-10-01
14
3,032 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
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.

728 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