Jump to content
Macro Express Forums

Macro script within a script


brianr-is
 Share

Recommended Posts

Hello All,

 

I would like to build a script or scripts to accomplish the following. I have to build a script(s) to login to our medical software, open an Excel spreadsheet with specific data, then copy and paste data from spreadsheet to Medical software routine several times, then logout of the software and close the spreadsheet. I would like to run this script(s) twice daily. Can I do this using the Capture routine in Macro Express 3.8a? Should I build more than one script to do this (i.e. build the login/logout script then build the looping script for the routine)?

 

For example

 

1. Double click to open Excel Spreadsheet with data on desktop.

2. Login to Medical software from desktop.

3. Go to specific routine

4. Copy and paste data from spreadsheet to Medical Software routine that will loop many times until finished(i.e. at least 15 times)

5. Logout of Medical software.

6. Close Spreadsheet.

 

Brian.

Link to comment
Share on other sites

You should be able to use the capture feature to create a macro to log into the system. Most captured macros work better if they are later optimized. It is not possible to use the capture feature to create a loop within a macro. Use the Script Editor to do that.

 

It often is a good idea to divide distinct tasks into separate macros such as logging on and/or performing multiple copy and paste actions. Use the Macro Run command to call one macro from another.

 

You can change the activation of a macro to Scheduled to have it run automatically twice a day.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...