Click here to Skip to main content
15,887,596 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: CCC 2022-06-09 Pin
pkfox9-Jun-22 4:36
professionalpkfox9-Jun-22 4:36 
GeneralOi! Greg Utas! Pin
OriginalGriff8-Jun-22 23:00
mveOriginalGriff8-Jun-22 23:00 
GeneralRe: Oi! Greg Utas! Pin
Richard MacCutchan8-Jun-22 23:04
mveRichard MacCutchan8-Jun-22 23:04 
GeneralRe: Oi! Greg Utas! Pin
pkfox8-Jun-22 23:32
professionalpkfox8-Jun-22 23:32 
GeneralRe: Oi! Greg Utas! Pin
Greg Utas9-Jun-22 0:02
professionalGreg Utas9-Jun-22 0:02 
GeneralRe: Oi! Greg Utas! Pin
OriginalGriff9-Jun-22 0:08
mveOriginalGriff9-Jun-22 0:08 
GeneralRe: Oi! Greg Utas! Pin
Craig Robbins9-Jun-22 0:21
Craig Robbins9-Jun-22 0:21 
GeneralVBA code Pin
Balaji S Jun20228-Jun-22 20:06
Balaji S Jun20228-Jun-22 20:06 
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








GeneralRe: VBA code PinPopular
OriginalGriff8-Jun-22 20:09
mveOriginalGriff8-Jun-22 20:09 
GeneralRe: VBA code Pin
Richard MacCutchan8-Jun-22 23:03
mveRichard MacCutchan8-Jun-22 23:03 
GeneralRe: VBA code Pin
Balaji S Jun20229-Jun-22 3:08
Balaji S Jun20229-Jun-22 3:08 
GeneralRe: VBA code Pin
Richard MacCutchan9-Jun-22 3:29
mveRichard MacCutchan9-Jun-22 3:29 
GeneralRe: VBA code Pin
dandy729-Jun-22 3:34
dandy729-Jun-22 3:34 
GeneralRe: VBA code Pin
Richard MacCutchan9-Jun-22 3:54
mveRichard MacCutchan9-Jun-22 3:54 
GeneralRe: VBA code Pin
dandy729-Jun-22 11:28
dandy729-Jun-22 11:28 
GeneralRe: VBA code Pin
Richard MacCutchan9-Jun-22 20:59
mveRichard MacCutchan9-Jun-22 20:59 
GeneralRe: VBA code Pin
dandy7210-Jun-22 11:16
dandy7210-Jun-22 11:16 
GeneralWordle 355 Pin
Amarnath S8-Jun-22 14:25
professionalAmarnath S8-Jun-22 14:25 
GeneralRe: Wordle 355 Pin
Peter_in_27808-Jun-22 15:25
professionalPeter_in_27808-Jun-22 15:25 
GeneralRe: Wordle 355 Pin
OriginalGriff8-Jun-22 18:12
mveOriginalGriff8-Jun-22 18:12 
GeneralRe: Wordle 355 Pin
Sander Rossel8-Jun-22 20:00
professionalSander Rossel8-Jun-22 20:00 
GeneralRe: Wordle 355 Pin
OriginalGriff8-Jun-22 20:05
mveOriginalGriff8-Jun-22 20:05 
GeneralRe: Wordle 355 Pin
Amarnath S8-Jun-22 20:09
professionalAmarnath S8-Jun-22 20:09 
GeneralRe: Wordle 355 Pin
den2k888-Jun-22 20:58
professionalden2k888-Jun-22 20:58 
GeneralRe: Wordle 355 Pin
ChandraRam8-Jun-22 20:59
ChandraRam8-Jun-22 20:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.