Help with IF Function

[Scottymelloty]

Hi there, new to this and very grateful for any help or advice

Ive recorded some macros that work fine but i want to run these macros when something on my excel spreadsheet reaches a certain figure,

ie when column b2>5 on my spreadsheet i want it to run macro1 from the scheduler

How do i this please

Many Thanks

[Lumumba]

Traditionally (as I'm not familiar with MSched's new features ) I would use

DDERequest>Server,Topic,Item,Result,Timeout

Requests data from a DDE server. The data returned is stored in the Result variable. If the conversation does not complete within the Timeout value specified, Result will contain 'DDE_TIMEDOUT'. The Timeout value is in seconds.

Once you've grepped the value from the relevant field you could run or shutdown MSched's script. But I would prefer to parse the file for that specific value as DDE needs an open (Excel) document/sheet to be able to "comunicate" with it.

[Guest]

Thanks for the help, i'll have a play around with it, as i said im a complete novice and find it all a bit confusing at the mo but will give it a try, many thanks