slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: VB Script Load up the Clipboard

RJ Samp
Posts: 973

VB Script Load up the Clipboard Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Jul 08 10:19 AM

1. Without an activeX control field in SLX
2. Preferably without a special DLL
3. May not have IE 6

Am getting inconsistent results with this (M is a massive String of text data):
DIM oSHELL, objHTM
set oShell = CreateObject("WScript.Shell")
Set objHTM = CreateObject("htmlfile")

objHTM.ParentWindow.ClipboardData.SetData "text", M
'paste it into Excel.
objExcel.Range("A2").SELECT
objExcel.ActiveSheet.Paste
set oShell = Nothing
Set objHTM = Nothing

Any other ideas???

[Reply][Quote]

Phil Parkin
Posts: 819

Re: VB Script Load up the Clipboard Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Jul 08 8:49 PM

So where does this go wrong? And what are the symptoms? How big is M?

Phil

[Reply][Quote]

RJ Samp
Posts: 973

Re: VB Script Load up the Clipboard Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Jul 08 2:15 PM

M is huge.....I just gave up and am assuming they have IE 6 (required per SLX Sales non web client anyways!)....and of course EXCEL.

''''put the string into the windows clipboard.
DIM oSHELL, objHTM , MText

MText = "Lots of Data here, as much as you need.....could go on forever (put CHR(9) and CHR(13) in between fields and data rows!!!) "

set oShell = CreateObject("WScript.Shell")

Set objHTM = CreateObject("htmlfile")

objHTM.ParentWindow.ClipboardData.SetData "text", MText

That loads up the clipboard....

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/24/2025 11:37:26 AM