Hello
I have some code that was given to me and I have modified.  I am trying to
modify again and I am having trouble.  I am opening files manipulating data
and then copying to another workbook where inthe macro lies.  All of the

Can anyone help identify why this is not working correctly.  Following is the
full code from the form. Myself and another member have worked on this but
can not resolve the problem.
This code is used for a 2 page form that takes information from the sheet to

I'd like to protect a worksheet so that all Locked cells are unselectable yet
the user will have the ability to insert a picture when an unlocked cell is
selected. Basically, the top 12 rows are locked and the remaining cells are
unlocked.

  I am trying to build a VBA Macro to Hide-Unhide rows that does not
contain a value in a specific column of my sheet.  I would like to do it
automaticaly without me having to play a macro.  I have a VLOOKUP in the
cells I want evaluated so if I enter data on another tab it ...

I can't get this code to work proper in the event.  When I run the code by
itself, it works no problem, but when it is in the event, it runs through the
code but does not update the footer, the code is in 'ThisWorkbook':
Sub Workbook_Beforeprint(Cancel As Boolean)

Hello I am new in excel 2007,
how i can export a column of one excel file into text objects
separated by comma?
For example if i have:

How can I get a logo image to show for a couple of seconds every time
a file is opened?
Hide the image on a sheet then unhide it??
Cheers

I have a macro that opens automatically, runs a couple of calculations and is
programmed to email the completed workbook at the end.  I want a way to
disable the macro when i send it so when it is opened by the recipients, the
macro does not automatically start again.

I'm getting the error: "Cannot create object" when instantiating a form
commandbutton in Excel 2003 with VBA code. The code works fine in XL2007. I
suppose also woth noting is that the XL07 is running under Vista while XL03
is running under WinXP Pro with the latest SP.

I have a dropdown on a worksheet which is populated programatically - I can
put the options into it fine, but I can't get them back out again.
I can get the .value or .listindex without a problem, but I'd rather be
working with the string.

I run the code below and get an error 'Data Type Conversion Error':
Sub DAOFromExcelToAccess()
' exports data from the active worksheet to a table in an Access database
' this procedure must be edited before use

hi,
i have a sheet with severasl rows in it.  each row corresponds to a certain
month and year.  ranging from jan-04 through mar-08.  i would like to add a
new column to the worksheet, and have it have a formula for the YTD sum.  so

Hi,  Sorry but I have to try to ask this question again.  I have had usefull
information from some members but no resolution and this is the last
stumbling block, I do not know how to say it simply that I feel conveys what
I need but here goes .

I'm faily new using VB.  I wanted to move the last character so it will be
the first character if only that character is a - .  This will be withing the
whole workbook.

I am looking for hel to delete data from one of the huge excel file I
have.
Actually, I have two excel files, one contains data regarding Users
with UserName as primary key and other excel file contains some of