Re: $$Excel-Macros$$ Request for Directory Audit Macro

2011-08-18 Thread crazybond 
Thanks guys for your kind assistance, one more thing. Rajan can you provide
me this one on XL 2000-2003? Cause where I want to use this does not have XL
2007-2010


Regards
J

On Thu, Aug 18, 2011 at 1:48 PM, XLS S  wrote:

> Great Job Rajan.
>
> On Thu, Aug 18, 2011 at 10:02 AM, Rajan_Verma 
> wrote:
> > Try the attached Workbook,
> >
> >
> >
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> > On Behalf Of dguillett1
> > Sent: Thursday, August 18, 2011 2:54 AM
> >
> > To: excel-macros@googlegroups.com
> > Subject: Re: $$Excel-Macros$$ Request for Directory Audit Macro
> >
> >
> >
> > Look in the vba help index for DIR
> >
> >
> >
> > From: crazybond
> >
> > Sent: Wednesday, August 17, 2011 3:30 PM
> >
> > To: excel-macros@googlegroups.com
> >
> > Subject: $$Excel-Macros$$ Request for Directory Audit Macro
> >
> >
> >
> > Hi Experts,
> >
> >
> >
> > Can a vba code/macro be created/ is available in case one needs to do the
> > audit on the directory/sub-folders/files and get the output of the same
> in
> > excel sheet with exact name of the file(s) with extension, its
> location(kind
> > of hyper linked to the files)? And it should ask you what kind of
> > files(.extensions) you are looking for kind of thing? I am looking for
> file
> > extensions - basically all MS office files, .mp3, .avi, .txt, .pdfs.
> >
> >
> >
> > And also by any chance if you can re-name these file names in the excel
> > sheet and file's name automatically gets updated at its source.
> >
> >
> >
> >
> >
> > Regards
> > J
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
>
> --
> .
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Request for Directory Audit Macro

2011-08-18 Thread XLS S 
Great Job Rajan.

On Thu, Aug 18, 2011 at 10:02 AM, Rajan_Verma  wrote:
> Try the attached Workbook,
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of dguillett1
> Sent: Thursday, August 18, 2011 2:54 AM
>
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Request for Directory Audit Macro
>
>
>
> Look in the vba help index for DIR
>
>
>
> From: crazybond
>
> Sent: Wednesday, August 17, 2011 3:30 PM
>
> To: excel-macros@googlegroups.com
>
> Subject: $$Excel-Macros$$ Request for Directory Audit Macro
>
>
>
> Hi Experts,
>
>
>
> Can a vba code/macro be created/ is available in case one needs to do the
> audit on the directory/sub-folders/files and get the output of the same in
> excel sheet with exact name of the file(s) with extension, its location(kind
> of hyper linked to the files)? And it should ask you what kind of
> files(.extensions) you are looking for kind of thing? I am looking for file
> extensions - basically all MS office files, .mp3, .avi, .txt, .pdfs.
>
>
>
> And also by any chance if you can re-name these file names in the excel
> sheet and file's name automatically gets updated at its source.
>
>
>
>
>
> Regards
> J
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Request for Directory Audit Macro

2011-08-17 Thread ashish koul 
http://akoul.blogspot.com/2011/07/print-file-names-in-folder-to-excel-on.html

http://akoul.blogspot.com/2011/06/rename-files-in-vba.html


On Thu, Aug 18, 2011 at 5:27 AM, XLS S  wrote:

> Hey Crazybond,
>
> Please find the attachment ...
>
> On Thu, Aug 18, 2011 at 2:00 AM, crazybond  wrote:
> > Hi Experts,
> > Can a vba code/macro be created/ is available in case one needs to do the
> > audit on the directory/sub-folders/files and get the output of the same
> in
> > excel sheet with exact name of the file(s) with extension, its
> location(kind
> > of hyper linked to the files)? And it should ask you what kind of
> > files(.extensions) you are looking for kind of thing? I am looking for
> file
> > extensions - basically all MS office files, .mp3, .avi, .txt, .pdfs.
> > And also by any chance if you can re-name these file names in the excel
> > sheet and file's name automatically gets updated at its source.
> >
> > Regards
> > J
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
>
> --
> .
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Request for Directory Audit Macro

2011-08-17 Thread dguillett1 
Look in the vba help index for DIR

From: crazybond 
Sent: Wednesday, August 17, 2011 3:30 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Request for Directory Audit Macro

Hi Experts, 

Can a vba code/macro be created/ is available in case one needs to do the audit 
on the directory/sub-folders/files and get the output of the same in excel 
sheet with exact name of the file(s) with extension, its location(kind of hyper 
linked to the files)? And it should ask you what kind of files(.extensions) you 
are looking for kind of thing? I am looking for file extensions - basically all 
MS office files, .mp3, .avi, .txt, .pdfs. 

And also by any chance if you can re-name these file names in the excel sheet 
and file's name automatically gets updated at its source.


Regards
J
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel