tdelios Posted February 3, 2010 Report Share Posted February 3, 2010 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.. Quote Link to comment Share on other sites More sharing options...
kevin Posted February 3, 2010 Report Share Posted February 3, 2010 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. Quote Link to comment Share on other sites More sharing options...
tdelios Posted February 3, 2010 Author Report Share Posted February 3, 2010 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? Quote Link to comment Share on other sites More sharing options...
paul Posted February 3, 2010 Report Share Posted February 3, 2010 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? Quote Link to comment Share on other sites More sharing options...
Tropic Posted March 5, 2010 Report Share Posted March 5, 2010 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. Quote Link to comment Share on other sites More sharing options...
Yehnfikm8Gq Posted March 5, 2010 Report Share Posted March 5, 2010 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.