Excel Marco/Add-In Question

[sgreenwood]

Hi,

I'm not sure if what I'm trying to do is possible, but if it is I KNOW someone here can help me out!

I have an Excel add-in "Transfer Data From AS/400". When this add-in is installed it places a selection on the "Data" menu "Transfer Data From AS/400". When this menu item is selected it opens a dialogue box requesting the name of a ".tto" file containing the transfer request info.

Problem - I would like to create a macro that will call this menu item and pass on the information requested in the dialogue box.

I have tried recording a macro, but it doesn't seem to see any of these actions. When I'm done recording the macro I open it in the VBA editor and the module contains the "sub" and "end sub" statement...that's it.

Am I attempting to do the impossible? I don't think so, but obviously my expertise is greatly lacking in this area!

Thanks in advance for any help you might be able to give.

Steve

 

[acron]

I'm sure if you could provide the source code of the Add-In, it should be possible to adapt it to your requirements.

Is the code protected and does it have a copyright ?

A.C.