Similac Recall good site to ask about your numbers

If you’re having a problem with http://similac.com/recall/lookup.aspx then you can lookup your numbers on this site that other people are posting to http://community.babycenter.com/post/a24404619/similac_recall.

Similac Recall, Lot #91542T20 Powder 1.45 lbs

My wife and I have confirmed that the above lot number HAS been recalled.

Looping through Content Controls in a Word Document

Code Snippet

1. For Each contControl As Word.ContentControl In ThisAddin.MyAddIn.Application.ActiveDocument.ContentControls
2.     'Do something with contcontrol
3. Next

He will probably be bored with this job!

Lately I had an opportunity to interview with a great company.  The Vice President of IT was tremendously impressed with my credentials and seemed eager to have me join their team.  During the interview he stated that I would probably be bored with the job at hand.  I told him that for several years now I have been working jobs which were ‘heads down’ and required no critical thinking, problem solving or creative thought of any kind and that the job they were offering would be a pleasant change from the jobs I have been working in for years. Needless to say, I have only heard back from the recruiter once claiming again the company thought I would be bored with the position and the recruiter told me the company was wavering on the contract to perm price.  That’s the last I heard of it.  I sure wish more people would have the balls to pick up the phone and call someone to let them know they’ve been rejected rather than just not calling.  It would have been nice to work for them but oh well, I digress.

Not all Structured Document Tags are created equal! (Continued)

Every Sdt must contain SdtProperties.  So the solution was to get the OpenXmlElement of DocumentMainPart.Document then get the Descendants that are SdtProperties. For example:

Code Snippet

1. Dim opnXMLElement As OpenXmlElement = newDocMainPart.Document
2.             For Each sdtProperty As SdtProperties In opnXMLElement.Descendants(Of SdtProperties)()

Then the parent of sdtProperty (as shown above) MUST be one of the types we are looking for so I run this check:

Code Snippet

1. Dim sdtContentCell As SdtContentCell = Nothing
2.                 Dim sdtContentBlock As SdtContentBlock = Nothing
3.                 Dim sdtContentRow As SdtContentRow = Nothing
4.                 Dim sdtContentRun As SdtContentRun = Nothing
5.                 Select Case True
6.                     Case TypeOf sdtProperty.Parent Is SdtBlock
7.                         sdtContentBlock = sdtProperty.Parent.GetFirstChild(Of SdtContentBlock)()
8.                     Case TypeOf sdtProperty.Parent Is SdtCell
9.                         sdtContentCell = sdtProperty.Parent.GetFirstChild(Of SdtContentCell)()
10.                     Case TypeOf sdtProperty.Parent Is SdtRow
11.                         sdtContentRow = sdtProperty.Parent.GetFirstChild(Of SdtContentRow)()
12.                     Case TypeOf sdtProperty.Parent Is SdtRun
13.                         sdtContentRun = sdtProperty.Parent.GetFirstChild(Of SdtContentRun)()
14.                     Case Else
15.                         'Nothing
16.                 End Select

Now I have the actual Sdt Content I am looking for and I can do whatever replacement I need to do.

Not all Structured Document Tags are created equal!

Depending on the location of the <w:sdt> tag, the actual type of the tag could be different.  For instance an sdt tag inside a table could be an SdtContentCell or SdtContentRow depending on its position.  I’m currently working on an idea to identify a structured document tag, stay tuned.

Why is it so hard for companies to standardize contracts and forms?

Currently I’m working on a project where we create components of contracts using a Word Add-In.  But for some reason this company’s principals cannot decide on a standardized contract.  I realize there may be differences in contracts based on something such as country, but really! Do you really need to have end users enter in custom fields with information specified by a particular client, really? Instead of looking up to something we can be proud of, we’re headed down a slippery slope of wasteful time and money.