11/9/2026 6:31:52 AM
|
| |
| 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!
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.
|
|
|
|
VB Script Load up the Clipboard
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??? |
|
|
| |
|
Re: VB Script Load up the Clipboard
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....
|
|
|
|
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!
|
|
|
|
|
|
|
|