Jump to content
Macro Express Forums

Using a Macro to Open a file using keyboard commands


Recommended Posts

I am trying to learn to use Macro Express Pro better in order to automate many of my office functions. I have been using it for a while and can do some basic things. I ran into a problem that I can't figure out.

 

I want to create a macro that will open Excel and then Open a specific file on my server in Excel.

 

My macro will open Excel.

 

However, I can't figure out how to make the Macro to give Excel the keyboard command ALT F so that I can open the file.

 

Any help would be appreciated.

Link to comment
Share on other sites

I use the program launch command but instead of a program I enter the Excel file name. The Windows file extension association kicks in and will load the file in Excel based on your handling settings.

Link to comment
Share on other sites

I think what Cory was suggesting is a way to NOT use a program's menus (or ribbons) to open a specific file.

 

Program Launch: "EXCEL.EXE" (Normal)
Parameters: "c:\tmp\test file.xls"

 

As for your question about saving the file... are you asking how you do it with a macro? It helps to know the keyboard shortcut, Ctrl + s, or using the Ribbon, Alt + f followed by s...

 

// Use Excel's built in hotkey to save...
Text Type (Simulate Keystrokes): <CONTROL>s

 

// Interact with the ribbon via typing simulation to save....
Text Type (Simulate Keystrokes): <ALT>f  // File ribbon
Text Type (Simulate Keystrokes): s // Save

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...