make excel 2008 default for spreadsheets mac

#Make excel 2008 default for spreadsheets mac how to#

The idea is the user will click the “play macro” button on the emulator window: When your new script is finished, your users will be able to create a spreadsheet from the emulator with just a few clicks. I will also present a few tips for how the script can be modified to read a value from the screen so that the query can be dynamically customized to select relevant data. leverages the Excel library to create a spreadsheet and transfer the data from the query into the spreadsheet.queries the tried and true QIWS/QCUSTCDT sample table.uses ActiveX Data Objects (ADO) to establish a connection to the database.To demonstrate how this works, I’m going to present a simple script that: ” These PCOMM macros can only be fired by an emulator user. As an aside, a reader of Part 1 inquired if this technique is accessible from an RPG program and the answer is an unfortunate “no.

#Make excel 2008 default for spreadsheets mac how to#

It also instructs you how to get started in writing a script and how to “scrape” a value from the current 5250 emulator screen. I want to build on that short tutorial by demonstrating how to build an Excel spreadsheet right from the context of the current 5250 screen.įirst of all, if you haven’t read Part 1, please read it now as there are some pointers about script writing for the PCOMM emulator that developers should be aware of. In Part 1 of this series, I demonstrated that users of IBM‘s Personnel Communications can use VBScript to run a remote PC command right from the 5250 emulator window.

Use PCOMM Scripts to Dynamically Build a Spreadsheet, Part 2