2nd file does not launch in 9.5.6

Help & Support
1

Hi
i am using ver 9.5.6 and XP

i have a few .XLS files which i have dragged to a tool bar to make shortcut buttons

the first one (any one) clicked starts fine, but often when i click a second button to a different spreadsheet nothing happens, not always but usually.

it is as if EXCEL is waiting for input in the first document but it is not

if i close the first doc and then click the 2nd button it works every time, again it doesn't matter which button or file, it has something to do with one or more docs already being open

is there something i can add to the button to make it work ?
tia

2

Try sending the same files to Excel via a command prompt and see if it behaves in the same way.

If it does then you know it's something (your version of) Excel itself is doing, rather than something Opus is doing.

If it doesn't then we might be able to work to change your button so that it works in Opus as well.

3

great
i assume you mean the Run box on the start menu ?

yes, if i paste the full path to the various spreadsheets in the Run box, they all open ok, same files as on buttons, with differing paths

4

What commands do the buttons have? Just the filenames?

5

yes
i have the following:

a Label
a tip
no hotkey
function: is full path to filename
start in: has the path
run: normal window
show image is checked (default icon for xls in this case i am looking at)
show label is checked, dropbox says 'default'

6

Not sure if it will work (it works without this for me, but I'm probably using a newer version of Opus/Excel/etc.), but give this a try:

  1. Set the Run drop-down to Hide

  2. Set the Function drop-down to MS-DOS Batch Function

  3. Add start "" to the start of the filename, so it's like this:

start "" "C:\Users\Leo\Desktop\Test file.xls"

That might work.

7

thanks a lot
wouldn't you know it but at the moment there is no problem

but this will recur and i will try