Every now and then when working with MS - the feeling I get is like....

It is not cheap.... but my preference is Camtasia Studio. Get the package with Snagit (USD$325). I use these tools every day! We have folks using way more expensive products with a recording/production studio in my office (it is their full-time gig) and I put out content faster than they do and at c...

It would be soooo nice to have a notes option for each macro - and be able to display it in the Macro list view. Something that would allow you to take better notes about the macro, its purpose, client name etc. There is a fair bit of realestate in the window now and no option of adding columns to t...

I had posted a question in another one of the groups - and got a fantastic answer I have a list of individuals that I need to randomize the order of... Bob,Mary,Bill,Thomas,Jack,Jimbo All I need to do is put them in random order in a new string. I thought this would be easy.... the code I have found...

When I complete my solution I will post it all here - as long as nobody gives me too much grief for my coding skills... My first cut got the time down from 8 hours per month to 25 minutes. And considering the individuals doing the schedule were SENIOR physicians - you can imagine the cost savings th...

change let>teller=0 into let>teller=-1 and then the bug is exterminated ... i hope... :D That did not work entirely for me - the incidents of only 5 items in the list were as follows: Trial 1 - 4/100 had only 5 items after the shuffle Trial 2 - 2/100 Trial 3 - 9/100 It was the third line below you ...

AWESOME! You have no idea how long this took me.... I should have posted sooner. So much more elegant than what I was doing (or rather trying to do). You ever take on a project and it is FAR more complex than you thought? I am trying to optimize the shift schedules for a group of employees. And then...

I have a list of individuals that I need to randomize the order of... Bob,Mary,Bill,Thomas,Jack,Jimbo All I need to do is put them in random order in a new string. I thought this would be easy.... the code I have found in the forums is a little difficult to follow. Any ideas? EDIT: A GREAT feature f...

Works like a charm! Thanks.

Thanks Marcus.... here is an extract of the relevant lines. A few caveats: - it is probably way to complicated - as I am a business guy - not a coder - I know I should use subroutines - I tend to write my first proof of concept in a linear format - then start fresh and write it tight The following a...

I am extracting the text from an Excel cell doing some manipulation and then writing it out as a line to an XML file. When I try and validate it using http://xmlvalidation.com/ it tells me there is a problem with a character.... The validator tells me it is "Unicode: 0x1" I have tried pasting the ch...

That works! Thanks

Rain wrote:Try

Code: Select all

Let>strLine=blah blah blah), A. Fitzsimons (XX), C. Gannage (YYY)
Position>),%strLine%,1,dPos,FALSE
mdl>dPos

I am trying to find the position of a substring in a string. I am looking to find the position of the "close bracket comma space" i.e "), " Let>strLine=blah blah blah), A. Fitzsimons (XX), C. Gannage (YYY) Position>), ,strLine,X,dPos,FALSE I get an "error in position command". It would seem like the...

For the past few months I have been using the gravatar service (http://www.gravatar.com) so I do not have to keep updating my avatars on various sites. Your avatar is referenced through a link which uses a hash of your email address. This way any site that has your email address can potentially pull...