How can I make the default "save as" file name that appears when the
window dialog box opens reference a cell in the worksheet where I have
its name stored.

I'm trying to insert an image into an Excel cell. Please see the following
code. Does
anybody have a way to fix this "COMException"? I thought setting the new
reference in Visual Studio

Team --
I'm working on an app that will collect information in a users email inbox,
sort it and pull specific field information from an HTML based form.  Once
it's got that information, it sorts through and matches information in the

import/export ...to pdf
is it possible?

I need to copy data between xls files.  File One is a data entry file.  I
need to open File Two, look down column A to the last used reference no, add
one this and insert it in the cell below.  Then I need to copy specific cells
from File One into cells on this row into columns B ...

I have noticed an error when I do a subtotal with two breaks (do the
subtotal twice on the same data).
I have narrowed it down and have a book that the error can be reproduced and
since it is very hard to explain in text I'd really like to send a copy of my

Is is possible to go to the last cell in a particular column, copy that data,
then perform a reverse autofill??

Dear gurus:
With environ() I can find homepath or userprofile, but how can I get the
path for "my documents"? Thanks in advance!
wang

Plz tell me ow to read an EXCEL file in VC++. I want to read each
column in separate array. I am not sure it is possible or not? If
somebody have the code please send.
regards

Starting in cell C16 I need to copy every 3rd cell in column C until there
is no more data. How do I copy cell C16 , offset down 2 cells, copy again etc
etc until blank.
I then need to paste all these values into column C of another worksheet

I have seen many posts within this group in regards to progress bars
and how to make them, but the issue I am having right now is that as
soon as the userform appears to tell me waht stage it's at in the
macro.... the macro stops until i close the userform.

I was wondering if someone could explain to me why it is we dim objects and
long.  Where is it important to do and why.  I have been puzzled by this.  I
have read lots trying to figure this out.  What it means and the purpose of
it's application I am strugling with.  

I'm trying to use code that I found in a previous post to export an
Access table to Excel.
The code is as follows:
Private Sub Command1_Click()

How I can to print at once, all criterions of one filter in "AutoFilter",
without
the need to select and print the criterions  one by one ?
Thank

I have an excel sheet which part of it checks my inbox for e mails with
the subject of "manual handling questionnaire" it then moves it to a
folder called manual, and then it is supposed to save the file in my h
drive, but it all works except that it will not save the file into my h