I've been writing a bit of code to automate the opening, refreshing of
external data, saving and closing of spreadsheets. I'm having problems which
I think are associated with the speed of the refesh. The workbook opens fine
but when I run the code I get a warning which states:- ...

Hi experts.
I have a problem with a checkbox' linkedcell. - the following code
works as a charm - but if I want to change the reference to another
sheet, it doesn't work (sub test2)

I have been trying to find out from the microspoft site, without success,
whether macros written in Office 2000 VBA are still compatible with Office
2007.   Does anyone know?

I know you can add an arrow shape to a sheet with using Active Sheet. Is
there a way to have an arrow appear on the form?

Can anyone tell me how I can call an Excel function via OLE automation.
var
 xlApp: Variant;
xlApp := CreateOLEObject('Excel.Application');

I'm trying to make this work but I get a Type Mismatch error.  Any
clues?
If strFrequency = "ea pay" Or "each pay" Or "Bi Weekly" Or "Bi-Weekly"
Or "BI WEEKLY" Or "BI-WEEKLY" Or "bi weekly" Or "bi-weekly" Or "EA

When I've recorded a macro with text and have done the ^+Enter, the macro
records that as  " & Chr(10) & ".  The macros I have that do this have
worked for years without any problems.  But here, in this new contract,
weird stuff is happening.  I now get the error:

I'm trying to create a readable header in an Excel-project, which is a COM
Addin.
The header is supposed to look like this:
LOGO                     Subject: Subjectdata                 Date:

hi guys. i was able to make the first step, thanks to the discussion
groups...  i was able to make a list of all files located in a folder in a
single sheet (column A).  now, i need to find, in each file from column A, a
certain cell within the file...

I have succesfully downloaded .csv files with a macro in my Excell 2003 for
years, but that macro no longer works.  I can't even open a .csv file with
Excel.  Any suggestions.

I have a rather complex workbook that when a user clicks a button it prints
that page to a speciaifc printer and a certain number of copies then emails a
copy to that dept head and then reset the form for the next customer..
my problem is that I have 4 version of the same ...

After loading a file when I issue the command
Windows(TheWb).Activate
where TheWB is the name of the file (with or without the path, doesn't
matter), I am getting an error:  "Runtime Error 9, Subscript out of range".  

I'm sorry this bloody hard to explain. I have a userform with two text fields,
txtstartdate & txtenddate. I would like to use a command button that when
clicked on opens up MS Calendar for selecting a date not clicking on text
field. The first problem is when I select the date it is ...

I have written macros and tested them in VBA. They do run. I have assigned
these macros to buttons on a report worksheet. I have changed Excel security
settings to allow all macros and allowed access to the VBA project module.
However, when I click on the buttons to run the ...

I run a comparison between column A and column H. Sometimes column A has the
same number, with different data in column B. I need to insert and move down
6 cells beginning in column H. Is there a function or VBA code that can
handle this operation.