I've written a nice little set of macros in Excel 2003 which run
flawlessly on XP (tested on multiple XP machines), but freeze up as
soon as I click run on a vista machine.
Is this just a Vista thing??

My question is the following:
- I use VBA in Excel, and would like to use Excel itself as a data source
(Using ADO). I'd like to keep a table in excel and use SQL expression
power to manipulate the data in the table (selection, grouping, filtering.),

Please how can I copy or insert the filename (workbook) without the .xls
extension in the first column of the access table and the worksheet name
(worksheet tab) in the second column of an access table?
Please I am working on a cost accounting document of

The code below e-mail's (thanks to Ron de Bruin) out two sheets
"Summary Report" and a second variable sheet, which below shows
26/08/07, but this changes every week, thus I'm looking to place the
appropriate code below that would select the 2nd sheet to the right of

I have some thumbnails (all .jpgs) which I am trying to insert into rows in
a spreadsheet.  All are reported by Windows Explorer to have a Width of 60
pixels and a Height of 100 pixels.  Using various programs all look to be
exactly or nearly exactly the same size.  But when I ...

I have the following
Serial No        check Digit
40212463794    4
40212463802    2

I need to determine the order of row fields in any given pivot table.
Problem: I don't know how.
For an example please refer to http://www.cpearson.com/excel/pivots.htm on
C.Pearson's site.

Is there a way to modify the line below so that if the file "Project
Status.txt" already exists, it will automatically be overwritten without
prompting the user to confirm the overwrite?
    ActiveWorkbook.SaveAs Filename:="Project Status.txt", _

I have a third party workbook containing VBA scripts that works in Excel 2003
but not in Excel 2007.  The VBA script contains this line :
directoryName = Range("directory").Value
where directory is a name that references a cell. Excel 2007 gives me "Can't

I am writing a macro that will open a number of workbooks in the same
folder, one at a time. The workbooks will have a uniform naming convention,
like Book1_June_Bob.xls, Book2_June_Tim.xls, etc.
In the macro I want to loop through the folder, looking for a workbook where

I'm simply trying to load an add-in when my wkb opens and then run a sub
that resides with the add-in. CODE 1 resides in my test.xls file. When I
open it, it gives an error "sub not found" error on the line that has "Call
showMessage". The sub showMessage() is the only sub within ...

I have a table with thousand of row of data. The column consists of part#
and operation, etc....
Within the data rows, there are multiple rows with same part#, but at a
different operations in numerical 10 to 999. I would like to create a macro

I am building an Excel spreadsheet using VB.Net code.  I want the vertical
alignment for all cells to be "Top".  To know what code I'd need I turned on
macro recording and went through the manual process.  I got the following
result ...

I am receiving a strange error message when trying to run the below script:
   ActiveWorkbook.SaveAS "c:\Daily Reports for DP\NPP_" & Format(Date,
"mmddyy")
The error i get highlights "Format" and a msg box says:

I am looking for a macro to not let blank and select the cell before
printing..
Thank you.