• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to look all .xls file in computer using vba?

mahaveer

mahaveer

Member
is it possible that any vba code can search all the .xls file in my computer and then cut them and paster to my destination place......?


thanks in advance...


Regards

CA Mahaveer Somani
 
Mahaveer


It probably is possible to do this with VBA, but Why


You can use Explorer as is to do that


1. Select C: or other directory

2. Search for *.xls

3. When the search is complete, select any file, Ctrl A, Ctrl X (Cut)

4. Change to the new directory and Ctrl V (Paste)
 
thanks hui


i know all of this things...but i want to do this with vba only..so if you can help me in this situation then i will be thankful to you..


Regards

CA Mahaveer Somani
 
Hi, mahaveer!


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.

http://chandoo.org/forums/topic/excel-files-documenting-inspector


Regards!
 
You must log in or register to reply here.
Back
Top