• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

How to remove a protected XLA file in VisualBasic for Applications

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
rlagerwaard
Asked:
rlagerwaard
1 Solution
 
jboddyCommented:
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
 
theh95Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now