I have a 3 column worksheet (chart of accounts - Code, Detail, Group). Each
column is of a different width. I can load these 3 columns onto a ListBox but
some of the text is not legible as all columns are of the same size in the
ListBox. Need some code to adjust column widths in ...

I am getting an error 13: Type Mismatch and don't understand why.  Would
someone clarify this for me?
Sub SaveItems(AmountCol, Choice, ItemAmount)
 Dim ws As Worksheet

I have an Excel-file that interacts with MATLAB, some of the interactions
can take quite a long time, when that happens a window comes up saying that
"Microsoft Office Excel is waiting for another application to complete an OLE
action. I understand that I should be able to get ...

I am trying to loop through the sheets in a workbook and test to see if the
which sheets are chart sheets.  The code is failing is this because of the
way I have set up the wrksht variable (i.e. dim as worksheet)?
Function IsChartSheet() As Boolean

i'm tryingt o generating graphs out of my worksheets, all graphs are
catching data from the same columns (column C is Y axis, column D is X
axis, I;m trying to write sth that will catch this two columns
automatically once i'm swiching to new worksheets.

I am deploying in XLA using Nullsoft Installer (NSIS).
I was thinking of just adding the XLA to :
%APPDATA%\Microsoft\Excel\XLSTART
This is the Adobe Acrobat 6 appears to install PDFMaker.xla.

I am using a Circular Reference in one sheet in a workbook and keep getting
the Circular Reference message.  Is there a way to turn this message off?  I
am using the code below, but it doesn’t resolve the issue:
Private Sub Auto_Open()

I am trying to copy over a range of sheets from one workbook to
another but there is an error in my VBA statement.
Could someone tell me what is going wrong?
'Copy Trial Balances worksheet

I would like to set up an autodate in an excel spreadsheet.  I want the date
to fill when I enter data into the previous cell, but I do not want the date
to change when the report is updated or saved. Is this possible in excel.  I
do not want to take the form to access because of ...

It's straightforward to set text in the textframe of a shape using the
characters method but how can you retrieve the text? I've tried using text,
characters.caption and characters.text, and I've tried creating a characters
object and setting it from the characters method - ...

I'm working on an Excel Project and would like to use some utility
functions resident in my Personal Workbook.  Is there a simple/
standard way to access those functions from the other Project?
Or is cutting and pasting the code the non-elegant, best way?

I need to setup a conditional format based on an adjacent cell value...
Let's take columns B & C for example...
I want to format B1 red if the value of cell C1 is greater than zero and the
value of cell B1 is zero.  

I would like to write a macro that will work in Excel 2003 that would enable
a user to use keys on the keyboard (F5 and F6 for example) to start and stop
a timer function and return the amout of time elapsed between
keystrokes...like a stop watch.  I would like to use this to ...

I would like to use MS Query to import data in to my spreadsheet with security.
I must user my ID and password to create and save MS Query to retrieve data
from SQL server via ODBC.
If shows my ID and password when user run the report.

in Excel VBA macro, I found:
here is a file named  "abc[def]gh.xls" in folder_A,
1. Code1:
   for each objFile in folder_A.files