Re: $$Excel-Macros$$ Help on Week Formula

2017-07-30 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Sun, 7/30/17, Chandra Shekar  wrote:

 Subject: Re: $$Excel-Macros$$ Help on Week Formula
 To: excel-macros@googlegroups.com
 Date: Sunday, July 30, 2017, 2:57 PM
 
 Hello
 Paul,
 For Ex: If I
 mention date as 07/01/2017(Sat) formula should give Week 1
 from there every week it should increase by 1.1)
 07-01-2017 to 07-07-2017 = Week12) 22-01-2017 to
 28-07-2017 = Week43) 29-07-2017 - 04-08-2017 =
 Week5
 Regards,
 Chandru
 On Tue, Jul 25, 2017 at
 4:31 PM, Paul Schreiner 
 wrote:
 I
 think you'll need to be more specific on how you want
 the "weeks" calculated.For
 instance, in August (2017) August 1 is on  a
 Tuesday.
 so,
 the weeks are handled:
 
 but,
 July 1 is on a Saturday,so,
 does Week 1 only have a single day?
 Or
 is July 1 counted as part of week 5 of June.If
 so, what is the minimum number of days counted in a week
 1?
 Or
 are you wanting a simple count of days:Week
 1 = first 7 daysWeek
 2 = Second 7 daysetc.
  Paul--
 ---
 “Do
 all the good you can,
 By all the means you
 can,
 In all the ways you can,
 In all the places you can,
 At
 all the times you can,
 To all the people you
 can,
 As long as ever you can.” - John
 Wesley
 --
 ---
 
 
  
   On Tuesday, July 25, 2017 3:34 AM,
 Chandra Shekar 
 wrote:
   
 
  Hello Team,
 Could you please help me in attached
 week formula.
 Regards,
 Chandru
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/
 discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@
 googlegroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/
 group/excel-macros.
 
 For more options, visit https://groups.google.com/d/
 optout.
 
 
 
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/
 discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@
 googlegroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/
 group/excel-macros.
 
 For more options, visit https://groups.google.com/d/
 optout.
 
 
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and 

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 updates in 2 topics

2017-05-29 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Tue, 5/30/17, David Lanman  wrote:

 Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 
