Search found 4 matches
- Thu Mar 27, 2014 8:02 pm
- Forum: Technical / Scripting
- Topic: VBScript - using macro %varname% to pass values
- Replies: 2
- Views: 3830
- 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...
- Tue Mar 25, 2014 10:28 pm
- Forum: Technical / Scripting
- Topic: Getting and Setting the values of Excel Dropdown controls
- Replies: 1
- Views: 2556
- 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 ...