All -
I have reviewed the sample code at
http://www.bygsoftware.com/Excel/SQL/UsingSql.html
regarding the querying of an Access Database from Excel utilizing the DAO

I want to create mailing lists from the name, address, city state zip info
on each sheet in the workbook. But I'm stumped on how to copy the range from
B1:B3 to another sheet ("names") and have the info run from A2:C2.
So far I'm able to have the data print only in the A column ...

I've read a few different posts in the newsgroups regarding this topic,
but I guess I need to have it spoon fed to me to understand it. So here
goes:
The first column of my pivot table is a set of numbers. I want them to

Hi
I am new to VBA (have gone through MS training 30 minutes). My
requirement is to check that UK post codes are in the correct format.
I want to create a macro for this and need help.

Hi, is it possible with vba, to compare values, give or take 1. eg x =
15 and y = 16. If x(+ or -1) =   y(+ or -1) then............ In reality
what Ihave is something like 16.1111111 and 16.111112, I just want the
whole numbers, eg the 16, the .1111 is not needed, although its part ...

I currently have a workbook with two worksheets.  I need a formula that
returns the row number from the second worksheet of the first unused
row.  I need this value to be displayed in a cell on the first
worksheet.

First, how do I assign a cell (or range) to a range variable (you will
see in my code posted below).
Second, can I refer to the Home Cell (the cell at which the panes are
frozen--[Ctrl] + [Home]) without actually selecting it?

I'm looking for some code that will allow me to search for a specific
worksheet.
If it doesn't exist, then run some code.
The code below obviously doesn't work.  How can I rewrite this?

Hey everyone, I want to try and incorporate a security feature in to my
macro.  I know if someone has the right knowhow, they can crack the
password for a locked VBAProject, but is there a way to write a code
that if the person attempts to crack the code or enters the wrong

Could someone tell me why
MsgBox Application.CommandBars("Cell").Controls("Insert...").ID
is giving me a invalid procedure call or argument error.
I'm actually trying to disable insert and delete from Cell and Row right

I recorded the simpliest macro to move content of the cell A1 to the cell A2:
Range("A1").Select
Selection.Cut
Range("A2").Select

We are using the Aloha POS in our restaurant. The POS has a time clock
funtion as part of the operating system. Each employee clocks in and out for
their shift worked. Aloha stores all the punches for each employee in our 24
hour restaurant. At the end of the pay period I export ...

I've got a sheet that has special product assemblies that consist of a
"parent" product description, and a listing of components that the "parent"
product consists of.  
What I need to be able to do is have the parent qty overwrite the component

I have a listing of items and one column is now a combination of detail
lines, and product part #'s.  I need to be able to seperate the two.  The two
types appear in no particular order or sequence that is consistant.
One characteristic of the part #'s is that they always start ...

I'm new to comboboxes and need a few clues.
I have Combobox1 that lists 3 dates.  Combobox2 lists the names of
volunteers.
I want to be able to make many selections from combobox2 to produce a LIST