Try this:

Sub DeleteSheets()
dim xl as new excel.application
dim wb as excel.workbook
set wb=xl.workbooks.open("c:\test.xls"
xl.application.displayalerts=false
If...

Here is another way of doing it. After you populate your excel file with all the records. Run this function.

Public Sub InsertRows()
Dim xl As Excel.Application
Dim wb As Excel.Workbook
...

Which version of excel are you using? And are you on vb6 or vb.net?

Whats the error?

Use this
xlWksht.Range(i + 1:1).Insert(Shift:=xlDown)

instead of xlWksht.Cells(i + 1, 1).Value = Chr(10) 'Add a blank line after each record.

Let me know.

Also let me know if you can take care of the popup reminders.

I would suggest the popup reminder to be part of VB6 app and not within Outlook. So when the user gets the reminder he can select from the list and click the send button and it will trigger the email...

If you are ready to pay then its fine with me. But i can surely help you integrate Outlook with VB. Give me a rough spec and i will see what i can do.

You can change the form name "frmSystray" to your main form name. and also add a button named "cmdAddIcon" on your main form. When you click this button your form would goto the Tray Icon

please visit this site and login to see the free download. click here (http://www.coderewind.com)
Iam working on the code to share it on this site.

well, when you say messages do you mean regular email or chat messages?

means, what exactlydo you want to do?

SELECT *
FROM tblusers
WHERE (name = 'Martin' and StrComp(tblusers.name, 'Martin', 0) = 0);

Note: You can replace the parameters with any variable instead of giving constant values to compare.

ok! for ms access database the previous SQL COLLATE statement wont work, that's why you were getting the error.

For MS Access you have to do like this:

Select * from tblusers where name =...

Just a flash back. Are you using MsAccess Database? You can find SQL Query Analyzer only if you have SQL Server installed on your machine. Iam guessing at this point that you dont have SQL server...

You can check the SQL version by opening Query Analyzer and click on "Help" --> "About"

Also send me the error message.

Use this query and it should definitely work

Select * from tblusers where name COLLATE Latin1_General_CS_AS = 'Martin'

WHich version of SQL are you using?

well the ideal way to handle this is follow a uniform data storage in the database, that will give more control over the database.
You should always follow proper casing when storing the data back...

Depends on what you wnt to achieve, They are two different approaches to present the data and controls.

SO you mean to say that the function should treat the upper nad lower case word as two seperate words? Can you be nore specific. I can help you if you explain a bit.

Let me know what do you want to implement. We can even Zip and FTP also using VS 2005.

you have to add the structure of that API also when you add the API itself.

yes definetely this can be done?
If you want i can write the app for you. let me know.

This icon position is usually called the Tray Icon. To do this you have to make use of some API calls. You have to use Shell_NotifyIconA() to set the Tray Icon. This is how you set the tray.
...