updates in 2 topics
 To: excel-macros@googlegroups.com
 Date: Tuesday, May 30, 2017, 2:39 AM
 
 It seems the first
 question must be "what is purpose, what are you trying
 to accomplish?" thanks, David
 
 On Mon, May 29, 2017
 at 4:26 PM,  
 wrote:
 
 
   
 
   
 
   
 
   
   excel-macros@googlegroups.com
 
   
   
 Google
 Groups
   
   
 
   
 
   
 
   
   
 
 
 
   
   
   
 Topic digest
   
   
 
   
 View
 all topics
   
 
 
   
   
 
   
   Process Flow Document for Dashboard designing -
   1 Update
 
   
 
   
   Links -
   1 Update
 
   
   
 
 
 
 
   
   
   
   
 
   Process Flow Document for Dashboard designing
 
   
   
 
   
 
   
 
   Secret Shot :
 May 29 02:20PM +0530
 
 
 
 
 Hi Experts,
 
  
 
 I have recently joined a job where i have to design new
 dashboard for any
 
 new clients comes in.
 
  
 
 I am okay with dashboard designing, but my boss has asked me
 to define a
 
 proper process for dashboard designing , step wise step like
 discussion -
 
 data gathering - planning - designing etc. . .
 
  
 
 I want your help, if anyone have any such kind of dashboard
 designing
 
 process document.
 
  
 
 Pls Help.
 
  
 
 -- 
 
 Pankaj Pandey
 
 Bhopal
 
 
   
 
   
   
 Back to top
   
 
 
   
   
   
   
 
   Links
 
   
   
 
   
 
   
 
   Minta Spriggs :
 May 29 08:39AM
 
 
 
 
 -- --
 
 On Fri, 5/26/17, KAUSHIK SAVLA 
 wrote:
 
  
 
  Subject: Re: $$Excel-Macros$$ Links
 
  To: "MS EXCEL AND VBA MACROS" 
 
  Date: Friday, May 26, 2017, 10:10 PM
 
  
 
  Hi Paul, 
 
  
 
  
 
  I followed the instructions. 
 
  
 
  However what's happening is the macro
 
  is just showing running and not giving any outcome. 
 
  
 
  I kept it running for nearly 3 hours. 
 
  
 
  Regards, 
 
  Kaushik
 
  
 
  -- 
 
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 
  in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)
 !
 
  Join official Facebook page of this forum @ https://www.facebook.com/
 discussexcel
 
  
 
  FORUM RULES
 
  
 
  1) Use concise, accurate thread titles.
 
  Poor thread titles, like Please Help, Urgent, Need Help,
 
  Formula Problem, Code Problem, and Need Advice will not
 get
 
  quick attention or may not be answered.
 
  2) Don't post a question in the thread
 
  of another member.
 
  3) Don't post questions regarding
 
  breaking or bypassing any security measure.
 
  4) Acknowledge the responses you
 
  receive, good or bad.
 
  5) Jobs posting is not allowed.
 
  6) Sharing copyrighted material and
 
  their links is not allowed.
 
  
 
  NOTE  : Don't ever post
 
  confidential data in a workbook. Forum owners and members
 
  are not responsible for any loss.
 
  --- 
 
  You received this message because you
 
  are subscribed to the Google Groups "MS EXCEL AND VBA
 
  MACROS" group.
 
  To unsubscribe from this group and stop
 
  receiving emails from it, send an email to excel-macros+unsubscribe@
 googlegroups.com.
 
  To post to this group, send email to excel-macros@googlegroups.com.
 
  Visit this group at
 
  https://groups.google.com/
 group/excel-macros.
 
  For more options, visit
 
  https://groups.google.com/d/
 optout.61in extrema stanga a vietii politice interbelice
 s-au aflat comunistii. De fapt  idul Comunist din Romania a
 actionat ca sectie a Cominternului. in 1920  in ui
 Partidului Socialist a existat o confruntare intre opinia
 constituirii unui d comunist si afilierea la Comintern si
 cea a unificarii intregii miscari citoresti si apoi
 afilierea sa la forul mai sus mentionat. in toamna lui 1920 
 o gatie a socialistilor romani a vizitat Rusia Sovietica 
 unde a discutat conditiile fii la organismul comunist
 mondial. Neacceptarea lor de catre losif anca  loan Flueras 
 G. Grigorovici a dus ulterior la excluderea lor din jucerea
 socialista sub presiunea elementelor stangiste. La 8 mai
 1921  lentele de extrema stanga din Partidul Socialist au
 pus bazele Partidului nunist. Partidul Socialist s-a
 disociat de acesta. Autoritatile  constiente de  O|UI
 reprezentat de noua organizatie  au intervenit si au arestat
 pe
 unii cipanti la Congresul de constituire. in 1922 a avut loc
  totusi  la Ploiesti  gresul al II  la care au participat 34
 delegati.
 
 
   
 
   
   
 Back to top
   
 
 
 
 
   
   
   
   
 
   
   You received this digest 

Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-23 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Tue, 5/23/17, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ Need help in Vba Macro
 To: "excel-macros@googlegroups.com" 
 Date: Tuesday, May 23, 2017, 9:53 PM
 
 That's
 very CPU intensive because it copies all cells to the
 clipboardand
 pastes them from clipboard.which
 can be a HUGE number of cells for each sheet.
 If
 you simply want to break the external links, you can use
 something like:
 alinks
 = ActiveWorkbook.LinkSources(xlExcelLinks)
    
 
    
 If Not IsEmpty(alinks) Then
    
 For inx = 1 To UBound(alinks)
    
 ActiveWorkbook.BreakLink _
    
 Name:=alinks(inx), _
    
 Type:=xlLinkTypeExcelLinks
    
 Next inx
    
 End If
 This
 will break links to EXTERNAL workbooks (and convert to
 values) but
 it doesn't do anything to the links to worksheets within
 the current workbook.
 does
 that help? Paul-
 “Do all the
 good you can,
 By all the means you can,
 In all the ways you can,
 In all
 the places you can,
 At all the times you
 can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 -
 
 
 
