Jump to content
Macro Express Forums

How To Open Up A Excel Document?


Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

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

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.

  • Create New...