application.filesearch

  1. H

    With Application.FileSearch - Runtime error '445': Object doesn't support this action

    Hi all - Would some kind soul please put me out of my misery - worked in XL2003 - but not in XL2010. Have searched forum, but need someone to amend my specific bit of inherited code. Cheers ! 'RECORDED FROM A CSV FILE SAVED TO XL 'ChDir "C:\Users\Mark\Desktop"...
  2. M

    application.filesearch fix needed

    Hi Newbie here posting for the first time, hi everyone. Ive been given an old spreadsheet to use and there's an issue with application.filesearch and excel 2010. The code is below. Could one of you nice guys recommend a fix for it?? Set blah = Application.FileSearch With...
  3. R

    Another Application.FileSearch replacement question

    I'm trying to fix some code written by someone else long ago. It makes use of application.filesearch to populate a few arrays and place the information in some listboxes. I've read many post on replacing the application.filesearch, but have not had any luck figuring this out. Any help would be...
  4. C

    Application.FileSearch Error

    Hi Guys, I am not good with VBA. Recently all are sytems are migrated from WIN XP to Win7. Since then whenever we run a specific macro we get an error. Can somebody help me fix the code.. PFB the code : Option Explicit Dim fd As FileDialog ' 'Declare a variable as a FileDialog object. Dim...
  5. S

    Replacement for Application.FileSearch

    Hi, I've been reading this forum for a while, but this is my first post. :) I've created in macro in Excel 2003 that uses Application.FileSearch to open all Excel files in a specified directory. I've used a variable (vinputfile) to hold name of the open file and the macro then copies cells...
  6. B

    Application.filesearch help

    Hi all I have just been upgraded here at work from office 2003 to office 2010 and now the following code doesnt work... With Application.FileSearch .NewSearch .LookIn = "\\LON0306.london.schroders.com\sim_spf$\Investment\Investment Selection\Fund Research &...
  7. M

    2007 Excel , No Application.FileSearch anymore Help

    Hi, Just got the new excel 2007 and foud it doesn't have the Application.FileSearch anymore, which we use quite a bit. I've been trying to work a way around it but have had no luck. I'm on a time crunch so thought for the first time I'll ask the internet for the first time out of desperation...

Watch MrExcel Video

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