I am trying to do something that I think should be fairly easy, but I am not
able to accomplish it. I am trying to open two dbase files in one workbook.
The first one opens up just fine and adds a new worksheet for the next dbase
file to go to. But the second dbase file opens up ...

i have a workbook with multiple worksheets. how do i save to a new workbook
with only one of the worksheets from the workbook currently opened. I want
the sheet to be saved with exact format and data.
thanks

In an already working well VB6 written COM addin, in order to obtain that my
COM Add-in intercept WorkbookOpen event I added these lines to the
Connect.dsr code:
***

I have XL97 running on Windows 2000. If I have a spreadsheet with a
chart on its own tab, and I switch from a "data" tab to the chart, I get
run time error 438 Object doesn't support this property or method.
Going into Debug, I find it has stopped here:

Range(A5:K1000) contains characters.
The macro should randomly highlight 120 rows (entire rows, that is) in
the above range yellow.
Any help would be much appreciated !

I am looking for a time sheet on excel that has the formulas in it, that uses
am/pm and not military time.  I need one that time in / time out/ time in /
time out, and that will automatically figures regular hours and over time
hours.  Any help would be greatly appreciated.

I recorded a chart creation event macro and then tried to paste it into
my project.  It always fails on line #15 (see below).  What am I doing
wrong?  And what shoud I do to fix it?
Thank you,

Have been trying for some time to determine how to add to a currently saved
workbook name. This is to indicate that the workbook in question has been
processed by the VB Programming.
I have used the following successfully, but so far have not been able to get

Excel 2003
I created the following very simple subroutine as a test.
   Sub CheckDay()
       MsgBox Weekday(Today)

All,
Windows XP, Excel 2000
I have noticed that when my VBA code writes a variable (of Currency data
type) out to a worksheet, the cell automatically truncates or rounds it to

Dim LastRow As Long, r As Long
  LastRow = ActiveSheet.UsedRange.Rows.Count
  For r = LastRow To 1 Step -1
     If UCase(Cells(r, 1).Value) <> "ABCD - SUPPLY" Then Rows(r).Delete

Every day I copy worksheets and rename them with the current date.
After I hit the <Enter> key my cursor lands on what seem to be an
arbritrary spot on the worksheet.  I would like it to default to Cell
C3 as the next action is to change the date in that cell.

Is there a vba macro, that count's filled cells in a column
down to the last cell, from any active cell in the given column.
Using one column at a time.
Then, reports the result as a box message.

I was wondering if there was a way to create a macro that will copy
Excel charts (within their own sheets) into an existing powerpoint
file.  The titles and other formatting are already created in the
powerpoint file the only thing I need to do is copy the charts from

Complete n0ob here,
I'm trying to write a macro that will copy a sheet from a worksheet into an
archive sheet (it's basically a History file of my orders to suppliers). One
cell has the current date (=TODAY) and when copied it copies the function,