Solved

How to remove a protected XLA file in VisualBasic for Applications

Posted on 1998-09-25
2
277 Views
Last Modified: 2013-12-29
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."

Thanxs,

Ron Lagerwaard (rla@mediasys.nl)
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
2 Comments
 
LVL 5

Expert Comment

by:jboddy
ID: 1723893
With the Microsoft Query add-in (Xlquery.xla) you can bring data directly
from an external data source into Microsoft Excel. This add-in uses Dynamic
Data Exchange (DDE) with Microsoft Query to allow you to interactively
create a query for your external data. You can even the record a macro that
retrieves external data using this add-in. To use this add-in, click Add-
Ins on the Tools menu and select the MS Query Add-In check box.

0
 
LVL 5

Accepted Solution

by:
theh95 earned 100 total points
ID: 1723894
Try to boot up your system in DOS mode, then goto the directory where the file located, then type attrib -r -s -a -h Xlquery.xla.
After all type del Xlquery.xla, the file  should be gone.
0

Featured Post

Technology Partners: 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

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

751 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