Hi...
Can anyone help me out here...
I have 4000 files all randomly saved with any name you wish to name, all in
the same folder called AA. The only thing the 4000 files have in common is

I'm in the Insurance business and when I sell a product I have an expected
date that I think it will get approved and get paid. One of the products,
product "M" must get paid before the third Wednesday of the month if not
then it will go the following month.

I've setup a pretty neat macro that opens 50+ csv file and then copies the
range (A28:B128) consecutively underneath each other but I'm worried that I
have no control over the order in which these files are being opened/inserted
underneath each other...I want to choose the ...

I'm using the following code, with NO reference to outlook:
Dim objOutlook As Object
Dim objMailItem As Object
Dim myCreatedEmails() As Object

I use a user form in which the user shall enter a date in a text field. I
then have a sub that checks if the date is valid. If not so I show a message
box. However I want the program to show the message box and when the user
clicks OK I want the user form to still be shown.

Hey all,
I have a workbook which contains many worksheets the first of which i
always called '01' and the
last which is always called 'Reference'. I also have a second workboo

When export to Excel most of the time I loose the leading zeros, I want to
know if someone have a macro to restore the zeros?
Thanks,

i still have an error in following formula in -->  ;"";  place
thanks/tufail
Hi Tufail,
This is how i get round it

I am not the system administrator here so I have limited
autherizations.
Is there a way to create a workbook, or a code I can put in the
workbook that would prevent anyone from opening the workbook or at

I am using excel 2000 and have a workbook with 2 sheets, Targets and
Individual Store Targets
The Target Sheet has the the Store Name in column A, and various
targets in columns B, C, D & E, the data starts in Row 4 and currently

When export to Excel most of the time I loose the leading zeros, I want to
know if someone have a macro to restore the zeros?
Thanks,

I have an Excel add-in written in C. It is an XLL (let's call it
"addin.xll") that exports a set of functions. In order to implement
those functions, the add-in relies on another external DLL (let's call
it "helper.dll"), which has lots of business logic and useful routines.

Good morning,
I wish to seek advice on this procedure as in
 http://www.mvps.org/dmcritchie/excel/insrtrow.htm
I made two alterations to facilitate testing:

every time I try to rename a folder (name xxx as yyy) error 75 occurs if
the folder was opened before with
Application.FileDialog(msoFileDialogOpen). It seems that there is a
lock during the whole Excel-session. Is there away to avoid this error

This example was recently sent out and shows how to count in a
interesting way.  It involves the use of an arrau formula - something
know only in passing, but it doesn't explain how the count reference
the cells  it is trying to count over.  In the example it needs t