Archive for the ‘tips’ Category

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

Tags: ,
Posted in tips | No Comments »

False rumors could teach you lots

Friday, November 20th, 2009

Here is an idea.

What if you didn’t trust someone to keep a secret?

Just tell them something totally false about someone else.

Then sit back and wait to hear back from the person you spread the rumor about.

When you do. Explain how you were just testing the other person’s discretion.

Oh…

I guess that won’t work either. Then no one will ever trust what you say.

Somehow things  always makes so much more sense when you wake up from a dream.

Posted in Uncategorized, tips | No Comments »

Network unavailable BUT is…

Saturday, October 3rd, 2009

After uninstalling Symantec 360 network connectivity is no longer possible.

However I was able to connect via a virtual machine to the network and internet which was running inside this machine.

The ultimate cause of this was that the Symantec uninstall via the windows add remove programs process fails and leaves crap lying around.

If your Symantec subscribtion  expired and you tried to remove it you will have a networking  problem.

Download the removal tool and it cleans everything up.
Symantec Removal Tool

Tags: , ,
Posted in tips | No Comments »

SOBI2 Joomla and https image problem.

Friday, September 25th, 2009

Installed Joomla with SOBI as a directory module available at

http://www.sigsiu.net/

  1. on the menu  select Components
  2. Sobi2>General Configuration
  3. Entries & Categories Configuration

You can try to change the config key “use_mos_conf_livesite” in the section “compat” in registry editor.

I changed that value from 0 to 1 and it worked.

I found help here:
Article referencing this at www.sigsiu.net



Posted in tips | 1 Comment »

Open url in specific Browser

Tuesday, September 8th, 2009

You may have run across sites that require you to use a specific browser to run correctly.

For example Netflix offers instant streaming movies, but you have to use internet explorer. If you forget, you are prompted to open it instead. If you use a different default browser you likely have to go through the hassle of closing and reopening the site in a different browser.

Why not just create a shortcut which does that for you?

Right click your desktop.

Create new shortcut and type the following in the ‘location of the item’ (or substitute wherever you have ie installed)

Make sure to include a space between the browser application executable and the site name.

“C:\Program Files\Internet Explorer\iexplore.exe” http://www.netflix.com/

create shortcut

finish shortcut

This will work for other browsers as well, just substitute the browser application location in front of the site address you want to open.

Posted in tips | No Comments »