Re: $$Excel-Macros$$ Links

On Fri, 5/26/17, KAUSHIK SAVLA <savla.kaus...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Links To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Date: Friday, May 26, 2017, 10:10 PM Hi Paul, I fol

Re: $$Excel-Macros$$ Links

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) !

Re: $$Excel-Macros$$ Links

7 16:11, "'Martin George' via MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> wrote: -- -- On Thu, 5/25/17, Paul Schreiner <schreiner_p...@att.net> wrote:  Subject: Re: $$Excel-Macros$$ Links  To: "excel-macros@googlegr

Re: $$Excel-Macros$$ Links

chreiner_p...@att.net> wrote: > > Subject: Re: $$Excel-Macros$$ Links > To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> > Date: Thursday, May 25, 2017, 8:17 PM > > The workbook that you add the VBA macro to is > identified as "Thi

Re: $$Excel-Macros$$ Links

On Thu, 5/25/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Links To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Thursday, May 25, 2017, 8:17 PM The workbook that

Re: $$Excel-Macros$$ Links

On Thu, 5/25/17, KAUSHIK SAVLA <savla.kaus...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Links To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Cc: schreiner_p...@att.net Date: Thursday, May 25, 2017, 9:26 P

Re: $$Excel-Macros$$ Links

Could you please share your dummy workbook which you created? Regards, Kaushik Savla On Thursday, May 25, 2017 at 11:47:39 PM UTC+5:30, Paul Schreiner wrote: > > The workbook that you add the VBA macro to is identified as "ThisWorkbook". > > so, in the macro: > >

Re: $$Excel-Macros$$ Links

ok...Thanks On Thursday, May 25, 2017 at 11:47:39 PM UTC+5:30, Paul Schreiner wrote: > > The workbook that you add the VBA macro to is identified as "ThisWorkbook". > > so, in the macro: > > ThisWorkbook.Sheets(1).Range("A2:Z65000").ClearContents > > clears the contents of the first sheet in

Re: $$Excel-Macros$$ Links

The workbook that you add the VBA macro to is identified as "ThisWorkbook". so, in the macro:     ThisWorkbook.Sheets(1).Range("A2:Z65000").ClearContents clears the contents of the first sheet in "Thisworkbook"then:     ThisWorkbook.Sheets(1).Cells(nRow, "A").Value = Sht.Name   

Re: $$Excel-Macros$$ Links

Hi Paul, Macro got run and gave finished message. Where can I find the desired output? Regards, Kaushik On May 25, 2017 19:06, "Paul Schreiner" wrote: > OK. > Spent WAY longer on this than I should have. > > I should've had you create a "dummy" set of workbooks that

Re: $$Excel-Macros$$ Links

OK.Spent WAY longer on this than I should have. I should've had you create a "dummy" set of workbooks that looked like yours instead of me spending an hour+ guessing what yours looks like. So, I put together 20 separate workbooks with data.then added 15 sheets to the "data" workbook and created

Re: $$Excel-Macros$$ Links

Hi Paul You are correct, I don't want to break links. Not possible to send workbook as it contains sensitive confidential information. Just suppose there is a worksheet named A in workbook. It is linked to external workbook named say X, Y and it is also linked to worksheets in workbook say

Re: $$Excel-Macros$$ Links

It sounds like you're not wanting to REMOVE the links,but basically generate a list of worksheets and the name of the external workbooks linked to those sheets. That doesn't sound difficult. But the error you're suggesting doesn't make sense because you're not "pasting" anything (with the macro

Re: $$Excel-Macros$$ Links

Hi Paul, What I am looking for is below. 1. I have a workbook with 100 worksheets 2. Each worksheet is linked to several external Workbooks and several tabs/worksheets within workbook. 3. What I want to do is first list all name of tabs sequentially in a new workbook and against each worksheet

Re: $$Excel-Macros$$ Links

Hi Paul, What I am looking for is below. 1. I have a workbook with 100 worksheets 2. Each worksheet is linked to several external Workbooks and several table within workbook. 3. What I want to do is first list all name of tabs sequentially in a new workbook and against each worksheet name

Re: $$Excel-Macros$$ Links

So, you're wanting to find out what other documents are being linked? something like this will count the number of referenced links:     cnt = 0     alinks = ActiveWorkbook.LinkSources(xlExcelLinks) '    MsgBox alinks.Count     If Not IsEmpty(alinks) Thenmsgbox "Links: " & UBound(alinks)   

$$Excel-Macros$$ Links

Hi Team, I have several huge data files. Each file has links to several worksheets and several workbooks. Can anyone help me with a vba code which will go in each worksheet of workbook and will fetch me result mentioning each worksheet has source from which worksheets/workbooks. Doing it