Sub: load speadsheet from Excel via Objects

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I needed a way to drop a spreadsheet into an Accuterm and made this subroutine to handle that. This is a hello world program for application object mode so I'd appreciate feedback about improvements.

This subroutine opens the Excel application; loads the spreadsheet without showing it on screen; selects the whole spreadsheet; copies it to the clipboard; pastes the clipboard into the passed AT grid.
Limitations: The AT program really needs to wait until the copy is complete, but I couldn't find an object event I could use to insure that. I'm using RELEASEOBJECT for the Range and Worksheet objects to get close without un-needed delays along with a short SLEEP .1 delay as a hack that's working. If someone with Object Manager experience has a better way I'd love to hear it.

Comments in the bottom have a link to Microsoft documentation for the object methods and properties, as well as the object syntax for some sample calls

uploads/1657/AT.EXCELOPENCOPY.txt.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
SeanC Members Profile Find Members Posts Newbie Joined: July 06 2021 Status: Offline Points: 8	Post Options Post Reply Quote SeanC Report Post Thanks(0) Quote Reply Topic: Sub: load speadsheet from Excel via Objects Posted: July 11 2022 at 6:36pm
	I needed a way to drop a spreadsheet into an Accuterm and made this subroutine to handle that. This is a hello world program for application object mode so I'd appreciate feedback about improvements. This subroutine opens the Excel application; loads the spreadsheet without showing it on screen; selects the whole spreadsheet; copies it to the clipboard; pastes the clipboard into the passed AT grid. Limitations: The AT program really needs to wait until the copy is complete, but I couldn't find an object event I could use to insure that. I'm using RELEASEOBJECT for the Range and Worksheet objects to get close without un-needed delays along with a short SLEEP .1 delay as a hack that's working. If someone with Object Manager experience has a better way I'd love to hear it. Comments in the bottom have a link to Microsoft documentation for the object methods and properties, as well as the object syntax for some sample calls uploads/1657/AT.EXCELOPENCOPY.txt.zip