Search:

Type: Posts; User: jsquared; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    1,381

    Windows Explorer search not working

    Hello,
    I'm running Windows7 64bit and have begun to have problems with the search function in explorer. If I type a search term into the top right corner and hit search the process begins but never...
  2. Problem with Firefox, Excel, Word and Outlook (2007)

    Hi,
    I hope I'm in the right forum and hope someone can help me sort out my mix of problems.

    I have Office 2007 and Firefox installed (Windows 7 64bit) and have suddnely begun having problems with...
  3. Re: Moving/copying files in the 'file open' box (E

    While explorer would work, I'd like to be able to move the files from within the application. If I'm in there and see a file that I think should be filed elsewhere, it would be much easier to do it...
  4. Moving/copying files in the 'file open' box (Excel

    I am running Office 2007 under Vista Professional.

    If I try and move files with the 'File|Open' screen open, Excel crashes. I can see my directories in the left hand panel and the files/folders in...
  5. Replies
    1
    Views
    356

    Coloured Bullets (Publisher 2002 SP3)

    I am trying to format a bulleted list so that the colour of the bullets is a contrast with the text colour eg., red bullets and black text.
    It's easy enough to do in Word but doesn't appear to be an...
  6. Replies
    1
    Views
    274

    Saving as rtf (2002 SP3)

    When I save a file as an rtf document and then open it in Word, it opens with Letter size paper and the standard tab settings etc., I have my normal.dot template defined to A4 with my own tabs and...
  7. Replies
    4
    Views
    304

    Re: Help not working (2002 sp3)

    You're a legend!!

    All fixed. I don't know what the problem was as I opted to let the tool fix anything it found. Everthing seems to be back to normal.

    Thanks for your help.
  8. Replies
    4
    Views
    304

    Re: Help not working (2002 sp3)

    You might have something there. I just tried "Help and Support" from the Start menu with no response at all. I am running XP Professional V5.1, SP2
  9. Replies
    4
    Views
    304

    Help not working (2002 sp3)

    For some reason, the help function appears to have disappeared in all Office applications. If I use F1 or the menu item I see a blank white box. If I reactivate the annoying little paper clip I seem...
  10. Re: Lost ability to create filter rules??? (OUT XP

    I'm experiencing the same problem. Any gurus out there who can fix it for me?

    As with Tom, this is a single user application (ie., NOT MS Exchange)

    Thanks
  11. Replies
    1
    Views
    305

    Stop auto correct (2002 sp3)

    I often use the abbreviation e.g., and i.e., and Word has an annoying habit of capitalising the "e" and the "i". If I think about it, I just hit ctrl-z and cancel the correction and keep typing but...
  12. Replies
    6
    Views
    390

    Re: Sorting in Excel (Excel 2000)

    Have you tried converting the values to text (=TEXT(value,format_text) ). TEXT(value,"00") will return 00 for a blank, 01 for 1 and 10 for 10. If you then concatenate the string should sort correctly...
  13. Replies
    7
    Views
    821

    Re: Macro on all open books (XP Sp2)

    Jan,
    Thanks for the link. Hans got me out of my problem today but I'll put yours into my armoury for the future.
  14. Replies
    7
    Views
    821

    Re: Macro on all open books (XP Sp2)

    I pasted the code and get a syntax error on the line:

    Set wbk = Workbooks.OpenText Filename:=strFolder & stFile

    ??
  15. Replies
    7
    Views
    821

    Re: Macro on all open books (XP Sp2)

    Thanks Hans, just what I was looking for. All the files I am working on are in a single folder (ie., all the files in folder 'x' need to be edited) What I planned to do was to use file-open, then...
  16. Replies
    7
    Views
    821

    Macro on all open books (XP Sp2)

    I have several sets of workbooks that need a simple edit. I'd like to be able to do a global search and replace on all open workbooks. I can set up a macro to work on a single book and I can run it...
  17. Replies
    2
    Views
    384

    Re: Task Pane (XP Sp2)

    Hans,
    Thanks for the tip. That seems to have fixed it but I'm still confused by the fact that the two installations behaved differently (both have macros in personal.xls) but there are differences...
  18. Replies
    2
    Views
    384

    Task Pane (XP Sp2)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    I have Excel 2002 installed on my laptop and on my desktop. When I launch Excel on the laptop, the task pane opens showing...
  19. Replies
    4
    Views
    412

    Re: Sum (array) v Sumproduct (2002 sp3)

    Thanks for the response. I think I'll stick with SUMPRODUCT until I can get my head around the approach given on the decisionmodels site.
  20. Replies
    4
    Views
    412

    Sum (array) v Sumproduct (2002 sp3)

    I often need to get conditional sums from tables of data. As far as I can tell, using SUMPRODUCT with a series or ranges and criteria is equivalent to to using SUM as an array formula with the same...
  21. Replies
    15
    Views
    3,379

    Re: a movable table (excel)

    Thanks for that example. It does the job, but I'm nearly certain that the one I saw earlier used the camera or some sort of picture object that was linked to the radio buttons iykwim.
  22. Replies
    15
    Views
    3,379

    Re: a movable table (excel)

    Can I jump in here with an extension to this question - not a hijack (at least I hope not)

    I saw an Excel worksheet that had a graph and alongside it there were radio buttons marked Qtr1, Qtr2...
  23. Re: If statment that displays Text from cell ref (

    I might be wrong, but shouln't the letter A be inside inverted commas and the TEXT function might be redundant ie.,

    =IF(AND(C30="General",E30="A"),C9,"")
  24. Replies
    12
    Views
    631

    Re: filter by length of cell contents (2000)

    Why not try using an autofilter and then use a custom filter to find all records of the form ?????. This will work for text fields but not (I think) on numeric. If the data is numeric, you could...
  25. Replies
    1
    Views
    267

    showdata (2002 sp3)

    I work with an Australia post file that lists the details for all Australian postcode zones. I often need to find either the name of all places with a specific postcode (some codes cover multiple...
Results 1 to 25 of 112
Page 1 of 5 1 2 3 4