Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PeterMoran

  1. PeterMoran

    Excel 16 - Ctrl-V does not hold for multiple pastes

    Hi xwb, Thanks for your reply. The focus seems ok, I copy and then want to do several repeated pastes down a page, and the data is lost after the first paste. To do what I want I have to repeatedly copy and paste. Other times I works fine!
  2. PeterMoran

    Excel 16 - Ctrl-V does not hold for multiple pastes

    Hi, I find lately that Ctrl-V (Paste) sometimes does not hold for multiple pastes (repeating Ctrl-V without a Copy each time). Sometimes it works perfectly, then sometimes I have to do a Ctrl-C (Copy) for each paste. Any similar experiences, or even better, any known solutions! Thanks in...
  3. PeterMoran

    Word Macro to Open Window with just *.doc, & *.docx files

    Hi MakeItSo, Did the job! Great! Many thanks
  4. PeterMoran

    Word Macro to Open Window with just *.doc, & *.docx files

    Hi MakeItSo, Thanks for your quick reply. Will check it out and let you know how I go. Cheers,Peter Moran
  5. PeterMoran

    Word Macro to Open Window with just *.doc, & *.docx files

    Hi, I have this macro in Excel to just display *.csv files in the Open Window: Sub CSVOpen() ' ' CSVOpen Macro to Open Window for *.csv files in dir "Super" ' Dim myFileName As Variant Dim Wkbk As Workbook ChDir "C:\Users\Peter\Documents\Super" myFileName =...
  6. PeterMoran

    Excel and Word 16 - Using Ctrl O to Open Files Query

    Hi combo, Thanks! Good info, so looks like I will have to have separate macros or replace the File Open command with my own work to get what I want. In Excel I can't get all the files I want to be displayed together, and in Word there are often too many files displayed, many of which I don't...
  7. PeterMoran

    Excel and Word 16 - Using Ctrl O to Open Files Query

    Hi, In Excel 16 (at least) I would like to include "*.csv" in the All Excel Files option when opening files. Files I have downloaded as csv's from the internet just don't get displayed and there seems no obvious way to amend this. Maybe I should put it on the Microsoft Excel mod requests -...
  8. PeterMoran

    Repeating Finds in a Macro

    Hi Andrzejek Thanks for your reply. The fiddling is incidental, Mainly I wanted to know how to repeatedly Find and then run some code until the end of the document. My example showed one instance of what I wanted repeated until the end of the document. Peter Moran
  9. PeterMoran

    Repeating Finds in a Macro

    Hi macropod, Many thanks! Will have to check out wildcard Find & Replace in detail. Not one of my strengths! I did not realise it was so powerful. Will check it out today. Also have a STAR! Peter Moran
  10. PeterMoran

    Repeating Finds in a Macro

    Hi Andrzejek, Thanks for your reply. I don't understand what you have done by removing the code I need to perform every time I find the word "Singles" in the document. There may be 50 "Singles" in the document and I want to perform this code every time "Singles" is found until the end of the...
  11. PeterMoran

    Repeating Finds in a Macro

    Hi macropod, Thanks for your query. This is what the 'fiddling" does: It takes text downloaded from the web: Women’s Singles - Quarterfinals - 1h11 S. Stephens (7) 1 4 J. Konta (26) 6 6 Men’s Singles - Quarterfinals - 1h51 K. Nishikori (7) 1 1 3 R. Nadal (2) 6 6 6 for all matches on a day at...
  12. PeterMoran

    Repeating Finds in a Macro

    Hi, I have this macro I recorded to do some fiddling with subsequent lines every time it finds "Singles". I want this to be repeated until the end of the document, which I can't seem to work out after some investigation. Here is the macro: Sub FrOpenSinglesLines() ' FrOpenSinglesLines Macro...
  13. PeterMoran

    Word Find & Replace Words all Caps

    Hi Paul, Many thanks, I found a few extra variants in my processing, but basically inline with your thoughts. Peter Moran
  14. PeterMoran

    Word Find & Replace Words all Caps

    Hi strongm, Many thanks, got me going and with a little perseverence found that the text I needed was "^13<[A-Z]{2,12}> " Great work! Peter Moran
  15. PeterMoran

    Word Find &amp; Replace Words all Caps

    Hi, I am copying results from the French Open Tennis. This is what I get for each match in Word after I have pasted from the website: Men’s Singles - First Round Court Suzanne-Lenglen - 2h10 FABBIANO T.Fabbiano 3 5 1 - - CILIC M.Cilic (11) 6 7 6 - - Can I code a Find & Replace that will...
See more

Part and Inventory Search

Back
Top