macro 2010 file search

  1. J

    Macro to Pull in select tabs from many files into one master

    Hi All, I am not only very new to this forum but also to excel macros. Pretty much what I am trying to do is write a macro that will pull two tabs labeled "XXXXMarch" "XXXXPTD" (the x's represent numbers) from each file within a designated folder and copy them into a master file. Can anyone help...
  2. S

    Finding Duplicate Values

    Okay ! I got a two huge separate excel sheets. One has values upto 90k (Sheet 1) and other has 7k (Sheet 2) Now I want to find the duplicate value in sheet 2 present in sheet 1 and have a all unique values to be present in sheet three It be some what like this <TBODY> Sheet 1</SPAN> Sheet...
  3. J

    Vba to pull file from sharepoint

    Hello I have written a macro that when run, it opens a local documents folder and lets you select any number of files, the files are then copied and pasted into the original sheet. Now I am trying to pull files from an online sharepoint using the same macro. I am having trouble referencing the...
  4. W

    Replacing Application.FileSearch command for Excel 2010

    I have this in a Macro Dim oSearch As FileSearch Set oSearch = Application.FileSearch With oSearch .NewSearch .LookIn = strDirName .SearchSubFolders = False ' For example, to search for text files change this line to: ' .FileName "*.txt" .Filename =...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top