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
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) ! Joi
x27;Martin George' via MS EXCEL AND VBA MACROS"
wrote:
-- ------
On Thu, 5/25/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Links
To: "excel-macros@googlegroups.com "
Date: Thursday, May 25, 2017, 8:17 PM
The workbook that yo
Macro is just running and not fetching any outcome.
Regards,
Kaushik
On May 26, 2017 16:11, "'Martin George' via MS EXCEL AND VBA MACROS" <
excel-macros@googlegroups.com> wrote:
>
>
> On Thu, 5/25/17, Paul Schreine
On Thu, 5/25/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Links
To: "excel-macros@googlegroups.com"
Date: Thursday, May 25, 2017, 8:17 PM
The workbook that you add the VBA macro to is
identified as "ThisWorkboo
On Thu, 5/25/17, KAUSHIK SAVLA wrote:
Subject: Re: $$Excel-Macros$$ Links
To: "MS EXCEL AND VBA MACROS"
Cc: schreiner_p...@att.net
Date: Thursday, May 25, 2017, 9:26 PM
Could you
please share your dummy workbook which you created
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:
>
> ThisWorkbook.Sheets(1).Range(
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 "
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
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 looked like
> yours instea
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 1
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 nam
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
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 na
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 me
Hi Paul,
I want to know each worksheet is linked to what source.
This I want to do because say suppose one source is incorrect, through
this I will know it will affect which worksheets of my workbook.
Regards,
Kaushik
On May 24, 2017 00:17, "Paul Schreiner" wrote:
So, you're wanting to fin
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)
17 matches
Mail list logo
