Saya coba bantu ya,,
coba VBA Code berikut ini:
Sheet1:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address = "$D$5" Then
Target.Offset(1).Activate
GoToPdfPage
End If
End Sub
Module1:
Sub GoToPdfPage()
Dim IE As Object, x As String, y As Integer
x = "C:\Documents and Settings\user\My Documents\Downloads\PL 9500 15GHZ.pdf" 'Ganti dengan alamat file
y = 2 'ke hal 2
On Error Resume Next
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate x & "#Page=" & y
IE.Visible = True
On Error GoTo 0
End Sub
File terlampir
atau menuju ke TKP berikut:
http://tech.groups.yahoo.com/group/XL-mania/message/15600
>semoga bermanfaat
From: "WATI, ENDAR (ENDAR)** CTR **" <Endar.Wati@alcatel-lucent.com>
To: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Sent: Mon, June 21, 2010 9:47:26 AM
Subject: ]] XL-mania [[ LINK eksel to PDF
coba VBA Code berikut ini:
Sheet1:
Private Sub Worksheet_BeforeDou
If Target.Address = "$D$5" Then
Target.Offset(
GoToPdfPage
End If
End Sub
Module1:
Sub GoToPdfPage(
Dim IE As Object, x As String, y As Integer
x = "C:\Documents and Settings\user\
y = 2 'ke hal 2
On Error Resume Next
Set IE = CreateObject(
IE.Navigate x & "#Page=" & y
IE.Visible = True
On Error GoTo 0
End Sub
File terlampir
atau menuju ke TKP berikut:
http://tech.
>semoga bermanfaat
From: "WATI, ENDAR (ENDAR)** CTR **" <Endar.Wati@alcatel-
To: "XL-mania@yahoogrou
Sent: Mon, June 21, 2010 9:47:26 AM
Subject: ]] XL-mania [[ LINK eksel to PDF
Dear Pakar ExseL,
Ada yang bisa Bantu cara Link dari file exsel yang ada Tulisan dibawah
| PN |
| 3DB23039AEXX |
Di link ke PDF yang halaman ke dua gimana ya caranya??
Regards
Endarwati
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| momod akan terdampar seminggu lagi, moderasi akan lemodmod... |
| hidup tanpa google dan fesbuk dan yahuuuu... ampun dehhh... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
| momod akan terdampar seminggu lagi, moderasi akan lemodmod... |
| hidup tanpa google dan fesbuk dan yahuuuu... ampun dehhh... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
MARKETPLACE
.
__,_._,___
Nenhum comentário:
Postar um comentário