|
i am new to Coding can you please help, request coding in Microsoft visual basic I have below
1)Macro button available with some script in c6 cell excel
2)A link available in e6, this link is for notepad file available in share path share path name like \\shuryy01\windows\log.txt"
3)An empty cell available in i6
Now aim is if we click macro button it will open particular notepad file by click link available e6 cell and copy last 6 lines and paste in empty cell available in i6 cell in excel sheet. Can pls provide the code for this I will update in macro button and can try.
Note: in notepad file daily some log generating how ever if we click macro last 6 lines need to copy and paste i6 cell excel sheet
|
|
|
|
|
A couple of things:
1) Start paying attention to your surroundings. Look at the top of this page and you will see in bright red letters that this isn't the place for technical queries. So if you want to make people happy, post this in the right place. Happy people give better help than annoyed ones do...
2) Post it here:http://www.codeproject.com/Questions/ask.aspx[^] but think first: Remember that we can't see your screen, access your HDD, or read your mind - we only get what you tell us to work from. So write your question based on that!
3) Explain exactly what you have tried, and where you are stuck. The more accurate you are the better the response.
4) While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.
So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.
If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
You can easily generate the code yourself by using the Macro record feature of Excel.
|
|
|
|
|
Hi no I tried this but not works because this in this single notepad daily basis some log generating it so when we use macro it copy paste same content always but as mentioned in question our aim is need to copy paste final 6 linea in notepad that means what log generating daily basis as new
|
|
|
|
|
There is more to programming than copy and paste. Using the recorder will just give you a copy of the steps you took. You will now need to modify the macro to your own requirements.
|
|
|
|
|
The fact that this escaped him boggles the mind...especially considering that for a lot of people, programming is taking an existing solution that gets you halfway there, and adapting the rest to suit your own purposes.
|
|
|
|
|
dandy72 wrote: The fact that this escaped him boggles the mind...
No, it's quite common if you spend time in the Quick Answers forum. There seems to be a class of 'developers' who find it difficult to think for themselves.
|
|
|
|
|
Well, that's the problem I'm pointing out...if you don't have the ability to form that thought yourself...your future as a "developer" is probably quite limited.
|
|
|
|
|
I agree completely, but that doesn't stop people thinking they can become developers by learning Copy and Paste. 
|
|
|
|
|
I'm just thinking of time I've wasted going over resumes...there's very little I've come to dread more in terms of work-related duties than reviewing resumes or conducting interviews.
|
|
|
|
|
Wordle 355 4/6
⬜⬜🟨⬜⬜
⬜🟨🟨⬜🟨
🟨🟩🟨⬜🟨
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 355 6/6
⬜⬜🟩🟩🟩
⬜⬜🟩🟩🟩
⬜🟩🟩🟩🟩
⬜🟩🟩🟩🟩
⬜🟩🟩🟩🟩
🟩🟩🟩🟩🟩
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
It's that first word again:
Wordle 355 3/6
🟨🟩⬜⬜⬜
⬜🟩🟨🟨🟨
🟩🟩🟩🟩🟩
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Wordle 355 6/6
🟨⬜🟨⬜⬜
⬜⬜🟨⬜⬜
🟨🟩⬜⬜⬜
⬜⬜⬜⬜⬜
🟨🟩🟨⬜🟨
🟩🟩🟩🟩🟩
I was just about to give up when this happened 
|
|
|
|
|
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
4/6
⬜⬜🟩⬜⬜
⬜⬜🟩🟩⬜
⬜🟩🟩🟩🟩
🟩🟩🟩🟩🟩
A bit of luck since I had another valid choice for the last one, also my starter never disappoints.
GCS/GE d--(d) s-/+ a C+++ U+++ P-- L+@ E-- W+++ N+ o+ K- w+++ O? M-- V? PS+ PE Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
Wordle 355 5/6*
🟨⬜🟨⬜🟨
⬜🟩⬜🟩🟩
⬜🟩⬜🟩🟩
⬜🟩🟩🟩🟩
🟩🟩🟩🟩🟩
Happiness will never come to those who fail to appreciate what they already have. -Anon
|
|
|
|
|
Wordle 355 3/6*
⬜🟨⬜⬜⬜
🟨🟩🟨🟨🟨
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 355 4/6
⬜⬜🟨⬜⬜
🟨🟨⬜⬜⬜
🟨🟩🟨🟨🟨
🟩🟩🟩🟩🟩
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Wordle 355 4/6*
⬛⬛⬛🟨⬛
🟨🟩⬛⬛⬛
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
Wordle 355 3/6
⬛🟨⬛🟨⬛
🟨⬛🟨⬛🟨
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 355 4/6
⬛⬛⬛⬛⬛
🟨🟨⬛⬛⬛
⬛🟩🟩⬛🟨
🟩🟩🟩🟩🟩
Get me coffee and no one gets hurt!
|
|
|
|
|
Wordle 355 4/6
⬛⬛⬛⬛🟨
🟨🟨⬛⬛⬛
⬛⬛🟩⬛🟨
🟩🟩🟩🟩🟩
|
|
|
|
|
If you are in Visual Studio Code or Visual Studio and editing code you can do CTRL-G and type a line number and go directly to that line in your source code.
My Humble Suggestion For Outlook
Please create a feature where I can do CTRL-G in the Outlook client where I can type a date in and go to the first email received on that date.
I have 14 years of email & I need to go to a specific date a couple of years ago. It is difficult to scroll (so many email they just flash by) to get to a specific date.
Also, please don't suggest search by date, because
1) I am lazy
2) the search doesn't work that great (it's quite annoying)
I want to GO directly to those email for that date.
Have you ever suffered through this also? Outlook haters, unite!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