On Tuesday, May 23,
 2017 2:03 PM, KAUSHIK SAVLA 
 wrote:
   
 
  Hi Team,
 I am trying to do below in an excel.
 You can assume there are 60 worksheets minimum in a
 workbook.
 1. In opened
 excel file. Which has links from several files2.
 All cells of the workbook I am doing paste special
 values3. Then to come at the first cell in all
 worksheets (i.e. Cell A1)4. Then to come at first
 tab, first cell, Save the workbook here (so whenever excel
 opens the person will see first sheet, first
 cell)5. Close the workbook
 I am having below vba code. It is
 taking forever to run (minimum 15-20 minutes). Can anyone
 please help in boosting speed so could be run in fraction of
 seconds.
 
 Sub
 Select_All_Sheets()Dim sht As
 WorksheetDim SelectMe() As StringDim s
 As IntegerFor Each sht In Worksheetss
 = s + 1ReDim Preserve SelectMe(1 To s) As
 StringSelectMe(s) =
 sht.NameSheets(SelectMe).SelectCells.Select 
   Selection.Copy    Selection.PasteSpecial
 Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks
 _        :=False,
 Transpose:=False    Application.CutCopyMode =
 False    Application.Goto
 Range(Cells(ActiveWindow.SplitRow + 1,
 ActiveWindow.SplitColumn + 1).Address)   
 ActiveWorkbook.SaveNextEnd
 Sub
 Regards,Kaushik
 Savla
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/group/excel-macros.
 
 For more options, visit https://groups.google.com/d/optout.
 
 
  

 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.
 
 To post to this group, 

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-13 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Thu, 4/13/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Thursday, April 13, 2017, 4:49 PM
 
 
 
 On Thu, 4/13/17, Paul Schreiner 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: "excel-macros@googlegroups.com"
 
  Date: Thursday, April 13, 2017, 2:49
 PM
  
  Here's
  the approach I took:I
  defined a "public" Dictionary object
 called
  Dict_Category.I
  created a function to load the
 Dict_Category with the
  category listing from the "DATA"
 sheet.
  Being
  a "public" variable, the values are
 retained while
  the workbook is open.
  I
  created two worksheet
 events:Worksheet_SelectionChangeWorksheet_Change
  I
  created two events so that the
 Comments update when the cell
  is selected, and also if you were to
 copy/paste several
  cells into column "A".
  Personally,
  I think the Change event is the only
 one that is
  required.
  The
  Update_Comments function does things
 like:-
  Clears the comments from cells that
 are blank-
  Shows a message if a value is entered
 that is not in the
  Dictionary
  hope this gives you something to work
  from.
  
 
 Paul-
  “Do
  all the good you can,
  By all the means you can,
  In all the ways you can,
  In all the places you can,
  At all the times you can,
  To all the people you can,
  As long as ever you can.” - John
 Wesley
 
 -
  
  
   
    On Thursday, April 13, 2017
 5:26 AM,
  sunil lobo 
 wrote:
    
  
   hi [U][SIZE=5]just want to
  have comments populate when the cell
 is selected based on
  the lookup/vlookup function through
  VB[/SIZE][/U]two sheet 1) master_sheet
  2
  )data sheet masters sheet being
  dynamic data sheet is
  staticmaster sheet continuosly
  changing now when  a particular cell
 is
  activated by using mouse or
  keyboard comments should pop-up
 getting
   the value from the next data
 sheet 
  eg: master sheet , cell a2= 1 
                 
          cell a3=2 
                 
          cell a4=4so on and so
  forth 
  in data sheet , cell a2= 5 , cell b2=
  present           
                a3=2, cell
  b3= absent         
                  a4=
  3,cell b4= leave        
                 
      a5= 1, cell b5= leftnow when i
  select a3 cell in master_sheet i need
 to populate a comment
  as [B]absent[/B], when the cell a3
 changes to value [B]1[/B]
  i should get a comment display of
 value
  [B]left[/B]also when the cell value
 changes it
  chsould clear the previous
 comment basically
  it should popup comments based on the
 value from the data
  sheet !:)
  attaching herewith the sample data for
 ur
  reference
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you
 receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and
 their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post
 confidential data in a workbook.
  Forum owners and members are not
 responsible for any loss.
  
  --- 
  
  You received this message because you
 are subscribed to the
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
  
  To unsubscribe from this group and
 stop receiving emails
  from it, send an email to
 excel-macros+unsubscr...@googlegroups.com.
  
  To post to this group, send email to
 excel-macros@googlegroups.com.
  
  Visit this group at
 https://groups.google.com/group/excel-macros.
  
  For more options, visit
 https://groups.google.com/d/optout.
  
  
       
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any 

