Search:
Type: Posts; User: thejas
Search:
Search took 0.12 seconds.
-
Hi Everyone,
I'm trying to modify the VBA that i found in InterNET, I need to save the attachments to specific folder by Automatically.
But This Script will check only the Inbox, I need to check...
-
Okay.. Thank you so much westconn..
I'll try with your code.
Thank you so much for your code.
-
Thank you so much Westconn.
Its working, but i got an issue,
I run the code using F8 key (Step by Step), and found at first time it's not copy the data to the target, it just skip the below...
-
Thank you so much Westconn.
Its working, but i got an issue,
I run the code using F8 key (Step by Step), and found at first time it's not copy the data to the target, it just skip the below...
-
Hi Westconn,
I did changes on code, now its working for schenario 2.
but this always copy and paste the last row data only, i want to paste each row ony by one.
copy and paste the fist row, then...
-
Hi Westconn,
Thanks for your code. Its working but it's adding the data (Row) in same sheet (Sheet2) instead of transfer the data into sheet 1.
I have change the sheet no in code as below
...
-
Hi westconn,
Thanks for your reply,
The code that i attached is maybe wrong... because i tried for various scenarios... please never mind that code.
I have find the code on below link.
...
-
Hi Everyone.
Can any one Help me on this :confused::wave:
-
Hello Everyone,
I have an Workbook with some data. in that i need to copy some data by manually to another sheet to run another VBA. now i'm looking for if i get the data from sheet 2 by...
-
Thank you so much westconn..
It's working fine now...
:)
-
Yes... I've tried the same thing already...but i got an error like..." Method Open' of object'_Recordset' failed.
On this line
rs.Open Sql, cn ', adOpenStatic, adLockReadOnly
-
Thank you so much Westconn...
It's working perfectly...
One more thing...if i want to update end date column from dashboard sheet along with name and task...for that where/how i need to change in...
-
I got an Error on below mentioned line..Do i need to Check anything in Tools-->References option?
170365170367
Thanks
-
Hi Westconn,
Thanks for your code.. it's working fine for first name (first cell)...but i want to get all the names and task for the specific Project...is it possible.?
170333
Thanks
-
Hi Westconn,
Thanks for your code.. it's working fine for first name (first cell)...but i want to get all the names and task for the specific Project...is it possible.?
170331
Thanks
-
Hi Westconn
Actually In my Dasboard, some project has done by the Same person but different Task (Task is not in Default Letters). I want to fetch the list of person who all are working in the...
-
Hello Everyone,
I've a dashboard...in that first column has projects and second column has name of the employee. Some of the projects has done by same employee by various date.
For ex. In sheet2
...
-
Hi Westconn,
Exactly, your code working awesome.
Thank you so much.
Hello Ecniv,
I have tried your code, but it's not remove the entire row, again it just copy the data from that row to next...
-
Hi Westconn,
Exactly, your code working awesome.
Thank you so much.
Hello Ecniv,
I have tried your code, but it's not remove the entire row, again it just copy the data from that row to next...
-
Hi Westconn,
Thanks for your Reply,
I have a below code now but there is some error.
Sub Test()
Dim sht1 As Worksheet, sht2 As Worksheet
Dim i As Long
Dim Msg As String, Ans As Variant
Msg...
-
Hello Ecniv,
Actually I don't Any code for this.
-
Hello Ecniv,
Actually I don't Any code for this.
-
Hello Everyone,
I have a dashboard with lots of details, in that i have to cut and paste the completed row's to new sheet.(Manually)
Could you please anyone help me out to complete the below steps...
-
Hello Westconn,
Thank you so much.
It's working as what I want.
Once again, Thank you:)
-
Hello Westconn,
Thank you so much.
It's working as what I want.
Once again, Thank you:)
-
Hello Westconn,
The code for #2 is working well.
and when i try for #1, i got a Compile Error.
160485
and Please tell me , how to run both Worksheet Change code in Same Sheet?
I have combined...
-
Hello Westconn,
Thank you for your code, and it was worked well.
Could you please do some modifications for below steps?
1. Actually, if column 1 has other than Sales, then it is Locked the Entire...
-
Hello Westconn,
Thank you for your code, and it was worked well.
Could you please do some modifications for below steps?
1. Actually, if column 1 has other than Sales, then it is Locked the Entire...
-
Hello Experts,
I have a Trouble with Lock the Cells Based on the Cell Value.
If column A has Value as "Sales" then cells on Column B and C (on same row of the Column A Cell) should Unlock with...
-
Hi Westconn
Thank you so much.
You are the genius.I have tested this code... working perfectly...
Thanks a lot again:)
-
Hey Westconn
This is the code i have found from and tested
In this i want to do some changes..i have a lot of file path on A:A column but this code is working with only one path...
And also i...
-
I don't have code Westconn...
-
Hi Westconn
I'm not a Expert on VBA Scripts, Could you please tell me how to modify the Code?
Thanks you so much.
-
Hey Westconn
I tried that code..but that's replace all the special character from file path..but i need remove the special character if it is first letter on folder name.
Even the folder name has...
-
Hi Zvoni
Please find the sample file.
158939
-
Thanks for your reply Zvoni,
Actually i have a lot of file path in sheet1 A:A column on my workbook.
Few files and folders contains a special character as first letter.
I want to remove these...
-
Hi Everyone,
I want to remove the first letter if it is a Special character from folder and file name.
For Ex. File path like "@documents/#_file.pdf"
Then it should be like "documents/file.pdf"....
-
Thank you so much Elroy.
Perfect it was worked what i want.:)
-
Hello Everyone,
Anyone Help me, i want open the userform automatically when the cell A2 having 7 digits number or else the the message
should display like "Please enter 7 Digit".
Thanks in...
-
Yes..i made wrong.
Actually i have placed the code on module instead of this workbook..
Now its working good.
Thank you so much Westconn for your help.
|
Click Here to Expand Forum to Full Width
|