Thank you Marcus. I am sorry if I wasted anyone's time here. I appreciate the advice.

Have a great day

Tom

Thanks so much for taking the time to reply. Much appreciated :) Basically the VBA macro has already been written for some time and functions perfectly within Excel and the variables already exist within that code. I was just trying to enhance things with MS but the MS portion represents a "nice to ...

Hi everyone. I've got an Excel Spreadsheet which contains different values that I'm loading into two variables in VBA (an integer counter and an array). I'm trying to pass those variable values from the VBA within Excel to a script in MS which will call a third party application and transfer the var...