O Oleg Registered User. Local time Yesterday, 22:12 Joined Jun 6, 2011 Messages 14 Aug 1, 2011 #1 hello all i need to change the line Code: For Each ws In wb.Worksheets to reference each ws (workseet) in the currently open workbook (name will be different depending on how many time app is run)
hello all i need to change the line Code: For Each ws In wb.Worksheets to reference each ws (workseet) in the currently open workbook (name will be different depending on how many time app is run)
boblarson Smeghead Local time Yesterday, 22:12 Joined Jan 12, 2001 Messages 32,053 Aug 1, 2011 #2 Well, for one I would assign wb to be the currently open workbook and then you are set. Set wb = objXL.ActiveWorkbook
Well, for one I would assign wb to be the currently open workbook and then you are set. Set wb = objXL.ActiveWorkbook
O Oleg Registered User. Local time Yesterday, 22:12 Joined Jun 6, 2011 Messages 14 Aug 1, 2011 #3 boblarson said: Well, for one I would assign wb to be the currently open workbook and then you are set. Set wb = objXL.ActiveWorkbook Click to expand... tx, works perfectly ! )
boblarson said: Well, for one I would assign wb to be the currently open workbook and then you are set. Set wb = objXL.ActiveWorkbook Click to expand... tx, works perfectly ! )
)