Re: $$Excel-Macros$$ Re: Macros for screenshot

2017-04-08 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Sat, 4/8/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot
 To: excel-macros@googlegroups.com
 Date: Saturday, April 8, 2017, 11:09 PM
 
 
 
 On Sat, 4/8/17, 'Julienne Schindler'
 via MS EXCEL AND VBA MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re:
 Macros for screenshot
  To: excel-macros@googlegroups.com
  Date: Saturday, April 8, 2017, 11:06
 PM
  
  
 
 
  On Sat, 4/8/17, mintaspriggs via MS
  EXCEL AND VBA MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Re:
  Macros for screenshot
   To: excel-macros@googlegroups.com
   Date: Saturday, April 8, 2017,
 10:51
  PM
   
   
  
 
 
   On Sat, 4/8/17, 'Yu Spain' via
 MS
  EXCEL
   AND VBA MACROS 
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Re:
   Macros for screenshot
    To: excel-macros@googlegroups.com
    Date: Saturday, April 8, 2017,
  9:11
   PM
    
    
   
  
 
 
    On Sat, 4/8/17, 'Julienne
  Schindler'
    via MS EXCEL AND VBA MACROS
  
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   Re:
    Macros for screenshot
     To: excel-macros@googlegroups.com
     Date: Saturday, April 8,
 2017,
   7:49
    PM
     
     
    
   
  
 
 
     On Sat, 4/8/17, 'Julienne
   Schindler'
     via MS EXCEL AND VBA MACROS
   
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    Re:
     Macros for screenshot
      To: excel-macros@googlegroups.com
      Date: Saturday, April 8,
  2017,
    8:18
     PM
      
      
     
    
   
  
 
 
      On Sat, 4/8/17, 'Karleen
  Biggs'
    via
     MS
      EXCEL AND VBA MACROS 
      wrote:
      
       Subject: Re:
   $$Excel-Macros$$
     Re:
      Macros for screenshot
       To: excel-macros@googlegroups.com
       Date: Saturday, April 8,
   2017,
     5:28
      PM
       
       
      
     
    
   
  
 
 
       On Sat, 4/8/17,
 mintaspriggs
   via
     MS
       EXCEL AND VBA MACROS
 
       wrote:
       
        Subject: Re:
    $$Excel-Macros$$
      Re:
       Macros for screenshot
        To: excel-macros@googlegroups.com
        Date: Saturday, April 8,
    2017,
      2:57
       PM
        
        
       
      
     
    
   
  
 
 
        On Sat, 4/8/17, 'Derrick
    Andrew'
      via
       MS
        EXCEL AND VBA MACROS
  
        wrote:
        
         Subject: Re:
     $$Excel-Macros$$
       Re:
        Macros for screenshot
         To: excel-macros@googlegroups.com
         Date: Saturday, April
 8,
     2017,
       2:53
        PM
         
         
        
       
      
     
    
   
  
 
 
         On Sat, 4/8/17,
   'Carmelita
       Cronin'
        via
         MS EXCEL AND VBA
 MACROS
     
         wrote:
         
          Subject: Re:
      $$Excel-Macros$$
        Re:
         Macros for screenshot
          To: excel-macros@googlegroups.com
          Date: Saturday, April
  8,
      2017,
        10:13
         AM
          
          
         
        
       
      
     
    
   
  
 
 
          On Sat, 4/8/17, priti
    verma
        
          wrote:
          
           Subject: Re:
       $$Excel-Macros$$
         Re:
          Macros for screenshot
           To: excel-macros@googlegroups.com
           Date: Saturday,
 April
   8,
       2017,
         9:03
          AM
           
           first you
           need to open that
   excel
     file
         and
          activate that
  particular
           excel file by using
          application.actiavte
      "workbbok
           name" and paste
 into
     excel
       file
         in
          desired
           range.
           On Fri, Mar 31,
 2017
   at
           4:40 PM, suresh k
   
           wrote:
           Experts any inputs
 for
     the
         below
          requirement?
           On 23-Mar-2017 1:43
           pm, "suresh k"
 
           wrote:
           Hi All,
           I have 10 files in
 my
   c
       drive. I
         have
          to
           capture other
     applications
         screenshot
          and paste in all 10
           files.
           I am able to
 capture
       screenshot,
         but
      

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

