Attachmate Macro Guide
I don't think it's possible to read directly from an Excel file. In real programming languages, you could use a DAO or ADO to accomplish this, but EB does not have any of that functionality that I've ever found. What I've done in the past is save the file as a.csv or.txt file, then you can use EB to open the file and get data. If this is something that needs to be ongoing, you can write a VBA program that will do this for you and fire the macro using the shell command: rc% = shell ('.ebrun.exe yourmacronamehere.ebm') It's critical that the macro name not have spaces in it.
Hope this is helpful. RE: Attachmate Macro to read data from Excel. You could try adding the following code to a module in VBA for excel. Figured it out myself! I have seen this request in a number of posts. Hope this helps.
Got this from the Attachmate website: To create a macro that pastes a range of cells from an Excel 97 worksheet into a host screen, use the following section of code as a template. Dim obj as object, Sess0 as object, objWorkBook as object set obj = CreateObject( 'Excel.Application.8' ) obj.visible = TRUE obj.Workbooks.Open 'c: msoffice excel library common.XLS' set objWorkbook = obj.Worksheets('Sheet1') 'This copies the range of cells to the clipboard objWorkBook.Range('A1:C3').copy 'You can also select just one cell with ('A1') 'Or you can do something like Name = ObjWorkBook.Range('B14') 'This pastes the clipboard to the screen Sess0.Screen.paste Note: Excel.Application.8 is specific to Microsoft Excel 97. For Microsoft Excel 2000, use Excel.Application.9. For other versions of Excel, open the registry and look under HKEYCLASSESROOT for Excel.Application.? And find the version you have installed. RE: Attachmate Macro to read data from Excel (IS/IT-Management) 2 Feb 04 10:22.
Here is an example of creating/updating excel worksheet, range, whatever via ADO run w/Attachmate EXTRA! 7.0 Object Library & Microsoft DAO 3.6 Object Library. Hi In first you must declare extra.tlb in excel (Library Type) I haven't the right word because I haven't excel on my computeur. You must declare the path of Extra on Windows's variables of Environement (in Windows Explorer - Controle Panel - System. And find the buttom call 'variables of Environement' Maybe it isn't the exact word because I have Windows French.
327w user manual simply accounting tutorials land rover series iia manual niemeyer 425 rotary rake parts manual photoshop mask alpha channel tutorial m2008 meridian phone programmer guide guide to mammoth mountain batman episode guide 1960s attachmate extra macro tutorial 95 gti manual speedometer. Download and Read Attachmate Macro Guide Attachmate Macro Guide Excellent book is always being the best friend for spending little time in your office, night time, bus, and.
Sorry So it's ok tape this code and go. ' Global variable declarations Global gHostSettleTime% Sub Main '- ' Get the main system object Dim Sessions As Object Dim System As Object Dim TmpVal as string Set System = CreateObject('EXTRA.System') ' Gets the system object If (System is Nothing) Then Msgbox 'Could not create the EXTRA System object.
Stopping macro playback.' STOP End If Set Sessions = System.Sessions If (Sessions is Nothing) Then Msgbox 'Could not create the Sessions collection object. Stopping macro playback.'
STOP End If '- ' Set the default wait timeout value gHostSettleTime = 700 ' milliseconds OldSystemTimeout& = System.TimeoutValue If (gHostSettleTime OldSystemTimeout) Then System.TimeoutValue = gHostSettleTime End If ' Get the necessary Session Object Dim Sess0 As Object Set Sess0 = System.ActiveSession If (Sess0 is Nothing) Then Msgbox 'Could not create the Session object. Stopping macro playback.'
STOP End If If Not Sess0.Visible Then Sess0.Visible = TRUE Sess0.Screen.WaitHostQuiet(gHostSettleTime) ' This section of code contains the recorded events RE: Attachmate Macro to read data from Excel (Programmer) 26 Feb 04 21:25. I have succeeded in pulling data from Extra!
To an excel file. Then taking the resulting file and putting it back into Extra. I am trying to add a line to the first macro that will set the column to a text display, instead of a general display (since the data is numerical, excel tends to display long strings of numbers in a scientific format - not good for my purposes).
I've tried recording a macro in excel, then copying & pasting the macro into my extra macro. Problem: Extra does not recognize the command used to format the cell in a text format.
Example: Columns('A:A').ColumnWidth = 18.86 Range('A1').Select Selection.NumberFormat = '@' Extra will run the first two lines. The 3rd line results in a problem. Is there a workaround? Regards Harry RE: Attachmate Macro to read data from Excel (Programmer) 27 Feb 04 12:14. Hello Why that you recording a macro in Excel for copying the macro into your Extra macro? I don't understand why you do that? With the code who i gave you, you don't have need to use Extra Macro.The code who I gave you run on Excel.
If you had create a Macro in Extra, you can copy it in the Excel macro, so Excel drive Extra not the reverse. I'm not verry good in english, so if you don't understand me, say it to me and I will tray to re-explaind:) Or if I had not understood what you say me, re-explaind me the probleme.
Sorry:) Ps: RE: Attachmate Macro to read data from Excel (Programmer) 27 Feb 04 12:28. Create a input file from excel.
1) Setup pipes: Text1 Text2 Text3 2) Start your beginning information with this script. Open sInputFile For Input As #1 sOutputFile = mid(sinputfile,1,len(sinputfile)-4) & 'Output.doc' msgBox (' & sOutputFile & ' Will be your output file') Open sOutputFile for Output As #2 Do While Not EOF(1) line input #1, sLineText iStartPipe = 0 iEndPipe = InStr(iStartPipe + 1, sLineText, ' ') iLoopCount = 0 Do Until iendPipe = 0 sInput(iLoopCount) = mid(sLineText, iStartPipe + 1, iEndPipe - iStartPipe - 1) iLoopCount = iLoopCount + 1 iStartPipe = iEndPipe iEndPipe = InStr(iStartPipe + 1, sLineText, ' ') Loop sText1 = sInput(0) sText2 = sInput(1).
Attachmate Delivers Mobile Access to IBM Servers February 5, 2013 Alex Woodie last month unveiled new software that lets users access IBM i- and zSeries-resident data and applications from mobile devices. Verastream Host Integrator version 7.5 brings the capability to serve 5250 and 3270 screens as HTML5 applications to tablets and smartphones running iOS, Windows 8, and Android mobile operating systems. The software is the first deliverable that’s part of Attachmate’s newly launched MobileNow initiative. The mobile bug is now spreading faster than the flu. Companies in every industry are demanding ways to access host assets via smartphones and tablets. Attachmate, which has the second largest base of terminal emulation customers outside of, has seen customer demand ramp up quickly, and its response is the new MobileNow strategy. Like many other companies selling host enablement software, Attachmate is utilizing HTML5 to generate Web apps that can run equally well on mobile devices from a variety of manufacturers.
(The company is also working on developing native applications for the iPad, but that product won’t be announced for months.) Due to the tiny screens on smartphones, tablets are the big focus with Verastream Host Integrator (VHI) 7.5 and a new companion product, Verastream Process Designer r5. VHI can deliver host access in three different ways, explains Ron Nunan, product marketing manager at Attachmate. First, customers can get straight 5250 or 3270 green screens in their VHI sessions. Secondly, customers can use VHI to convert the green screen into a Web form. Thirdly, customers can modify the screens and the workflow to provide a customized experience for users. Mobile users can access special functions via a function-key keyboard that drops down when using VHI in terminal emulation mode.
Attachmate put a lot of work into making VHI sessions intuitive for users, Nunan says, including full keyboards that drop down and are transparent (or semi-transparent), custom swipe functions, and conversion of host screen elements into hot-spots. “Just all kinds of little additions to allow finger use instead of keyboard use of these applications that were built for keyboards,” he says. “You can also create services that instead of showing up as Web services, show up as automation buttons or macro commands. It’s really kind of a melding of the backend system that VHI provided in the past, to tying it to a specific HTML 5 application for tablet and phone users.” One early VHI user created an app for tables that allows users to quickly see a location in Google Maps. The customer converted mailing addresses that showed up as Web forms into hyperlinks that automatically access the Google Maps API. Other users have mobile-enabled specific parts of their ERP and CRM systems to provide access to IBM i-resident data in real time from a tablet.
This capability to build apps that access the World Wide Web in new and creative ways is what the MobileNow version of VHI is all about, Nunan says. “Customers can start adding procedures and server side macros and create automations for their iPads or phone users that then go off and do things for them,” he says. Deployment of the mobile apps can be done from the popular stores, such as Google Play and Apple App Store. Attachmate utilizes PhoneGap to ensure that the HTML5 apps can be deployed via the stores, even though they aren’t native apps.
“We were able to write some nifty little capabilities that look very native in their implementation, but they’re actually written in HTML5.” Users can optionally have their 5250 screens automatically converted into Web forms, such as this one, when using Verastream 7.1 with tablets. There aren’t any special skills required to begin building mobile apps from IBM i and mainframe assets, beyond the JavaScript skills that a typical Web developer would have, Nunan says. The power of HTML5 and the fact that customers can begin delivering mobile applications without a huge commitment is a big drive for mobile adoption. “It’s growing like crazy,” Nunan says.
“It’s probably, for Verastream, the single most popular topic that we’ve had last year. We’ve got a lot of projects. Originally they started off as service style projects, but now they just range all over the place.” MobileNow will eventually touch Attachmate’s entire portfolio, which spans host integration (Verastream), terminal emulation (Reflection), managed file transfer (FileExpress), and fraud detection (Luminet), says Tom Bice, vice president of marketing and product management at Attachmate. “We felt we needed an umbrella brand to provide cohesion for that message,” he says. “It’s really a vehicle for us to provide some clarity around some different things that our portfolio can do within the context of mobile initiative.” The server component of Versastream Host Integrator 7.5 runs on Windows, Linux, zLinux, AIX, and Solaris. Customers can get started with a license for about 50 users for about $50,000. For more information, see.
Attachmate Macro Login
RELATED STORIES.