Recent content by Foundy

Hi, I think you would need to do something like this. =COUNTIF(R4:R368,">"&Q371) Hope this helps.

Hi Kalle, I have just had a quick look through your code and I would suggest looking into Do While Loops a basic example is: Do while YourString <> "aValue" YourString = "aValue" Loop This would keep the macro running till it found a value. Beware though if it never finds an error it will...

You could use something like this: Sub GetAContact() Dim olApplication As New Outlook.Application Dim olNameSpace As Namespace Dim MAPIFlder As MAPIFolder Dim olContact As ContactItem Set olNameSpace = olApplication.GetNamespace("MAPI") Set MAPIFlder =...

Here is something I wrote recently thats does pretty much what you want. The problem is with Auto-Group you can only have 8 levels of grouping. The program reads through the folders and sub folders of a given folder then puts it in Excel. Once in Excel the files are broken down in to a...

Is there a way to conect to MS Office Comunicator using VBA and send an Istant message? I have tried looking all over the place for example code, but no luck. Any help would be great guys!! Thanks

I have been looking for a bit of code that allows for an excel macro to send e-mail and Fax's through lotus notes anyone with any ideas? Cheers

I have recently started using Extra! I have written a good script but now I want it to run from a button in Excel. Any Ideas Will Be Great, Cheers