How to output redirect to a cell in a spreadsheet and location based macros.

[ussenterprise]

First - you need clip.exe (appears to be included in Windows 7)

(Edit)

Second, you need to have a clipboard clear function added into a separate module:

Please Login or Register  to view this content.

The above code is referenced here.

Second use the following macro:

Please Login or Register  to view this content.

You can get more complicated by using my location based macros:

Please Login or Register  to view this content.

Where button is in Cell B2, C2, D2, E2, B16, C16, D16, E16, etc... All buttons will have the same macro...
What is important is where these point:
From the button location, + 7 is the IP Address. and + 11 is where I want the output. Or, 11 rows down from the button (x13).

[ussenterprise]

Okay... after testing (What can I say... I was EXCITED!), this is a little buggy. It looks like the clipboard has issues. I am attempting to work on clearing the clipboard via macro.

This was apparently related to the If and ElseIf statements. As a single macro, it works okay. See post below for how this was fixed.

[ussenterprise]

Added a clipboard clear function (Thanks to JBeaucaire for locating one!).

[ussenterprise]

I'm calling this as solved. Thanks very much to Leith Ross for an explaination of how VBA works! This allowed me to come up with something a little different with the assistance of a co-worker.

Please Login or Register  to view this content.

Note that I have added a row. So, these variable will not match up with the variables in the original post. If you've followed along with the location based macros, I'm sure you'll be able to spot it!

Enjoy!