BOC - Call F9-Create

[waxman]

I just want to create an excel loader for MSO88P. The screen use "Create" button. How to call this button?

I use:
.Screen.MSO.Fields("FKEYS1I&quot.Value = "F9"
or
.Screen.MSO.Fields("FKEYS1I&quot.Value = "F9-Create"

give no result to trigger to the next screen.

Thanks,
Wayan D

 

[PhantomPhil]

Calling of commands which are represented by function keys is achieved by executing one of the commands, most likely to be:

.Screen.MSO.Commands("Create").Execute

The following bit of code displays all commands which are active on the current MSO screen:

sFuncKeys = "Function Keys/Commands on screen " & _
  Trim$(.Screen.MSO.Name) & vbCrLf
For iFuncKeys = 1 To .Screen.MSO.Commands.Count
  sFuncKeys = sFuncKeys & CStr(iFuncKeys) & " " & _
    .Screen.MSO.Commands(iFuncKeys).Name & "; " & vbCrLf
Next iFuncKeys
MsgBox sFuncKeys

 

[waxman]

Unfortunately, there is no 'Cancel' command in this MSO of Ellipse 5.2.3.
Available commands are: 1 - Home, 2 - OK, 3 - Cancel, 4 - Revert, 5 - Help, 6 - Validate, 7 - Save.
Is there any possible way around for the code to access to the Menu File| Create -instead of 'Create' button?

R, Wayan D