2017-04-05 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Wed, 4/5/17, 'Storey Thomas' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Wednesday, April 5, 2017, 4:19 PM
 
 
 
 On Wed, 4/5/17, 'Yu Spain' via MS EXCEL
 AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re:
 Customized Inventory Software Required in Excel VBA
  To: excel-macros@googlegroups.com
  Date: Wednesday, April 5, 2017, 3:43
 PM
  
  
 
 
  On Wed, 4/5/17, 'Yu Spain' via MS
 EXCEL
  AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Re:
  Customized Inventory Software Required
 in Excel VBA
   To: excel-macros@googlegroups.com
   Date: Wednesday, April 5, 2017,
 2:27
  PM
   
   
  
 
 
   On Wed, 4/5/17, 'Margareta
 Tolliver'
   via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Re:
   Customized Inventory Software
 Required
  in Excel VBA
    To: excel-macros@googlegroups.com
    Date: Wednesday, April 5, 2017,
  7:21
   AM
    
    
   
  
 
 
    On Wed, 4/5/17, mintaspriggs via
  MS
    EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   Re:
    Customized Inventory Software
  Required
   in Excel VBA
     To: excel-macros@googlegroups.com
     Date: Wednesday, April 5,
 2017,
   6:25
    AM
     
     
    
   
  
 
 ----
     On Wed, 4/5/17, 'Hopkins
 Ruben'
   via
    MS
     EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    Re:
     Customized Inventory
 Software
   Required
    in Excel VBA
      To: excel-macros@googlegroups.com
      Date: Wednesday, April 5,
  2017,
    5:28
     AM
      
      
     
    
   
  
 
 
      On Wed, 4/5/17, 'Carmelita
    Cronin'
     via
      MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re:
   $$Excel-Macros$$
     Re:
      Customized Inventory
  Software
    Required
     in Excel VBA
       To: excel-macros@googlegroups.com
       Date: Wednesday, April 5,
   2017,
     4:19
      AM
       
       
      
     
    
   
  
 
 
       On Wed, 4/5/17,
 'Margareta
     Tolliver'
       via MS EXCEL AND VBA
 MACROS
     <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re:
    $$Excel-Macros$$
      Re:
       Customized Inventory
   Software
     Required
      in Excel VBA
        To: excel-macros@googlegroups.com
        Date: Wednesday, April 5,
    2017,
      3:39
       AM
        
        
       
      
     
    
   
  
 
 
        On Wed, 4/5/17,
  'Carmelita
      Cronin'
       via
        MS EXCEL AND VBA MACROS
    <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re:
     $$Excel-Macros$$
       Re:
        Customized Inventory
    Software
      Required
       in Excel VBA
         To: excel-macros@googlegroups.com
         Date: Wednesday, April
 5,
     2017,
       1:26
        AM
         
         
        
       
      
     
    
   
  
 
 
         On Wed, 4/5/17,
 'Kenyatta
     Freed'
       via
        MS
         EXCEL AND VBA MACROS
   <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re:
      $$Excel-Macros$$
        Re:
         Customized Inventory
     Software
       Required
        in Excel VBA
          To: excel-macros@googlegroups.com
          Date: Wednesday, April
  5,
      2017,
        1:15
         AM
          
          
         
        
       
      
     
    
   
  
 
 
          On Tue, 4/4/17,
    'Margareta
        Tolliver'
          via MS EXCEL AND VBA
    MACROS
        <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re:
       $$Excel-Macros$$
         Re:
          Customized Inventory
      Software
        Required
         in Excel VBA
           To: excel-macros@googlegroups.com
           Date: Tuesday,
 April
   4,
       2017,
         9:37 PM
           
           
          
         
        
       
      
     
    
   
  
 
 
           On Tue, 4/4/17,
     mintaspriggs
       via
         MS
          EXCEL AND VBA MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Su

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

