Solved

How to remove a protected XLA file in VisualBasic for Applications

Posted on 1998-09-25
2
268 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
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

746 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

12 Experts available now in Live!

Get 1:1 Help Now