In my app I use this slightly modified, (from a recorded macro) code
to save a workbook and create the standard backup
"Backup of ????????????.xlk" file name.
Application.DisplayAlerts = False

Hi! I dowload data into excel by using a macro. I have a dde connection.
usually it works finme but sometime i get an error sent from the dde. this
causes a problem becuase i save the dde answer in a varaible in vba. if i get
an error from the dde thenm I get the message ...

An array contains the elements 8, 9, 10, 15, 16
for example (no significanse to the numbers,
they are just labels). At different times the array
is repopulated with some of these same elements

I'd like to retreive data from an external database in excel.  To import
those datas, a criteria (a number) is used. So, there are :
1.an ODBC link (Teradata) to a database.  
2.an SQL query (external data import -> new query).

I have a macro can copy a spreadsheet in a workbook. I start of with two
spreadsheets in the workbook. The second sheet is the one I copy. On the
first worksheet I have the number of times the second spreadsheet is to be
copied in a cell, say C2. Below I have the name of each of ...

Has anybody else noticed this?  Excel 2007 beta 2 VBA was very sluggish.
Just about every operation was much slower than earlier versions. Today I
updated to the technical refresh. Everything still runs at a fraction of the
speed of earlier versions of Excel.

Am trying to use the following (from Ron dB)
Get error shown above at line indicated by >>>>>>>>>>
Is there supposed to be other lines at the start of this code?
   Dim sh As Worksheet

I wrote  macros in Lotus and we are currently switching over to Excel but I
can't find the command that will allow the user to input the name of the file
to open and get the data from the file. I have it set up to open a file ,
copy a range , close the file and paste it in the ...

I'm currently working on a gradebook, and as the british system for
grading is 5a 5b 5c etc. rather than just plain grades, I want to know
what would be the easiest way to create a formula to show the Maximum
grade they've acheived, their lowest grade and their average grade.

Hi again -
I am trying to write a macro that when a button is clicked on a spreadsheet,
it will use the data entered on the new row to create an appointment in
Outlook...

I'm trying to run a macro that constantly monitors a file. so that
every time a cell value is added or changed the macro checks for
certain errors.
Is this possible?

I am trying to use macros in existing spreadsheets. They work fine if I
create a new spreeadsheet etc. But when I try to use the same macro in an
existing sheet then it doesnt work. Highlights the error.
Simple macro such as:-

I want to make a Timesheet and calculate the some of time working  with
(hh:mm) cell s format  *number(time payment) .For Example:   (09:00)*(100)$.
Can Anybody help me,pls?

Ok here is what I am trying to do.
I have a workbook (with two sheets, one being the data sheet) that
essentially prints an Invoice in triplicate and numbers them serially.
What I want to do is to save a copy of the Sheet named 'Invoice' as a

I'd really like Excel to have an All(range, criteria) function, as used in a
number of programming languages. For instance:
   A   B   C   D
1  y    y   y   n