This code was originally written in Excel 200 - I am now in Excel
2003.  The code pops up a UserForm and asks for keywords, then does a
text search through a collection of Word documents.  The original code
wrote the full path of all matching documents into the worksheet as

I have a class module called CInertiaData that contains 6 double variable
declarations:
Public dmMass As Double
Public dmDensity As Double

I have a file that has 65 sheets -- I would like to protect them all, but
not have to unprotect and then protect again each time I have code run to
change a given sheet.  I was under the impression that "UnProtect
userinterfaceonly:=true" allows code to change a sheet without ...

I am running a script that does an automatic login for 100's of training
ID's.  We have the script that opens the browser (uses followhyperlink) and
enters the user name and password using sendkeys.  What I need to know how to
do is determine when the window has correctly opened ...

ActiveSheet.Hyperlinks(1).Follow NewWindow:=True
ActiveSheet.Hyperlinks(2).Follow NewWindow:=True
...opens the first two hyperlinks on a sheet in the same window. Can
anyone tell me:

After rolling a spreadsheet every month by saving a copy of the old one and
deleting the old information the macro is getting slower and slower? What
could be causing this?

Is there a way to set a 'listbox .enabled = false' but still be able to use
the vertical scroll bar to view the list?
If it is possible how do I do it?
Thanks

Not very familiar with macros in excell but here goes. I need to automate
excel steps done monthly. I use a template workbook containing two sheets
that is filled with data during the month then a pivot table is created for
each sheet . Can the steps in creating the pivots be ...

I have a VB2005 (frontloader) which automates Excel (creates new
instance, new file etc).  I have put a datepicker on the frontloader
but when the date gets put into the Excel file I get a #NAME error on
five cells that are dependent on the cell the date has been placed

Hi,
I have a sheet with a calendar control on a user form, just the calendar
control 11.0.  This works fine, however when i distribute the sheet, the
users get an error message “could not load the object because it was not

I have some charting code in which the data for the chart is specified
as a formula (eg =SERIES("firstData",
{"NTC","11","12","13","14","15","21","22","23","24","25"},
{0,8,15,17,10,35,8,15,18,11,28},1))

I m a newbie, I have this select case checking for textbox values. I
want to loop this so that it checks for all the textboxes. Or else I
got to write the same code for each Textbox :(
Select Case Me.TextBox1.Value

Hi, I need to automate copying cells from one worksheet into another
using macros but cannot figure how this will work. I have both text
and numeric fields starting from cell A1 to CE200. I need to ensure
that whenever I add a new row or column, these are also replicated to

I have a problem using the code below:
Workbooks.Open ThisWorkbook.Path & "\Data\Book2.xls"
Im trying to use the above command within Book2.xls. The file and path is:
C:\Program Files\MyProgram\Data\Book2.xls

I use the code below to export a series of sheets to a new workbook.  I need
to know how to NOT export the button objects.  Everything else is fine, but
not the buttons.  Can anyone help me?
Sub Mail_Sheets_Array()