Hi,
I have columns in one excel workbook and I need to move them to a 2nd workbook. Would it be ok to use the internal VBEval>GetCell() to do this?. The cells are e3 to e30 and some different in other columns, is it possible to copy e3-e30 using VBeval>GetCell?.
Thx,
John
Newbie Excel query
Moderators: Dorian (MJT support), JRL
-
Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: Newbie Excel query
VBEval>GetCell implies a VBScript function called GetCell. That isn't internal.
For "internal" functions you could use a loop with XLGetCell and XLSetCell. XLGetCell to get the cell from the first workbook, XLSetCell to set the second. Loop through each row.
Or record a macro inside Excel which performs the copy. Then if needed, convert that VBA macro to a VBScript macro which runs inside Macro Scheduler:
http://help.mjtnet.com/article/19-conve ... o-vbscript
For "internal" functions you could use a loop with XLGetCell and XLSetCell. XLGetCell to get the cell from the first workbook, XLSetCell to set the second. Loop through each row.
Or record a macro inside Excel which performs the copy. Then if needed, convert that VBA macro to a VBScript macro which runs inside Macro Scheduler:
http://help.mjtnet.com/article/19-conve ... o-vbscript
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
