Can I copy files via VBA by name patterns with wildcard characters like in
DOS:
copy filename*.ext ...
I know how to find file names matching the pattern and copy them

At the end of a long, hard day slaving over a keyboard I'm befuddled
by something that should be easy (or so I thought).
For some reason the for next in the following doesn't loop!?!
Sub Test()

I was wondering if anyone can help with my problem.
I have a workbook containing three worksheets; 'sheet1', 'sheet2' and
'sheet3'. And;
1. On 'sheet1' I have name of the months from B5 to AO5

I have created a userform:- name = frmWelcome. On the form I have a
checkbox:- name = cbNoView. The form contains information concerning the
workbook.
What I am trying to do is to have the form open with excel but should the

I have a routine that cycles through page fields in a pivot table using VB
code.  For the most part, things work fine, but every now and then, I have an
item in my list that doesn't exist in the data generating the pivot table.  
The code is generating some errors as a result, I ...

I have some code that opens a file that MUST be writable so that it
can update some data and save it. To ensure it is writable I do a
check for Readonly = True, and if this is the case (ie someone else
has it open), I start a loop of closing the file waiting some time and

In a macro, I have a main workbook open where I run the Macro.
What I want the macro to do is adding a few new workbooks (around 10 new
workbooks), and then name them according to a list of names (F2:F11) in the
main workbook.

Firstly, this is a great forum for picking up great tips. I am new to
VBA programming and am having (to me) a small problem with my
spreadsheet.
I have my data set out in the format of Col A across to Col Y.

Hi
I have a spreadsheet used to order products from overseas.  It takes three
columns to order one complete product.  The supplier requires each product to
be ordered separately.  This requires quite a few columns set up to take the

For each workbook in Folder A
     Copy  Values & Format (not formulas) of every Sheet2
     to Folder B new workbook, Sheet2 (same workbook name from Folder
A)

Hi all, this is a snippet of VBA code that I recorded and added some
"lastrow" information into (line numbers added for the sake of my
question):
1   Dim lastrow As Integer

Is it possible to loop through text, as it would for number? For example:
  Dim Text As Integer  ' where Text = "Before", "Now", or "After"
  For Text
     ' code goes here

Do I need to know how to program using VB, C, or C+ in order to create a
spreadsheet that has drop down menus?  I need to compile information to a
sreadsheet from questaires that are received for later reference.

I am trying to click on a cell and have it play a wav file.... I have that
part working fine ( I belive )
But when I close excel after playing 1 or more wavs if always ask me if I
want to save changes

I am trying to write what I thought would be a simple macro but I am
having some difficulty in implementing it.
In essensence I have 3 cells.
A1 is a formula