I use a text file to hold information but I need to be able remove a line of
data, I was wondering if this is possible I have tried to inforamtion on this
without success.
Can any body please help.

Please help me, i did the long way already, i used IF condition to
identify the sheet name and loop to look up the value from another
sheet, someone told me that i can do a loop to get all the info i
needed from those sheets and the loop will stop until all the sheets

Is there a way in VBA to display a message box that shows the just the
following:
-- Error Code
-- Error Message

Can somebody write me a code to insert some rows after certain rows. i have
data like this
1
5

I have encountered an odd quirk in GetOpenFilename in Excel 2003
It works fine provided that you never have to use the filter for files
with no file extension. If you attempt to filter on "*." the entry is
completely ignored!

- I have a number of dropdown controls on a custom toolbar.
- On Workbook_Close, I save to a worksheet the ListIndex properties of
each dropdown control.
- On Workbook_Open, my code builds the custom toolbar, and the user's

How can I copy (en mass) a folders contents, to show only the names.ext of
the files.
I'll be using these names to create links in excel. I've tried the insert
hyperlink, but it is too slow for all the work here and there are toooo many

I have a hidden sheet that compares the two lists to find additions in a new
list compared with the current list and displays the result in the first rows
of an adjacent column.  Is there a way to check if differences are listed in
column D and if so, display a pop up message to ...

Shortly after installing SP3 in Excel 2003, I created a new workbook with a
refedit control on a dialog.  At least, I tried to.  I got an error message
when I tried to add the refedit control.  So I did a repair of Office.  I
was able to add the control then. However, when I ...

Using WinXP Pro and MSOffice 2003 Pro
Col D has customer name
Col E has customer location
Col G has customer amounts

Does anyone know how I would find the dates that Rosh Hashanah and Yom Kippur
are on by using a given date? Right now I have a workbook that sets up a
timesheet for the year. Due to the layout of the timesheet I would need to
have the date of Rosh Hashanah and Yom Kippur be ...

When I'm trying to do is, bring up a "msgbox" but when you click on "OK" it
closes the Excel without saveing the work sheet. I belive this will be done
as a userform, but not sure on the VB codes.
Thanks

We have an application that keeps track of weekly transactions, and is
linked to a summary workbook.  At the end of the week, a procedure is
run (from the weekly file) that saves the weekly file under a new
name, and adds new links to the summary file.

Sorry, I'm really, really ignorant when it comes to programming macros.  I
currently have an Excel file with two worksheets.  Worksheet 2 is named
"Links" and consists of a list of links (not in hypertext format... not sure
of this could be the problem or not).  Sheet 1 is named ...

I work for a company that typically has very large and long
engagements. Many reports/schedules/analysis spreadsheets are created
throughout obviously. Each case usually has its own custom headers/
footers specific to that case. Although they can change numerous