I have aprogram that talks to an Engineering application and passes data back
and forth to Excel.  The engineering program generates a JPG file that I wnat
to update in my Excel Spreasheet.  Does someone have a macro to do that?  It
needs to load form the same folder as the ...

Is there any way I can automatically open  and unprotect , refresh and then
protect a Pivot table through VBA macro?
Pls help me out.
Thanks in advance.

Little help needed
Via VBA I need to email a specific sheet from and Excel 2003 workbook
(not the entire workbook due to sensitive information) Any ideas?

I have a rather lengthy macro that basically loops through a long list of
company names. This macro takes appr. 20 minutes to run and therefore I would
like to give the user some idea of how long time has gone/is left. What I
would like is some sort of a message box that shows ...

I have a userform that I am piecing together and I would like to include a
checkbox control that would print a receipt using the info in the userform.  
The receipt would be another excel worksheet inside the same workbook.  I
think that I can use the checkbox to start a macro ...

I realise this as been asked before just hoping that there may have
been some changes or news ;o) if not is there a place to post comments
to MS so that maybe one day it will change.
Anyway the question:

I have information in one column imported from another system. The
information is structured in one text string but each row includes a set of 4
different data strings diveded by a comma ",". Like this:
Red,house,door,20000

Hi Guys 'n Girls
in one of my Wordtemplates i have following lines:
dim e as excel.application
set e = excel. application

i create a user defined function as bellow. when i call this function
from VBA, it return correct result. but when call from excel sheet, it
return #value!. can anyone help me this? thanks in advance!

I have a column with multiple values.  e.g. When the value of A1 changes, the
A1 changes color and the row (A1:A30) should change accordingly; and so on...
I am using the If .Column = 1 Then Select Case and works beautiful for a
cell. But I don't know how to extend it to a range. ...

I have a lengthy process, call it My Process, started by clicking a
button from a userform.
MyProcess can take a few minutes, and while it's running I want all
excel user interfacing disabled.  In excel 97 I simply surrounded the

I'm performing a normal SELECT query from Microsoft SQL Server via
ADODB. The line of code which performs the query is a simple:
rsdata.Open sSQL, sConnect, adOpenStatic, adLockReadOnly, adCmdText
Now, the query pulls out anything between 200 and 1600 records, and I

This is my first post.
I have a simple VBA function that counts the number of colored cells
(of a certain color), and prints in to the cell which activates the
function.

I need to write a C# program to take data from an IBM AS/400
Without the client access drivers from IBM, how can I get the data from
the AS/400?
What would be an example connection string?

I would like to have 12 option buttons grouped together in each row.
The option buttons for each row should be independent of the ones in
the other row.
I added option buttons from the forms toolbar for the first row and