Archive for June, 2010

build a string in excel vba and paste to cell range

Tuesday, June 29th, 2010

In cases where a cell range is looped through to create a filtered version , or re-ordered content.

I used to assign the string value to a textbox in a hidden form, then copy/paste that to a cell to get a result that spanned multiple cells and didn’t just all dump into one cell.

instead I now do this using the Form datatobject

thisString = OUT_HEADER + thisString
Dim DataObj As New MSForms.DataObject
DataObj.SetText thisString
DataObj.PutInClipboard
            thisString = OUT_HEADER + thisString

            Dim DataObj As New MSForms.DataObject

            DataObj.SetText thisString

            DataObj.PutInClipboard
then paste it somewhere
            Range("A1").Select
            Sheets(startSheet).Paste
esentially the same thing simplified and without an actual form

Getting past email settings in DNN5+ with a google apps mail account

Tuesday, June 15th, 2010

DNN Just installed 5+ using the web installer from MS. Was stuck on the mail settings and I use a gmail smtp.

So the correct way to get around it was to enter smtp.gmail.com:587  http://mail.google.com/support/bin/answer.py?hl=en&answer=13287

I tried no port  with SSL checked and appended :465 with SSL checked so :587 with SSL checked and the whole email account address.

That at least gets me on to the next steps.