Can anyone tell me how to do a basic SendKeys script for the picking sheet printing window?
I tried and I can't get it to work. Not really familiar with scripting, but this seemed like it would be easy.
Can anyone tell me how to do a basic SendKeys script for the picking sheet printing window?
I tried and I can't get it to work. Not really familiar with scripting, but this seemed like it would be easy.
If you are trying to automate printing/exporting of a picking sheet, you are better off using the BOI (Business Object Interface).
SendKeys can work but can be unreliable and cause unintended results if…
If this is a UDS script (executing on either a table or UI event), the script is always going to execute on the server.
If this is a button script, you have to set it to execute on the client.
If you are trying to automate printing/exporting of a picking sheet, you are better off using the BOI (Business Object Interface).
SendKeys can work but can be unreliable and cause unintended results if focus is moved inadvertently.
Here is a link for more info on SendKeys.
https://ss64.com/vb/sendkeys.html
Since Sage 100 uses a lot of keyboard shortcuts with the ALT prefix, whereever you see a button with an underlined character, such as the Preview button, you would use something like this.
Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.SendKeys "%v"
If you are going to use the BOI, refer to some of the posts on this forum on how to print forms via BOI. If you are only ever doing a single sales order at a time, this is simpler as you can use the quick print property otherwise if doing a range, you have to incorporate quite a number of more lines of code to properly select the orders.
Here is a good starting point if you are going to use BOI.
This post has the QuickPrint property being used.
I just want the 'Warehouse' field to be filled in automatically
If you use a form code other than "STANDARD", I believe the previous value should be saved (by user / workstation)... no scripting required.
That's not the case. It will save any of the checkboxes that you select, but not anything in that grid.
My script is working, but it is sending the keys to the server, I need them to go to the workstation.
How do I set this?
If this is a UDS script (executing on either a table or UI event), the script is always going to execute on the server.
If this is a button script, you have to set it to execute on the client.
*Community Hub is the new name for Sage City