2017-04-05 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Wed, 4/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Wednesday, April 5, 2017, 3:43 PM
 
 
 
 On Wed, 4/5/17, 'Yu Spain' via MS EXCEL
 AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re:
 Customized Inventory Software Required in Excel VBA
  To: excel-macros@googlegroups.com
  Date: Wednesday, April 5, 2017, 2:27
 PM
  
  
 
 
  On Wed, 4/5/17, 'Margareta Tolliver'
  via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Re:
  Customized Inventory Software Required
 in Excel VBA
   To: excel-macros@googlegroups.com
   Date: Wednesday, April 5, 2017,
 7:21
  AM
   
   
  
 
 
   On Wed, 4/5/17, mintaspriggs via
 MS
   EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Re:
   Customized Inventory Software
 Required
  in Excel VBA
    To: excel-macros@googlegroups.com
    Date: Wednesday, April 5, 2017,
  6:25
   AM
    
    
   
  
 
 ----
    On Wed, 4/5/17, 'Hopkins Ruben'
  via
   MS
    EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   Re:
    Customized Inventory Software
  Required
   in Excel VBA
     To: excel-macros@googlegroups.com
     Date: Wednesday, April 5,
 2017,
   5:28
    AM
     
     
    
   
  
 
 
     On Wed, 4/5/17, 'Carmelita
   Cronin'
    via
     MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    Re:
     Customized Inventory
 Software
   Required
    in Excel VBA
      To: excel-macros@googlegroups.com
      Date: Wednesday, April 5,
  2017,
    4:19
     AM
      
      
     
    
   
  
 
 
      On Wed, 4/5/17, 'Margareta
    Tolliver'
      via MS EXCEL AND VBA MACROS
    <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re:
   $$Excel-Macros$$
     Re:
      Customized Inventory
  Software
    Required
     in Excel VBA
       To: excel-macros@googlegroups.com
       Date: Wednesday, April 5,
   2017,
     3:39
      AM
       
       
      
     
    
   
  
 
 
       On Wed, 4/5/17,
 'Carmelita
     Cronin'
      via
       MS EXCEL AND VBA MACROS
   <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re:
    $$Excel-Macros$$
      Re:
       Customized Inventory
   Software
     Required
      in Excel VBA
        To: excel-macros@googlegroups.com
        Date: Wednesday, April 5,
    2017,
      1:26
       AM
        
        
       
      
     
    
   
  
 
 
        On Wed, 4/5/17, 'Kenyatta
    Freed'
      via
       MS
        EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re:
     $$Excel-Macros$$
       Re:
        Customized Inventory
    Software
      Required
       in Excel VBA
         To: excel-macros@googlegroups.com
         Date: Wednesday, April
 5,
     2017,
       1:15
        AM
         
         
        
       
      
     
    
   
  
 
 
         On Tue, 4/4/17,
   'Margareta
       Tolliver'
         via MS EXCEL AND VBA
   MACROS
       <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re:
      $$Excel-Macros$$
        Re:
         Customized Inventory
     Software
       Required
        in Excel VBA
          To: excel-macros@googlegroups.com
          Date: Tuesday, April
  4,
      2017,
        9:37 PM
          
          
         
        
       
      
     
    
   
  
 
 
          On Tue, 4/4/17,
    mintaspriggs
      via
        MS
         EXCEL AND VBA MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re:
       $$Excel-Macros$$
         Re: Customized
 Inventory
          Software Required in
    Excel
      VBA
           To: excel-macros@googlegroups.com
           Date: Tuesday,
 April
   4,
       2017,
         6:09 PM
           
           
          
        
       
      
     
    
   
  
 
 
           On Tue, 4/4/17, 'Yu
     Spain'
       via
         MS EXCEL AND VBA
 MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re:
      $$Excel-Macros$$
        Re:
         Cu

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

