I have an Excel workbook with 15 worksheets in it that each week I need to
zero out the data from four (4) columns that are next to each other to get
ready for the next week.  I would like a macro to do either zero out one and
then jump to the next  or do them all at one time.

I've got the following macro code and what I would like to do is change the
value of [-17] on a a separate sheet -such as Sheet1. For example, this part
of the code in a monthly total so [-17] refers to Feb-08 and in March I would
need to update the macro with [-16] for Mar-08. I ...

I'm trying to get the correct file creation date from an open,active excel
workbook.
When I go to File\Properties\General tab, it shows it was created March 18,
2008.

I have a macro that refreshes a query to a file and returns all the
data in the file and puts it on a sheet. My problem is that the
directory name can change because of what computer it is installed on.
So I wanted to have the macro look to a specific cell on a "Setup"

I created a VB module that transposes data in a spreadsheet.  I need to use
this same code for many other spreadsheets.  I was wondering if there is a
way to create an automated process that performs a mass update of all the
spreadsheets with the same worksheet name (for example ...

I am trying to create a macro that will filter column B which is a listing of
dates from last year, same month.  So, for instance this months report
contains dates listed from March 2007. I need to filter for dates that are
less than todays date.  So, anything from the 19th of ...

On Excel I use on several sheet "BeforeDoubleClick"
When I open the first time the worksheet everything, work fine.
" I double click on the a cell in the first sheet wich send me to another
sheet in function of  what is in this cell.

Few days back I had posted a question on how can I "publish" an updated
custom toolbar to my friends and colleagues?
The reply I received was to write a VBA macro that would delete my custom
toolbars on file close.  And then on file open the macro to add my new

I am plotting several charts in Excel on a single page report, controlling
the process with VB.NET; in the VB.NET application I define all the charts
parameters (fonts, sizes, positions, etc.), and the page parameters (margins,
headers, etc); when I run the application in PCs ...

I have Sheet1 and Sheet2.  There is a Public Sub on Sheet2 that sends out
emails based on data on Sheet2.  I would like to be able to click a button on
Sheet1 and run the Public Sub on Sheet2.  When i try to use Application.Run
"email" i get the error "Run-time error '1004': ...

Excel connect/import Access data using ADO and VBA?
I was wondering if it would be possible to keep an access database as
a repository of data and use Excel as a method of interacting with
that database.

I am writing a utility that extracts data from our databases and generates
an excel spreadsheet with PIA. I have almost all of it working, except I
cannot find documentation ANYWHERE on how to freeze a column, so that it is
always displayed, no matter the scroll position.

Hello from Steved
Please how does one tell Cell G9 to add Cells G6 and G7 minus G8 to give the
answer in Visual Basic Application.
Thankyou.

I'm using Excel 2007 - Data is in column A
I have a data set that I am trying to import.  The first column really
should be 5 separate columns, but has been created as one string.  I need to
separate into 5 columns.  the data looks like this:

I have searched the blogs and cannot seem to locate anything related
to my challenge. I know you guys are gurus when It comes to things
like this.
I have a worksheet that tracks employee productivity for each cost