Re: $$Excel-Macros$$ Super Urgent - Thinking beyond

2011-08-31 Thread Venkat CV
Hi Karan,

Go to Hyperlink and try Exiting file or webpage option and selcect the word
document..

[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*

On Wed, Aug 31, 2011 at 4:24 PM, karan 1237  wrote:

> Hello Everyone,
>
> Is there any way to hyperlink a cell to a ms word document but only a
> page
>
>
> Kaяan
>
>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

RE: $$Excel-Macros$$ Super Urgent - Thinking beyond

2011-08-31 Thread Rajan_Verma
Hi Karan,

Try This :

 

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As 
Boolean)

Dim WordApp As New Word.Application

WordApp.Visible = True

WordApp.Documents.Open "D:\Rajan\NFA.docx"

WordApp.Selection.GoTo What:=wdGoToPage, Which:=wdGoToNext, 
Name:=Target.Offset(0, 1).Value

WordApp.Activate

Set WordApp = Nothing

End Sub

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of karan 1237
Sent: Wednesday, August 31, 2011 4:24 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Super Urgent - Thinking beyond

 

Hello Everyone,

Is there any way to hyperlink a cell to a ms word document but only a page



Kaяan 




 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


WordApp.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12