2017-04-04 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Wednesday, April 5, 2017, 4:19 AM
 
 
 
 On Wed, 4/5/17, 'Margareta Tolliver'
 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re:
 Customized Inventory Software Required in Excel VBA
  To: excel-macros@googlegroups.com
  Date: Wednesday, April 5, 2017, 3:39
 AM
  
  
 
 
  On Wed, 4/5/17, 'Carmelita Cronin'
 via
  MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Re:
  Customized Inventory Software Required
 in Excel VBA
   To: excel-macros@googlegroups.com
   Date: Wednesday, April 5, 2017,
 1:26
  AM
   
   
  
 
 
   On Wed, 4/5/17, 'Kenyatta Freed'
 via
  MS
   EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Re:
   Customized Inventory Software
 Required
  in Excel VBA
    To: excel-macros@googlegroups.com
    Date: Wednesday, April 5, 2017,
  1:15
   AM
    
    
   
  
 
 
    On Tue, 4/4/17, 'Margareta
  Tolliver'
    via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   Re:
    Customized Inventory Software
  Required
   in Excel VBA
     To: excel-macros@googlegroups.com
     Date: Tuesday, April 4,
 2017,
   9:37 PM
     
     
    
   
  
 
 
     On Tue, 4/4/17, mintaspriggs
 via
   MS
    EXCEL AND VBA MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    Re: Customized Inventory
     Software Required in Excel
 VBA
      To: excel-macros@googlegroups.com
      Date: Tuesday, April 4,
  2017,
    6:09 PM
      
      
     
   
  
 
 
      On Tue, 4/4/17, 'Yu Spain'
  via
    MS EXCEL AND VBA MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re:
 $$Excel-Macros$$
   Re:
    Customized
     Inventory
      Software Required in Excel
  VBA
       To: excel-macros@googlegroups.com
       Date: Tuesday, April 4,
 2017,
   10:38
    AM
       
       
      
   
  
 
 
       On Tue, 4/4/17,
 'Margareta
    Tolliver' via MS EXCEL AND
     VBA
       MACROS <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re:
  $$Excel-Macros$$
    Re: Customized
      Inventory
       Software Required in
 Excel
   VBA
        To: excel-macros@googlegroups.com
        Date: Tuesday, April 4,
  2017,
    9:21 AM
        
        
       
   
  
 
 
        On Tue, 4/4/17,
  'Margareta
    Tolliver' via MS EXCEL AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re:
   $$Excel-Macros$$
    Re: Customized
       Inventory
        Software Required in
  Excel
    VBA
         To: excel-macros@googlegroups.com
         Date: Tuesday, April
 4,
   2017,
    8:01 AM
         
         
        
   
  
 
 
         On Tue, 4/4/17, 'Yu
 Spain'
   via
    MS EXCEL AND VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re:
    $$Excel-Macros$$ Re: Customized
        Inventory
         Software Required in
 Excel
   VBA
          To: excel-macros@googlegroups.com
          Date: Tuesday, April
  4,
    2017, 5:48 AM
          
          
         
   
  
 
 
          On Tue, 4/4/17,
    mintaspriggs via MS EXCEL AND
  VBA
        MACROS
          <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re:
   $$Excel-Macros$$
    Re: Customized
         Inventory
          Software Required in
  Excel
    VBA
           To: excel-macros@googlegroups.com
           Date: Tuesday, April
 4,
   2017,
    1:42 AM
           
           
          
   
  
 
 
           On Mon, 4/3/17,
   'Derrick
    Andrew' via MS EXCEL
     AND
         VBA
          MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re:
    $$Excel-Macros$$ Re: Customized
          Inventory
           Software Required
 in
   Excel
    VBA
            To: excel-macros@googlegroups.com
            Date: Monday, April
  3,
    2017, 5:12 PM
            
            
           
   
  
 
 --------------------
          

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

