how can I specific a folder with wildcard criteria and excel will
import all the correct files in that folder?
I am completely new to macro programming. After doing a little research
I found out that GetOpenFilename or GetFileList may be able to do

I need to insert some drawing objects into a worksheet. I would like
the user to be able to select the object (so locking it won't do) and
be able to move it, but not resize it. Is there any way to disable the
sizing handles on a drawing object? (I'm talking specifically about

Is it possible (and simple) to set the properties of a graph object so
that the printed output of the graph is of a predetermined scale, say
for instance 1cm for each minor division?
Thanks,

I inserted object; combo box
   Dim combo As OLEObject
Set combo = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1",
Link:=False, DisplayAsIcon:=False, Left:=100, Top:=100.Top, Width:=96,

Here is one I can't find any info on. In a UserForm, the user has the
option of entering text in TextBox7 to be entered as Cell Comments.
Let's say that this text would be entered to the named range
"CellComment".

I'm working with a spreadsheet that uses a query, the query looks at an
Access Database. I have changed the physical location of the database and
would like to change the query path. Is there a way to do this without
making a new query?

how to use data to create charts and database funcions as =dbmax, etc.. from
the a data in sheet1 variable ?
Because the data is import and I not know the total lines from range of the
table...

I am trying to update a spreadsheet from a9 to z(infinity).  If the
user clicks or enters data into a cell then id like some checks to be
made within the row and maybe calculations to be made.  I am able to
do this when data is entered into a specific column with:

I'm looking for some feedback with regard to taking some data from an Excel
Workbook we use to track info on and loading it into Access AS QUICKLY AS
possible.  Once it's in Access I can do the rest, but I am sort of new at the
best method to automate the movement from Excel to ...

I need help:
I need to save e mail attachments (excel) and found the following code in
"outlookcode" site, but it is stopping at DIM my OlAPP As New
Outlook.Application

I have a macro that uses "SendMail" to send a workbook to a list of users.
If there is an invalid email address, it will not send the email at all.
Is there a way that I can verify the email addresses before the workbook is
sent?

Hello Experts,
There are 6 steps needed in my question of how to pull data into a new
journal entry [Summary] tab:
1) How do you skip through the "" (blanks) and the zeros within column

I'm working on a spreadsheet for my employer that has a number of sheets
that need to be hidden from some users, but visible to others (e.g. costs).
All users need to be abler to make changes, but only some will see ceratin
areas.

How can a run a macro off a: 1) value in a cell 2) different values in a
combo box?

yoramsk@gmail.com
Jan 23, 9:22 am   show options
From: "yora...@gmail.com" <yora...@gmail.com> - Find messages by this
author