PASSPORT Knowledge Base
Macros

Date Published: August 15, 2008

Title

Convert Excel Macro to PASSPORT Macro

Product

PASSPORT PC to Host, PASSPORT Web to Host

Emulation Types

TN3270, TN5250, VT, SCO ANSI, Wyse 60

Issue

I currently have Microsoft Excel spreadsheets that contain macros, which interface with Attachmate EXTRA! sessions. How can these be modified for use with PASSPORT?

Solution

The VB macro should be edited so that all instances of EXTRA.System are replaced with PASSPORT.System. Once this change is made, the remainder of the code should work as expected. Follow the steps below:

1. Open the spreadsheet in Microsoft Excel.
2. Choose the Tools®Macro®Visual Basic Editor menu command.
3. Choose the Edit®Replace menu command.
4. Type EXTRA.System in the Find What field and PASSPORT.System in the Replace With field.
5. Make sure Current Project is selected for the Search Type.
6. Choose Find Next then Replace to change each individual instance or Replace All to change them all at once.
7. Choose Cancel to close the Replace dialog box.
8. Close the Visual Basic Editor.
9. Choose the File®Save or File®Save As menu command to save the changes.

More Information

• This procedure will only work with Excel macros that were developed for use with Attachmate EXTRA! 6.x and newer.

Keywords

macro, EXTRA, Excel, spreadsheet