Search:
Type: Posts; User: gmmdinesh
Search:
Search took 0.02 seconds.
-
Hi GBeats and Westconn,
I have resolved the above issue myself.
Thank you so much for your Code and help.
:)
-
Hi GBeats,
Thanks for your reply, It works fine.
But it move all the (Read and Unread) to Deleted Items, I want to move only Unread Items.
Thanks again
-
Hi Westconn,
Thanks for your code, when i try to your code i'm getting Type mismatch error with i on below line,
Thanks
-
Hi Everyone,
I have a VBA to save the attachment from unread emails one by one on shared mailbox. but this VBA looping only 2 times. (It will check and save the attachments with 2 mails only). I...
-
Hello Everyone,
I have to fill some data from Work book to Web page on daily basis. web page looks like workbook, they have sequence order (Element id like...
-
Hello Westconn and Zvoni
Thanks for your code.
It's working as i want. and Zvoni i have tested your code but i got Error on this line.
If MyWorksheet.Cells(CurRow, 5)="E" Then
-
Hi Zvoni,
Thanks for your reply.
Actually I have some data on cells left of column E.. I don't need that...I just want to delete entire row if right of column E is blank.
-
Hello everyone,
I have lot of data in my work book. In that i need to delete the row which contains Letter "E" in column E and the other cells are blank.
So if the rows having letter "E" on...
-
Hello vbfbryce,
It was worked Perfectly .
Thank you so much.:)
-
-
Hello vbfbryce,
Your code is working well...
It's working only for A1 cell..i want to do the changes on entire cells on Column A...
Please tell me what changes makes this vba to changes cells on B...
-
Hi JDC,
Thanks for your Reply.
Please see the attached sample file.
160387
-
Hi Everyone,
I have a problem on my dashboard. I want to do the following in my dashboard.
If A1 cell contains Yes, the a list of drop down should available on Cell B1, If Cell A1 contains No or...
-
Hey Westconn
I have changed that line as you mentioned on post#9
But i got the same error..
-
Actually I don't want to run with local drive..If it is working with only for Network drive that's enough.
Anyone help me please,:confused:
-
Oldpath is \\lte.cell\UMTS\Strat\RTD\Folder\Trans\Misc Folder\@#sam#_
Ans I'm not aware of vbdirectory
-
Hey Zvoni
Actually I'm not Expert on VBA..
My problem is the vba shows error while trying to replace special character.
Can you please give me the suggestion.
-
Hello Everyone,
I have a VBA code to replace the Special Characters from folder path.. and this VBA i got from this forum.
This VBA worked well with Local Drive Path but when i try to run vba with...
-
Hi Westconn
Thank you so much for your help.
Now it's working perfectly.
I have placed two different path in A1 and A2 cell, code was replaced special character in both the path.
Thank you so...
-
Hello Westconn
I have tested again the code you posted on post #22. now it's working perfectly.
I have placed full path in A1 and A2 cell, (A1 Cell Path: E:\temp\123456\a@ujhguy\a@v%bv\@#%
A2...
-
Hey Westconn
Can you please tell me,Which 2 variables i have to check.
-
I got the File/Path Access Error on this code.
-
Yes, You are correct westconn, we can rename only one folder at a time.
This was worked when i placed the path upto one folder,
Thank you so much.
-
Hey I got same error again..I don't know why the error is coming.
I did call DIR it shows path exist, but VBA not changed the path.
Anyway Thanks for your effort, Much Appreciated.
Thanks again.
-
Hi Westconn
I got a "File not found Error" on this line , even i have a correct folder names and path as mentioned in A column.
-
Hi Westconn
Sorry for the misunderstanding, I have tested both the codes as you posted, but i got error on it.
Please look the attached file.
157159
-
This is the code i have used,
Sub Test()
Dim afind, areplace
afind = Array("@", "#", "%", "_")
areplace = Array("AT", "NUMBER", "PERCENT", "UNDERSCORE")
mypath = "c:\temp\" 'change to suit...
-
Hi Westconn
I got a "Type Mismatch" Error on this Line
-
Yes these listed folders are placed on E:\Temp\ Path, but i don't know, where i have to put the path in VBA,
Where i have to paste this code.?
Please help me ..
-
Hello Leith Ross
Sorry for the delay and Thanks for your Code,
I have checked your code and I got a Debug Error as below.
156717
I have a work book with folder names on A Column and attached...
-
Thank you so much for provide the Links,
@ westconn, Leith ross, your code is working perfectly, Thank you so much for your Time.
I have a Workbook with list of parent folder name with A column, I...
-
Hi Everyone,
I have a large amount of folder with sub folders, the folder name contains some special characters (@,#,%,_,-) Like that.
I have to find the folder by Main folder name,then replace...
-
Exactly..this is working perfectly.
Thank you so much for your work.
-
Exactly..this is working perfectly.
Thank you so much for your work.
-
It's working perfectly as you told..but it was highlighted the cell which contained "South" but i want to highlight other cells (except the South).
In actual workbook comes with different values...
-
Exactly this is what i want...working perfectly.
One more thing i want to do..could you please tell me how to highlight specific cell by value by header name
for ex. first we need to find the...
-
I have tested in same workbook but it doesn't highlight anything.same time I'm not getting any error.
-
Hi Westconn
I have checked your code, but it's not working.
-
Thanks westconn
It's working. but it was highlight when the whole column is blank, also i want to highlight if any one cell is blank then that whole column should be highlighted.
In each workbook...
-
Hi Everyone,
Need help again,. I have a excel worksheet that have so many headers. I want to highlight if any cells are blank on specific column, that whole column should be highlighted.
This...
|
Click Here to Expand Forum to Full Width
|