LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Using Excel Add ins with visual basic

I tried to record keystrokes because I had no idea how to access an
excel addin that is already installed and usable. On the menu, its on
the "Data" menu, and then "Transfer to iSeries Request".

If you do that manually without visual basic, then a form will pop up
where you select a button or two, then you need to be able to click
the "browse" button and navigate to and select an already saved
"Transfer Request", and then I need to select "ok" once I've selected
"open" for the particular transfer request.

Also, I need to be able to handle more possible error dialog boxes
that may or may not pop up depending on whether or not the transfer
requests has any errors once it is submitted.

Once I select "ok" from the dialog box, a separate windows application
handes the Iseries Transfer Request.

I can do this the old fashioned way where I extract highlighted data
to another XLS, and then go into the iseries transfer program and do
it from there. However, I wanted to do in Excel, because we can
already do that manually from Excel and it saves time that way.

Can anyone get me started on what I need to do?

Bruce

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is Visual Basic the same as Visual Studio 2008? Mike Stewart Excel Worksheet Functions 5 January 11th 09 04:58 PM
Programmatic access to visual basic project via Visual FoxPro Jim Rech Excel Programming 0 January 11th 07 01:53 PM
Make visual basic truely visual! GraphicalGuy Excel Programming 0 October 20th 06 05:53 PM
Can I run Visual Basic procedure using Excel Visual Basic editor? john.jacobs71[_2_] Excel Programming 3 December 26th 05 02:22 PM
changing the visual basic in office 2003 to visual studio net bigdaddy3 Excel Discussion (Misc queries) 1 September 13th 05 10:57 AM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"