Here.
I made this one exclude anything with "XLS" in the filename.
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - J
Hi Paul,
This is running properly, but can we save the prepared file in same folder,
which we have selected.
One more thing, the code which you have shared previously for folder
creating & moving files in folder, is not running properly. its giving
error for DB director. If you can solve this, wo
I can have it skip the "M" value if it is found.
in the first and latest examples, your image number is found in the first part
of the "1-2x.jpg"But the second example had "1.2x-jpg"
trying to differentiate between THOSE values would be a little more difficult,
but possible.it that necessary?
Pau
Hi,
Each time, when i prepare upload sheet. article name might be different but
the naming after the article no would be similar.
On Mon, Feb 29, 2016 at 11:08 PM, Paul Schreiner
wrote:
> Those are not the same filename structure as in your previous sample
> filenames,
> but they match your o
Wait.. you WANT to remove the -M in the Article?
your latest sample includes the -M.
This one should remove it. Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the
Those are not the same filename structure as in your previous sample
filenames,but they match your original request.
This should work for you.
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At al
Hi,
Code is getting the article no, but not removing (-M) & also not parsing
the file names according to their view.
On Mon, Feb 29, 2016 at 10:44 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Hi Paul,
>
> Please check attached file & images.
>
> Thanks,
>
>
> On Mon, Feb 29, 2
Try this and see how it works Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
--
Hi Paul,
Please check the attached file, as asked.
Thanks,
Devendra
On Mon, Feb 29, 2016 at 7:29 PM, Paul Schreiner
wrote:
> Sorry for the delay.
> I spend 10-12 hours a day throughout the week on a computer.
> When a beautiful weekend comes along, I tend to spend my time doing other
> things
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
Sorry for the delay.I spend 10-12 hours a day throughout the week on a
computer.When a beautiful weekend comes along, I tend to spend my time doing
other things and never even APPROACHED my computer!
Please see my earlier response. Paul-
“Do all the good yo
There's not near enough information here to make a guess.I'd have to have the
entire workbook and test it myself.
However:You're in VBA Debug.Did you try stepping through one line at a time to
see where it's running into a problem?Do you have any "loops" that are not
terminating/exiting?
Paul--
IF I understand correctly, your task should be easily accomplished.I've done
something similar in the past.But my criteria was based on total file size.
Do ALL of your filenames consist of 7 fields separated by "-"?
If you were to use split() on your filenames, using "-" as a delimiterwould
field
Easily done, provided you give us some details!
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
--
Hey Pankaj,
Please look into this & assist.
Thanks,
Devendra
On Mon, Feb 29, 2016 at 3:22 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Please revert.
>
> On Sun, Feb 28, 2016 at 6:48 PM, Devendra Sahay <
> devendrasahanypt...@gmail.com> wrote:
>
>> Hi Experts,
>>
>> Sorry for po
Please revert.
On Sun, Feb 28, 2016 at 6:48 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Hi Experts,
>
> Sorry for posting such a big query on forum but this issue is time taking
> & i want to do it in smart way but not able to do. So please check the
> below mentioned scenario &
16 matches
Mail list logo