u can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Vaibhav Joshi
>To: "excel-macros@googlegroups.com"
>Sent: Thursday, December 4, 2014 12:37 AM
>Subject: Re: $$Excel-Macros$$ Folder loop
>
>
&
Hi
It filters only xlsx file since you specified file xtension in beginning
only...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Dec 4, 2014 at 10:05 AM, Mandeep Baluja
wrote:
> Hey Vabz,
>
> it will loop the Next file means all the files reside
Hey Vabz,
it will loop the Next file means all the files reside in a folder having
the extension *xlsx ? *or all the files files reside in a folder having the
any extension it can be . ?
On Wednesday, December 3, 2014 5:37:03 PM UTC+5:30, Vabz wrote:
>
> hi
>
> First understand what *filename
hi
First understand what *filename = Dir()* is doing, its basically providing
next file name in folder for all file names..
So when you dont use *filename = Dir()* your *filename *variable is holding
your firs file name, & your first file name is never gonna be "" unless its
empty directory hence
Hey,
I am working on this code if i will not use statement *filename = Dir()*
then it goes into a infinite stage. May I know the reason why and why it's
stopped when i apply this line.
as Per the meaning of this line it will check all the rest of files.
Sub Select_Folder_and_copy_files_into_c
