Potential Clashes in Macros

Italophile · #1 10-09-2023, 04:38 AM

The BrowseForFile function adds a filter to the File Picker dialog. As MergeMultiDocsIntoOne uses the same dialog without setting a filter it will inherit the filter from the previously used function.

The solution is simple - clear the filters, and optionally set a filter for the required file types, for the File Picker in your MergeMultiDocsIntoOne routine. You can simply copy and paste from the other function, e.g.

Code:

  With dlgFile
    .AllowMultiSelect = True
    .Filters.Clear
    .Filters.add "Word documents", "*.doc,*.docx,*.docm"

yanyan9896 · #2 10-09-2023, 04:59 AM

Quote:

Originally Posted by Italophile

The BrowseForFile function adds a filter to the File Picker dialog. As MergeMultiDocsIntoOne uses the same dialog without setting a filter it will inherit the filter from the previously used function.

The solution is simple - clear the filters, and optionally set a filter for the required file types, for the File Picker in your MergeMultiDocsIntoOne routine. You can simply copy and paste from the other function, e.g.

Code:

  With dlgFile
    .AllowMultiSelect = True
    .Filters.Clear
    .Filters.add "Word documents", "*.doc,*.docx,*.docm"

Thank you for your helpful explanation regarding the BrowseForFile function and its impact on the MergeMultiDocsIntoOne routine. I appreciate your suggestion to clear the filters and set a filter for the required file types in the File Picker dialog. I will implement this solution by copying and pasting the filter code from the other function.

Once again, thank you for your assistance.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Seeking help with Cross-Reference Links Beween Documents	SAikins	Word	5	05-18-2018 06:15 AM
Seeking help recreating a template from the internet	AwesomeWithAQ	Word	5	01-12-2018 11:13 AM
Seeking advice as to how to align items in an office directory that I made using PowerPoint	mcsharpe	PowerPoint	1	10-12-2015 04:21 PM
Seeking PowerPoint Freelance Help	gazdabitner	PowerPoint	0	12-06-2010 02:12 PM
Seeking Excel Expert Advice for Web Publishing	tjmichner	Excel	0	10-25-2006 08:40 AM