+ Reply to Thread
Results 1 to 6 of 6

How do I add file name characters to dictionary?

  1. #1
    Registered User
    Join Date
    11-18-2011
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2016
    Posts
    31

    How do I add file name characters to dictionary?

    I'm working on a user guide which contains a ton of file and folder names with an underscore ( _ ) or path with \.

    For example, file_name_sample.dat or C:\FolderA\FolderB\filename.xlsx. Or worse, C:\FolderA\FolderB\file_name_here.xlsx

    How do I add these to the dictionary so every single one isn't highlighted in spell check? I tried adding *_* but it didn't work.

    Your help would be greatly appreciated!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,775

    Re: How do I add file name characters to dictionary?

    Go to File->Options->Proofing and tick "Ignore Internet and file addresses". It will not capture file names and folder path in spell check.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    11-18-2011
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2016
    Posts
    31

    Re: How do I add file name characters to dictionary?

    Thanks for your input CK76, but that's not solving my problem...it's already checked. Not only for file paths, but I'm also using sql database queries.

    These are taken directly from my document and all are underlines by spell check:

    date_format, extract_by_file_id_flag, field_delimiter, include_header_row_flag, include_metadata_flag,
    Last edited by kazphilips; 01-15-2019 at 05:02 PM. Reason: Included add'l info.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,775

    Re: How do I add file name characters to dictionary?

    There isn't good way to ignore all words including underscore.

    One workaround, is to always follow underscore with number. Then when you are finished with the document, replace "_#" pattern with underscore and check "Hide spelling errors in this document".

    Personally, I'd just use RegEx pattern matching to extract words that include underscore, and write to text file. Then change extension to .dic and import it as custom dictionary. If this is constant issue.

  5. #5
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,701

    Re: How do I add file name characters to dictionary?

    Or use a custom Style for the content concerned, with the Style language set to 'no proofing'.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  6. #6
    Registered User
    Join Date
    11-18-2011
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2016
    Posts
    31

    Re: How do I add file name characters to dictionary?

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Why dictionary very slow ,is dictionary have maksimum data
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-30-2018, 03:57 PM
  2. Adding dictionary into dictionary and retrieving data
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2018, 06:52 AM
  3. [SOLVED] Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Function
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-12-2016, 08:28 AM
  4. Save outlook attachment as file using email subject as file name w/o invalid characters
    By kristinlarmer in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 10-16-2015, 05:07 PM
  5. Storing a Dictionary into a Dictionary Object
    By pago_boss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2015, 03:04 AM
  6. Scripting.Dictionary (Save to file and attach to workbook)
    By Kalithro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2015, 04:06 PM
  7. Dictionary - Using a dictionary of dictionaries to hold individual orders
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2015, 08:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1