On 4/25/2016 11:19 AM, GS wrote:
That definitely helps, thanks GS.

Glad to help!
Being a VBer yourself, you'll find working with VBA an easy transition.
Be aware, though, that as of Office 2010 the macro language is VBA7 for
both x32/x64 versions.
FWIW
I use fpSpread.ocx to duplicate my Excel apps as stand-alone Win apps
(VB6.exe). The same code is mostly used for both, changes being how
object refs are handled. Working with a spreadsheet is pretty much same
as working with a grid control. Excel is just a glorified grid control
(IMO) with its own set of methods, properties, and functions. One
feature you may find valuable during your transition is the Macro
Recorder. While the code it generates will always need cleaning up, it
will point you in the right direction in terms of learning the Excel
Object Model.

Yes VBA is pretty easy to get quickly, that was a great feature for MS
to add to the office suite.

I ran into the 64 bit issue with a FindWindowLike module I had used on
32 bit machines, found this page so I could get he function declarations
right. I haven't had a lot of programming jobs doing this but that may
change soon, so this is good stuff to know.
http://www.jkp-ads.com/articles/apideclarations.asp
I know where to come if I get stuck :)
I'll check out the macro recorder, I've never used it but it sounds like
it could be quite useful.

Thanks again for all of your help, I'm going to show the updated sheet
to the manager Friday and see how she likes it, I think she'll be
pleased seeing all of her ideas implemented and working.

Best Regards,
Mike