In my macro I am trying to copy the contents of a cell from Excel (the location fo a file on disk), and then open the file. Sounds simple enough but this is my first ever macro, so I am doing something wrong and have no idea what.
Below are the lines from Script Editor:
> Text Type (Simulate Keystrokes): <DOWN ARROW>
> Clipboard Copy
> Variable Set String %filepath% from the clipboard contents
> Program Launch: "%filepath%" (Normal)
Parameters:
I get the error "The file could not be located "_filepath_" at the last line above. I know that the filepath is correct because if I adjust the macro to open the Run window (<Win>r), paste the clipboard contents and press <ENTER>, the file is loaded. The problem is that this workaround doesn't work everytime, so the macro fails from time to time.
How can I open the file directly from within the macro? please help.
Unable to open file: unexpected "the file could not be located" error
in Macro Express and Macro Express Pro
Posted
In my macro I am trying to copy the contents of a cell from Excel (the location fo a file on disk), and then open the file. Sounds simple enough but this is my first ever macro, so I am doing something wrong and have no idea what.
Below are the lines from Script Editor:
> Text Type (Simulate Keystrokes): <DOWN ARROW>
> Clipboard Copy
> Variable Set String %filepath% from the clipboard contents
> Program Launch: "%filepath%" (Normal)
Parameters:
I get the error "The file could not be located "_filepath_" at the last line above. I know that the filepath is correct because if I adjust the macro to open the Run window (<Win>r), paste the clipboard contents and press <ENTER>, the file is loaded. The problem is that this workaround doesn't work everytime, so the macro fails from time to time.
How can I open the file directly from within the macro? please help.
-Patrick