How can I disable the shift key during a macro ?- this inturrupts my macros. I already use error handler to block Esc, and other keys, but I cannot seem to block this one. Any help appreciated.

I am trying to gather about 200 printer's usage counts with Excel VBA code, I can get about 75 by just doing a simple query, but the rest all I get is the Web page headers.
I can see the counts by manually using URL view-source:http://printer host name and viewing the source code, but excel doesn't like it as a address. Any ideas on how to open web source code or any better way of accomplishing my task would be greatly appreciated.

I've tried your fnShellOperation function and I can get it to open an .xpt file within SAS Viewer. However, I've haven't been successful with sending keys (Control A) to the SAS Viewer window in order to paste the information back to Excel. I'm trying to automate opening of the .xpt file, coping all contents, and then pasting into Excel.

Any help would be greatly appreciated!

Getting Macro Short cut keys Addin

I can not thank you enough for the free addins you offer. It has saved me tons of time.

I need VBA code to take a list of names ("A1:A24")on sheet 1, and create a shape (rectangle, 1in. x .5in.) for each name, with the name in the shape. I need them to line up in rows on sheet6 in 6, 7 or 8 columns depending on the number of rectangles. They should snap to grid, and if one is placed over another, they should exchange positions... here's the problem.. I need them to be move-able with the mouse, but NOT have sizing handles... I've heard this can be done, but how? (This is basically a seating chart).

Edited by author 09-23-2009 12:47 PM
I am trying to link 2 pages and have the link pick up on certain Data that needs to be counted from sheet 1 and put the sum into page 2

I need information on how to get my Excel form to update to a spreadsheet. I can only get one field from my form to update.
Thanks

How to download MySpace music? Have you ever thought about extract MP3 from FLV? That’s easy, Wondershare Streaming Audio Recorder is the best tool which has been proved by many users to download MySpace music and extract MP3 from FLV. Meanwhile, want to download Google Video? Streaming Video Recorder is your best choice. YouTube Downloader is a professional one to let you download YouTube videos freely. Believe it or not, these software will surprise you a lot.

With "setting","record" and "browse" just 3 steps, you will be free to download imeem musicand then save imeem songs. Don't be just waiting, try Audio Recorder now. Sure you will like the stuff to download imeem songs and save imeem songs, enjoy them freely.

Wondershare Streaming Video Recorder is the best streaming video recorder,it can download yahoo video,download metacafe video,download dailymotion video easy.

7IQNnv

A9JPfK