Greetings!  Have an unwieldy workbook.  It is set for manual calculation, no
calculation on save.  I'd like to inhibit calculation when opening it as
well, but have been unable to intercept it using the various workbook and
application events.  Any suggestions on how to do so?

I have a problem in inserting chart in excel 2007, I was using charts
on one worksheet which was recovered by excel without charts being
displayed. From that time onwards I am not able to insert any charts
into worksheet. I get the information window "Some chart types cannot

I am new to the world of macro, and need some help/advise ..
I am trying to copy contents of a csv/text document into a excel
worksheet and remove some of the unwanted fields in the process and
paste the data in the right columns... (format the data)

How do you store data in Excel as a database?
Can you search this info like in Access?
If so how do you program it or where can I go to learn to program it?
THanks

I'm recording a copy/paste macro, using 'end' 'down arrow' to get to bottom
of list and then press the down arrow.  When I press the down arrow, I just
want the code to appear for pressing the down arrow, but instead it puts a
range command with a specific cell location, like ...

I have an userform with 12 lines of 3 text boxes (36 textboxes total)
The first textbox in the line looks up for a costumer name and places a
balance in the third textbox. The second textbox holds a payment that reduces
the balance (third textbox). I got that part taken care of.

i'm trying to build dynamic clock in vba but the issue is that i
cannot find the activeX timer that appear in VB,can anyone advice what
ocx to search in order to have the interval?

Using VBA under Excel, I need to get time (e.g.:  Now function) expressed as
UTC rather than in PC local time.  Does anyone know how to acquire UTC time
directly (as with .NET DateTime.UtcNow)?  Failing that, does anyone know how
to acquire the System clock parameter to convert ...

I have a spreadsheet that users paste a report into and I want to make sure
the data are in the correct columns.  (Many of the reports provided to my
group have a similar layout, making it easy to make a mistake if you are not
paying close attention.)  

When trying to run my well established macro driven applications on a
new vista computer I get problems with functions like Right, SendKeys
(to name just two) needing the prefix Application.
ie.    Application.Right( etc. or Application.Sendkeys etc. prefixed

Looking for advice on a "best practice" with Excel VBA:
I have a spreadsheet for customer master data records with about 30
columns. I have some simple userforms that enable the user to add/edit/
view records from the worksheet with the master data. The user does

Is there a set of code i can enter into a document that will open all linked
documents.  I don't want to just update but actually open all documents
linked to the main document.  Is there a way to do this?  Thanks

I would like to protect most of the cells on my worksheet but i have drop
down menus to provide options. However, when i protect the sheet the drop
downs are locked.  Is there a way around this?

In the range of (B23:L147).  Col B has header "W/P/L/F", Col F has
header "Customer" and Col L has header "Amount".  If the user enters
any data in any row in the range in column F, without entering data
into the adjacent columns B and L, I want the cells n that same row in

Greetings all,
I need to pick your collective brains again since I couldn't find this
exact issue in the archives. I've got a workbook which looks in a
particular directory on a fileserver, and loops through each .xls