Need urgent help please give your input as soon as possible
Please Login or Register to view this content.
Need urgent help please give your input as soon as possible
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
what's you goal ? renaming all files in sPath ? you can do it without opening notepad
If solved remember to mark Thread as solved
Hi -
See if this helps you.
http://www.mrexcel.com/forum/excel-q...g-excel-2.html
event
If you upload a dummy file then I can test this:
abousettaPlease Login or Register to view this content.
Last edited by abousetta; 03-04-2013 at 09:22 AM. Reason: Removed the excess transpose
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
@patel45,
Thanks for your reply and it is not renaming task and I believe part of my code describe about my requirement.
Anyhow thanks for the reply
@ event21,
Thanks for providing the link but I have already seen that post but I am not interested to use it since the code is something seems to be huge and I don't want to do it with complex coding when it can be done in a simple way
@ abousetta,
Thanks for providing the code and that is what exactly I was waited for...
But I got an error while trying to test your code. Please refer the attached screenshots to fix it
Data-2-Screenshot.JPG
Error Line Screenshot.jpg
Data-1-Screenshot.JPG
change
toPlease Login or Register to view this content.
for a column rangePlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Good catch JP.
abousetta
Thanks to everyone and now it's working fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks