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: excel, vba
Posted in tips | No Comments »
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.
Tags: DNN5, gmail, google apps, issues, smtp
Posted in Uncategorized | No Comments »
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 »
November 20th, 2009
I woke up from this incredible dream.
They started calling me up, and started to pay me to go on TV. People wanted to know what I think about things. They even cared about what I said.
It was amazing. I was making thousands of dollars a day, just for having the opinions I have. Just have an opinion, and all of a sudden you are in the money. Doesn’t matter if you know what you are talking about. Just having media attention makes your opinion worth something.
Like I said, it was a dream.
BUT it made me wonder…
How do people get to be pundits?
I already know how to have my opinion, so call me up and hire me.
I am waiting.
Posted in Uncategorized, opinion | No Comments »
November 20th, 2009
After wasting literally hours, changing folder views again and again and again, in Windows Vista.
Views never seem to adhere to your preferences, as they had in XP.
If you are used to applying a specific view, such as details, in explorer, you have to be frustrated by it not working as you expect.
I came across this great explanation, which actually does clarify the problem and solve the issue.
from http://www.computerperformance.co.uk
… and then you can get back to you can work again
Posted in Uncategorized | No Comments »
November 12th, 2009
Not quite sure what the impact is, but I have noticed that the way lots people get there kids to take a nap or go to sleep,is to drive them around in the car.
I wonder what the cumulative energy consumption is for getting kids to sleep.
Plus taking them to school everyday. No one can walk.
I would imagine that no one even thinks of this, it just happens.
Posted in Uncategorized | No Comments »
October 9th, 2009
Recently I have read articles discussing the dilemma AT&T faces with their cell phone network. Supposedly 3% of their users, are consuming 40% of their network capacity.
My first inclination is to see them preparing to raise data cost plans to something tiered.
They obviously have huge problems with smartphones, such as the iPhone.
BUT who caused the problem?
They literally forced fed everyone purchasing an iPhone a data plan.
They gouged an extra 30+ dollars out of every person wanting the technology.
Try to buy an iPhone without a data plan. You can’t.
So they roped a whole group into HAVING to pay for data, then they are surprised that they actually USE it?
If data was never an included, forced, feature, many of these people would have perhaps fallen back to wifi networks for access.
Apple and AT&T regularly portray themselves as concerned about a good customer experience. Yet, their devices uselessly roam cities daily. The desire to lock in revenue subscriptions, and forced data plans has partially caused the problem. The next complaint will be that since no one can make a phone call, text messaging is choking the network.
The cause of the problem is a policy which generated use to justify the cost being charged.
The solution is non-exclusivity. If AT&T can’t handle the network mess they created, allow competition to handle the details.
If the 3% of users using 40% had options, many would not stay on AT&T’s network at all. Problem solved.
Quit the blame shifting AT&T
Posted in opinion | No Comments »
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: Errors, Networking, Symantec
Posted in tips | No Comments »
September 25th, 2009
Installed Joomla with SOBI as a directory module available at
http://www.sigsiu.net/
- on the menu select Components
- Sobi2>General Configuration
- 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 »
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 »