which macro procedure command should be used in order to log that the
workbook is beeing opened without letting the user notice?
TIA

i have a excel wookbook which contains references to other workbook. whenever i open this wookbook it asks me for updating the link to the other workbook. i want to remove these references to other workbook but am not able to figure out which cell is refering to the other ...

Hi, could people give me there best recommendations for training mysel
in Visual Basic. At present I am very much at entry level, and can onl
cope with a recording macros, and doing some basic edits.
Cheer

I trade in the stock market & use excel to convert a list of ticker
symbols to a csv file to import to a charting program. I start with a
vertical list in excel, I copy then paste special & tell it to
transpose. It seems if the list is too long I get an error message:

Please help a newbie.
Kindly, someone show me how I can make a content of a cell
to show "the last time the spread sheet was saved". This
cell in  question is part of the same spread sheet.

I am running Windows 2000 with Word 2000.
I am trying to link a paragraph in one document to another
document so that when I update the paragraph it
automatically updates in the other document.

Here is my problem :
My macro get data from a dynamic table .
For each PivotItems in PivotFields("color"), i get the
number  or sum in the data range. Everything works well

New to this so please forgive me...
I have been transfered to a new department at work where they are usin
Excel 2000 for a series of reports.  The data they are using to fill i
the fields for these reports are hard copies of 5 thick reports.  Ever

All,
I have search Microsoft's Knowledge Base, but could not find an answer.
Hopefully, someone here can solve my problem.
I am using Excel 2002. I have several project managers maintaining budgets

I have a procedure called that looks for a negative sign (*-*) in the D column
for all records.  If it exists, the entire row is deleted.  The procedure below
works well for this situation, BUT when there are no records with the negative
sign in the D column it deletes the first ...

Ok, going nuts. How do you say "go to the next cell down" in VBA? ex:
I'm pasting something into cell A23 and would normally hit enter to go to
cell A24. TIA
-Chris

Created a simple file 35 rows by 8 columns, text & numbers only which can print on one 8.5x11 sheet of paper.
When saving to newly formatted 3.5" disk on A drive, got a 'file too large' error message. Looked at PROPERTIES and file size is 3.31 MB. Unable to reduce file size. ...

I have multiple pages, each reprresenting a single property that I own. The
topmost page is named "Total" and the final page is named "99". Each
property is named differently, depending on the property number that I have
given it.  Each page is exactly the same.  On each page is a ...

I have 2 files. Each ahs a column that contains the name of a company I do
business with. I need to merge the files together by company name (Column A)
so I get columns A thru D of file2 merged with the same data (A thru D) in
file1. The end result would be column A from either of ...

Does anyone know how to automatically display UPPERCASE even if lower case
is typed in a cell please?
Peter.