Wednesday, January 7, 2009

Excel Macro / VBA Craziness

A client got me to do some weird work in Excel last year to format a horrid output from their main software they use. Seems the "excel file" that was output from the software for their price list was none-to-user-friendly... So, I created a couple macros that renamed some stuff, deleted some unnecessary rows and columns, and voila.

Today, the same client asked for another bit-o-code. 8 hours later, I've got soem decent stuff. I learned about NumberFormat, text alignment, borders. and a couple other neat tidbits this time around. If I was really cool, I'd probably re-write the older stuff to make it a little cleaner, but........

Now I just have to figure out if I should charge for the work ;)

FACTS-Fix.xls

Labels: , ,

Tuesday, December 2, 2008

Silly Microsoft....

Turns out that with Exchange 2007 and Server 2008 there's not a native way to backup exchange and truncate your log files...........

Silly.... Silly Microsoft...

Labels: ,

Tuesday, November 25, 2008

Outlook Spelling Troubleshooting

Client:
says his spell checker when doing an email in Outlook isnt catching mispelled items? any clues?


Me:
Depends on what he means:

- "It used to make the little red squiggles under a misspelled word like in Word"
- It'll only do that if Word is the e-mail editor. "Tools" -> "Options" -> "Mail Format" -> "Use Microsoft Office Word to edit e-mail messages". Note - I'm not a fan of this personally... It makes e-mail slower ;)

- "It doesn't automagically check spelling when I send the message"
- "Tools" -> "Options" -> "Spelling" -> "Always check spelling before sending"

- "It's not catching this word..."
- "Tools" -> "Options" -> "Spelling" -> "Edit" under 'Edit custom dictionary'

- "It's just flat out not working!"
- Something else is broken ;)

Labels: ,

Friday, November 21, 2008

XP's Offline Files...

Ever have problems with XP's offline file functionality? I know I have. It always seems to take forever, it's slow to decide when you're offline (making apps lock 'till you're offline), it's slow to realize you're back online (I always ended up just forcing a sync), and it doesn't play nice with 3rd party VPNs. Regarding that last note, I use OpenVPN (http://www.openvpn.net ; http://www.openvpn.se). It's been a while since I looked, but there may be some configuration options you can use to call a local batch file on connecting/disconnecting where you can then call 'mobsync' with some command line options, but..... That's just too much hassle ;)

Instead, I've been liking a 3rd party product for syncing my data. It's called GoodSync. I set up a few jobs -- one for each separate location, and tell each to run at startup and every 2 hours. Seems to do the job quite nicely.

Labels:

Thursday, November 20, 2008

A quick Exchange 2007 rant

Ardent and I were chatting yesterday and as I had just finished trying to figure out some recipient address policies, I ranted a little... It turned out funny, so I figured I'd share:

(11:13:08 PM) Me: now all you need to do is explain to my why exchange 2007's moved to a more scripted approach vs gui
(11:13:22 PM) ardent: for what
(11:13:31 PM) Me: it's like they decided to do everything via scripting, then made the [limited] gui after the fact
(11:13:34 PM) Me: everything
(11:13:44 PM) ardent: because real coders hate gui
(11:13:48 PM) ardent: its more 'stable'
(11:13:49 PM) ardent: :-)
(11:14:16 PM) Me: take recipient address policies -- in 2k3, you had a text field to type in what you wanted an address template to be
(11:14:40 PM) Me: in 2007, you've got about 6 radio boxes to choose from. If that's not what you want, you've gotta use the undocumented powershell commands
(11:14:55 PM) Me: and real coders don't administer exchange ;)
(11:15:01 PM) ardent: hahahaha

In case you're wondering how I ended up setting an address template to get .@domain.tld, via powershell I ran "get-emailaddresspolicy fl". That showed me where the not quite right template that I had added via the gui was. After trying a couple things and getting errors, the final command I ran to update the default policy was 'Set-EmailAddressPolicy -Identity "Default Policy" -EnabledPrimarySMTPAddressTemplate %1g.%s@domain.tld'

Labels: ,

Thursday, November 13, 2008

Linksys troubleshooting

One day I plan on writing up a quick set of instructions on how to set up a Linksys WRT54g Pro IT style. It's easy enough to set one up without needing to run their weird CD, and quite possibly leaves you in a better situation.

With the idea of documentation in mind, when a client e-mailed me this morning about their connection issue at home using the above setup, I wrote a horrendously long set of troubleshooting steps. It's really only four quick things to check, but I tried to write it fairly low-level / in-depth. Of course, it was also written pretty quick, so it's not the best of documentation, but hey -- it's a start ;)

The setup (iirc) is using the linksys as a router/gw for the client's home network.

-------

Well, I guess there's a few things you could try / check....

1st -- verify how things are plugged into the Linksys router. Make sure that there's a cable from the 'internet' port of the Linksys to the cable modem. If everything's wireless, that should be the only network cable. If your PC in your room is connected via wired, it should be plugged into one of the 4 'LAN' ports on the Linksys.


2nd -- ping a couple key things.... "Start" -> "Run" -> type 'cmd' -> "OK". In the black dos window that comes up, type "ipconfig" and hit enter. That'll give you something like:

-------------------
Windows IP Configuration
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . : carolina.rr.com
IP Address. . . . . . . . . . . . : 192.168.5.100
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.5.1
-------------------

You may see something like "Media State . . . . . . . . . . . : Media disconnected" for one or two adapters. That's fine. As long as you see one that has a default gateway set. The "Default Gateway" in the example above is "192.168.5.1". I'd want to make sure I can ping that gw (gateway). In that same dos window, type "ping 192.168.5.1" (replacing "192.168.5.1" with whatever your gateway is). You should get four responses that look one of two ways:

Reply from 192.168.5.1: bytes=32 time<1ms TTL=64

-- or --

Request timed out.

If it's the latter, there's something wrong with the Linksys.


3rd -- Assuming you can ping the Linksys, open a web browser and in the address bar, type the gateway address from above (192.168.5.1 in the example). It should prompt you for a username and password. The username is 'admin', and if it's default, the password is either 'admin' or 'password' (I'm breaking my rule of not e-mailing passwords, but it's a default password, so crackers could just look it up if they wanted to -- and they'd have to be on your internal network to get to that management interface). If it's not the default password, try a few of yours. Once you're in (assuming we found the password), go to the "Status" page (far right on the top row of menu items). It should note the IP address, subnet mask, and default gateway that is assigned to the Linksys. Note that default gateway. That's the next address we want to ping. If you don't have an address there, either a) TW's modem's not handing out address properly, b) the cable/connection is bad between the modem and the Linksys, or c) something's not right with the Linksys (broken, cable plugged in the wrong place (see 1st suggestion), not configured for DHCP, etc).
Assuming all looks right, back in the dos window, type "ping 24.5.6.1" (replacing 24.5.6.1 with whatever the gateway was on the Linksys status page). It may be easiest to drag/move the dos window to an area of the screen such that you're able to read the Linksys page behind it. Again, take note of the ping replies. If you get "Request timed out", I may blame it on the Linksys. It may not be NAT'ing correctly or something...


4th -- Last, try pinging the DNS servers noted on the Linksys status page.

Well, that's quite the list of things to try, so -- let me know how that goes and we'll figure out more from there ;)

Mike Jolly

Labels: , , ,