Solved

How to remove a protected XLA file in VisualBasic for Applications

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

Are You Using the Best Web Development Editor?

The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.

See if your editor made the list.

Question has a verified solution.

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

In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

623 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