2017-04-03 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS


On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in 
Excel VBA
 To: excel-macros@googlegroups.com
 Date: Monday, April 3, 2017, 1:53 PM
 
 
 
 On Mon, 4/3/17, Hitesh Kr. Aoul 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: Customized Inventory
 Software Required in Excel VBA
  To: "MS EXCEL AND VBA MACROS" 
  Date: Monday, April 3, 2017, 5:44 AM
  
  Hello
  Guys,
  Can anyone have any
  idea how to do the perfect Coding for this type of
  software... Waiting for the positive
  reply...
  
  
  
  On Wednesday,
  March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul
  wrote:Hello
  Learner,
  Thanks for the
  reply. Please find the attachment, for material IN form i
  need subform as there are 100 items in Per Invoice to be
  enter. Kindly check and if anything else required please
  discuss.
  Regards,Hitesh 
  
  On Wednesday, March 29, 2017
  at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh,
  There are many solutions for
  inventory data. If you want customized solution, you need
 to
  specify input and output data and the report forms to be
  generated. Attach a file giving basic
  structure
  Learner
  
  
  On Tue, Mar 28, 2017 at
  12:30 PM, Hitesh Kr. Aoul 
 wrote:
  Hello Guys,
  Can anyone have any idea how to do
  the Coding for this type of software... Waiting for the
  positive reply...
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
  Facebook page of this forum @ https://www.facebook.com/
  discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread titles. Poor thread
 titles,
  like Please Help, Urgent, Need Help, Formula Problem, Code
  Problem, and Need Advice will not get quick attention or
 may
  not be answered.
  
  2) Don't post a question in the thread of another
  member.
  
  3) Don't post questions regarding breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post confidential data in a
 workbook.
  Forum owners and members are not responsible for any
  loss.
  
  --- 
  
  You received this message because you are subscribed to
 the
  Google Groups "MS EXCEL AND VBA MACROS" group.
  
  To unsubscribe from this group and stop receiving emails
  from it, send an email to excel-macros...@googlegroups.
 com.
  
  To post to this group, send email to excel-...@googlegroups.com.
  
  Visit this group at https://groups.google.com/
  group/excel-macros.
  
  For more options, visit https://groups.google.com/d/
  optout.
  
  
  
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread titles. Poor thread
 titles,
  like Please Help, Urgent, Need Help, Formula Problem, Code
  Problem, and Need Advice will not get quick attention or
 may
  not be answered.
  
  2) Don't post a question in the thread of another
  member.
  
  3) Don't post questions regarding breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post confidential data in a
 workbook.
  Forum owners and members are not responsible for any
  loss.
  
  --- 
  
  You received this message because you are subscribed to
 the
  Google Groups "MS EXCEL AND VBA MACROS" group.
  
  To unsubscribe from this group and stop receiving emails
  from it, send an email to excel-macros+unsubscr...@googlegroups.com.
  
  To post to this group, send email to excel-macros@googlegroups.com.
  
  Visit this group at
 https://groups.google.com/group/excel-macros.
  
  For more options, visit
 https://groups.google.com/d/optout.
  ntelegerea propriu-zisa s-a incheiat la hotelul
 Concordia  din Bucuresti  sediul radicalilor.
 Astfel  inca din primele zile ale anului 1867 
 gruparea lui M. Kogalniceanusi cea condusa tle I.C. Bratianu
 s\ CA. Rosettise reunesc pe o platforma comuna . in
 esenta  aceasta urmarea instituirea  in
 Romania  a unui guvern stabil  intemeiat pe
 institutiuni egalitare si liberale  prin institutiuni
 democratice. Obiectivul acesta este formulat in Declaratia
 deputatilor care reprezinta mai multe grupari liberale din
 Adunarea legislativa  publicata in Romanul 6\n 10
 martie 1867.
 
 -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do