Jump to content
Macro Express Forums

Recommended Posts

Posted

I'm new at this..

 

I have a bunch of Excel and Word documents in a particular folder/directory.

 

I can see hat I can use the 'Open Folder' in the 'Exploer' area to go to a specific folder/directory... But I need to know how to tell ME how to open up a specific Excel File or Word File..

 

any help would be great..

Posted

There are two ways that immediately come to mind:

 

Use the Program Launch command and put the file name in the 'Program Path/Name' field. This works because the file extensions of .doc and/or .xls are registered for use by Word and Excel respectively.

 

The second option also uses the Program Launch command. Put the full path name of Excel or Word in the 'Program Path/Name' field and the name of the file you want to open in the 'Program Parameters' field. Using this option you can also open the file in 'read only' mode by putting /r in front of the file name.

Posted
but what happens if my excel file has a macro within it that requires user intervention to press the 'enable macro' button.. can that be automated?

Why not resolve Excel security properly, i.e. by setting the security level to Low (quick and easy), or by introducing authorized certificates?

  • 1 month later...
Posted

I agree with paul, it would be best to tweek the settings to avoid that.

 

But however, i wonder if he could also use "Wait for Window" command to roll through the pop-ups for the macros within excel.

Posted

When this came up before I vaguely remember you cannot press the Enable button with ME. You would have to try it. I have to agree that the security issues are the main focus. What is the point of having moderate security? If you can circumvent it, then your security is completely useless.

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...
×
×
  • Create New...