Recent content by swandro

I have no experience of working with server based Outlook, but I would expect your mailbox to feed your emails into an Inbox inside the PST file that has been set as the default. You can then create your extra PST/OST databases and then use rules to make Outlook automatically transfer emails...

There are 2 things you can do. Firstly I hope you occasionally compact the PST database - the function can be found (admittedly well hidden!) in the Data File Management tools. More importantly, you can have as many PST files as you want. By default Outlook created one called "Personal...

smotass.com has thousands of links to other sites. A lot of them are commercial but not all.

Microsoft OneNote is an excellent tool for storing "stuff". I use it all the time.

Just curious - does anyone know much about Jim? I looked on Amazon and there are books by James Sloman - Handbook for Humans for example. I note that the publisher is Ocean Blue - is this a coincidence or is "our" Jim the same Jim as this author? OK - I can answer my own question - he IS...

Could you explain this in a bit more detail? Genuinely curious. Many thanks

Here is an example. If this formula was in cell D7 =IF(C7=60,OFFSET(D7,-4,-2),"") Then it is saying: If the value in C7 is equal to 60, place in D7 the value identified by the offset, otherwise put a blank in D7. What does the offset point to? It takes D7, moves -4 rows up (a...

Sorry Silvermotion - let me rephrase the question. What is your association with TTWMacciT3? I was interested that you signed your first message as Gabriel H. And the author of the Quick reference Guide to TTWMacciT3 is, errrrr V 1.00 July 9, 2007 By Gabriel Harbour ...

Silvermotion - just for the record - can you confirm that you are the same Silvermotion who owns ttwmacci.com?

http://ta-lib.org/

I cannot answer the question directly but I can point you in a direction you may want to research. Some vendors have produced Excel addins that implement the FIX protocol - this is a standard used for sending market orders to brokers. Through an internet search I came across this one -...

It can definitely be done with a bit of VBA. Unfortunately I am too busy at the moment to write it for you but this is what you need to do: You will need to keep the last checked time in a cell somewhere. In the Worksheet_Change event for Sheet1, put some code that does the following...

This may be a very obvious point to make but one of the best ways of speeding things up is to do the calcs inside a VBA routine rather than on the sheet. You can copy a whole range of data into an array in one single instruction. Then you can loop down the data doing whatever. Then it is a...

On the subject of calculating Easter, the following Excel worksheet formula is published in Walkenbach's Formula book. Even Walkenbach cannot explain how it works!! The 2007 is mentioned twice and is the year for which the calculation is required. It gives 8th April 2007 for this year...