Hello! I have a macro that when I press a button I want it to create a new
worksheet. The name of the worksheet shall be the current date. I do not know
exactly how to write this so I would really appreciate some help. Pls help me
with this code! Thank you very much!

I have a spreadsheet where several columns are
custom formatted to mm ss and dd mmm yyyy.
When I try and link or inport this into Access - or
save as text, all the values change.

Is is possible to programmicably access the
comments in a speadsheet ?
I wish to save them to a file and replace them
in a new sheet.

I want to name a worksheet. I want the name to be the current date. If there
already exists a worksheet with that name I want to add time to the name. The
problem is that I do not know how to add time to the name of the worksheet.
pls help me! any help appreciated!

I have 2 seperate macro's.
Macro1 -creates a pivot table
Macro2- creates a workbook for each practice.
I would like to combine the two, so that after extracting data needed

This is my problem:
my application based on excel & vb, dowloads from a website some xml
files.
Actually i use to import on my worksheets those xmls creating formatted

I am Using MS office 2003. I want to create chart using VBA. I have
written the folowing function.
Public Function AddChartSheet(ByVal x As Long, ByVal y As Long, ByVal z
As Long)

Hi. I need the "now()" syntax to only return the date, without the time stamp.
Is this possible? Help would be much appreciated.
Many thanks

Dear All,
I am looking to write a macro for one of my procedures that i have to do on
a monthly basis.  I have various spreadsheets with trainee information,
downloaded from our central database.  The trainees are identified using a

when using VLookup, how can I search not the entire cell but parts of the
cell, that is if I want to search 4 or 5 deep. If I'm comparing, for example:
A = 123456789
B = 1234d56789

I am using the concatenate function to list a "string" of elapsed time as
follows:
=CONCATENATE(A1,"YEARS",A2,"DAYS",A3,"HOURS",A4,"MINUTES",A5,"SECONDS")
The problem is as follows:

           I have an excel sheet which will be filled with data from
database dynamically, e.g.
               Field_A              Field_B
                 A                        1

i know this is probably pretty basic but i can't find it in my dummies
book.
i have an array labeled M.
i've dimensioned it to 100 using the statement:

I have Excel 2003 SP2, and have noticed that every time a worksheet is
opened it gets checked for viruses automatically.  I don't need this
feature and it considerably slows down my macros.  How can I disable
it?  Thanks.

I am looking for any advice as to how to detect cell mode. How to I
detect that cell in edit mode?