Search found 4 matches

by mkroeger
Thu Mar 27, 2014 8:02 pm
Forum: Technical / Scripting
Topic: VBScript - using macro %varname% to pass values
Replies: 2
Views: 3830

Yes! Thanks that works.
by mkroeger
Thu Mar 27, 2014 3:55 pm
Forum: Technical / Scripting
Topic: VBScript - using macro %varname% to pass values
Replies: 2
Views: 3830

VBScript - using macro %varname% to pass values

I have been searching for examples, but have not found any... So I shall pose the question here: I am creating a simple piece of code that will copy values from one excel sheet to another. I have this working fine using the Excel functions(XLOpen, XLGetCell, XLSetCell, etc). Now I am trying to conve...
by mkroeger
Tue Mar 25, 2014 10:28 pm
Forum: Technical / Scripting
Topic: Getting and Setting the values of Excel Dropdown controls
Replies: 1
Views: 2556

Duh! :oops:
Guess I could just do all the copying in vbscript! that would solve the control problem of which method has the files open at what time!!!
by mkroeger
Tue Mar 25, 2014 9:34 pm
Forum: Technical / Scripting
Topic: Getting and Setting the values of Excel Dropdown controls
Replies: 1
Views: 2556

Getting and Setting the values of Excel Dropdown controls

My goal is to write a script that copies the values of cells and objects in one existing excel sheet, and transfers/pastes them to another existing excel sheet. Not a complete copy/paste, but selectively. I have successfully written the script using XLOPEN, XLGetCell and XLSetCell. These work great ...
Sign up to our newsletter for free automation tips, tricks & discounts