I'm trying to retrieve values of certain cells in certain worksheets of
certain workbooks. However, these Workbook files are often used by several
users and so I would like to just discreetly get the values in the
background, so hat it wouldn't interfere with the usage of other ...

I have a big file and I want to delete duplicate data in rows
separated by comma in same cell
i.e
Sample File

If I open a microsoft query to get external data in excel, it opens
query (I am NOT using the query wizard).  Once I define the query, I
save it so it can be used again.  
QUESTION!!!

I have a spreadsheet with amounts that start in column C and goes through
column AE (columns A & B contain an entity number and an entity name).  The
number of rows varies, but it is typically about 600 rows of data.  This data
begins on row 9.  Row 8 contains the column headers ...

I currently have one Excel workbook with two separate, but similar
macros, outputting data to two separate ,but similar, worksheets based
on a date the user enters in the input box triggered by each
procedure.

I tried to implement the example in
'http://www.microsoft.com/technet/scriptcenter/guide/sas_fil_higv.mspx?mfr=true
to get the 'My Documents' and 'Desktop' folders, but Excel doesn't like the
'.Self' property of the 'Folder' object.

A pesky little thing is eluding me.  If I determine that the last used column
in a worksheet is, say, Worksheet.Columns(22), how can I convert that into
"V" so I can subsequently do things to Cell V1?  I'm sure there must be some
nifty Property out there somewhere for this ...

I have a problem with WordArt in Excel 2007. The code below works
perfectly fine in EXcel 97 through to 2003 but in 2007 the text
characters are filled white, but in earlier version they where
transparent.

I've created a menu bar with custom buttons and assigned macros to the
buttons.
It works fine on my personal computer but when I copy the file to
colleagues and they open it, the menu bar fails to work; the buttons

I would like to change the color of some text based on conditions.  Of
course, it's not quite as simple as it could be.  My data is contained
in one column, but consists of one set of data, concatenated with some
parentheses and another set of data.

Sub m01_GetData()
'
Dim origin As String
Dim orgn As Workbook, dest As Workbook

In UserForm3 I have a CommandButton named "M1".  Is there a way that I can
use code to set the caption of that button?
example.
UserForm3.M1.Caption = "4"

I found the following code, but it doesnt work for me.
I need a code that will delete Rows A-H based on the data in column
A.
Example:

I have a combobox on a user form populated with a list of data from sheet 1
of my workbook. The list contains approx 200 rows of data across 20 columns.
When the user makes a selection from the combobox a number of textboxes on
the userform are populated with data from the ...

I have a fairly simple operation I am trying to implement.
I have a command button called "Screen" in worksheet "Sheet1" of Workbook
"Book1". When I click it, I want the value in cell C2 to increase by one
(e.g., if C2 = 3, I want it to automatically increase to 4 when I click