• WSGfamily

    WSGfamily

    @wsgfamily

    Viewing 11 replies - 361 through 371 (of 371 total)
    Author
    Replies
    • in reply to: Graphics Programs #778017

      Hans points out the wide functionality of IrfanView, but I would like to advise people that most of the functionality is available through the command line and associated escape codes.

      Using Visual Basic with its Shell command gives users programmatic control of the program, so users can add the IrfanView functionality to their own applications.
      The attached file is a copy of the Help file for Command Line Options

    • in reply to: 2d grid into single column (Excel 97 -SR2) #683808

      Many thanks
      I’m using this a lot already.

    • in reply to: Doc already opened on another computer (Excell 2002) #683376

      Are the preferences on the XP box set such that a single click opens files? If so, and the user is double clicking, they may be actually opening the file twice( which would match the message received).

      I had trouble with a mouse driver that gave the “single click = Double click” problem. It sounds crazy, but reversing the left and right mouse key actions resolved that for me – I’ve now moved to a new cordless mouse so its not a problem any more.

    • in reply to: 2d grid into single column (Excel 97 -SR2) #683302

      To be honest I hadn’t checked whether it was doing row/column or column/row, that closely. Thanks for pointing it out.
      My bigger problem with the original formula was that when I used a 7×4 grid I was getting
      a100
      a200
      a300
      a400
      #REF!
      #REF!
      #REF!
      b100
      b200
      b300
      b400
      #REF!
      #REF!
      #REF!
      c100
      c200

      etc.

    • in reply to: 2d grid into single column (Excel 97 -SR2) #683231

      That’s great – but I found I had to reverse the row and column references like this
      =INDEX(DATALIST,INT((ROW()-1)/COLUMNS(DATALIST))+1,MOD(ROW()-1,COLUMNS(DATALIST))+1)

      Do you agree?

      Many thanks for pointing me in the right direction – I’ve not come across INDEX before.

    • in reply to: Difficulty opening Excel (Excel97 SR2 on NT 4) #664703

      I’m very impressed, that worked straight off.

      Is there somewhere I can find out more about these switches? Excel help only has very basic info on them.

    • in reply to: Front Page Extensions (Office 2000) #663851

      Are you sure that the FP publisher is dependent on FP Extensions? I originally had difficulties with my free ISP not accepting FP Extensions. However I found a panel in Tools | Page Options | Compatability which gives the option of disabling features not supported by servers – including FPE. Since then I’ve found no problems with using FP Publisher.

    • in reply to: image prints from some pcs not others (word97 sr2b) #655206

      Could you try changing the object type by ‘Ctrl+X’ing it to the clipboard and using Paste Special to change it to a Word Picture object, or some other supported type.

      By simplifying the object you should be able to get it to the printer.

    • in reply to: Word opened from Taskbar (97/SR-2) #654200

      Have you tried deleting the Word shortcut from the Taskbar and Cutting and Pasting a fresh copy of the shortcut (from the Start Menu) onto the taskbar?

      It may be that the shortcut command settings are slightly different for the Taskbar version which is leading to the corruption

    • in reply to: Changing Clipboard/Paste options (Word 2000) #653438

      I’m working through 197827 – so far I’ve found that the /a switch keeps the clipboard. I’ll try out the other procedures too – and see if I can pin down what’s causing it.

      As for pasting a picture that still results in an INCLUDEPICTURE with a url, so I’ve taken up the suggestion of recording a macro and assigning it to Alt +V to do the Paste Special |Device Independent Bitmap.

      Many thanks guys! -I’ll follow up with a final note when I’ve been through 197827.

    • in reply to: Changing Clipboard/Paste options (Word 2000) #653238

      Thanks Andrew,

      I’d already looked at a couple of these threads and I don’t think there’s any solution in them for me. Thread 219656 starts with the same problem as my Question 1(Clipboard empties when opening Word) , but then changes to the same problem as 219696 without coming to a resolution. 219696 is fascinating, but not really relevant to either of my problems as far as I can see.

      My question 2 (picture copied off the web is pasted as an INCLUDEPICTURE with a URL, rather than pasted as an image) might be solved by the macro solution in 158488; but I’d prefer it if I could simply change the default action in Word.

      Grrr!

    Viewing 11 replies - 361 through 371 (of 371 total)