Lengkap

Fix Vba script

I need to fix this script

Sub URLPictureInsert()

'Updateby Extendoffice 20161116

Dim Pshp As Shape

Dim xRg As Range

Dim xCol As Long

On Error Resume Next

[login to view URL] = False

Set Rng = [login to view URL]("Please select the url cells:", "KuTools for excel", [login to view URL], , , , , 8)

For Each cell In Rng

filenam = cell

[login to view URL](filenam).Select

Set Pshp = [login to view URL](1)

If Pshp Is Nothing Then GoTo lab

xCol = [login to view URL] + 1

Set xRg = Cells([login to view URL], xCol)

With Pshp

.LockAspectRatio = msoFalse

.Width = 100

.Height = 100

.Top = [login to view URL] + ([login to view URL] - .Height) / 2

.Left = [login to view URL] + ([login to view URL] - .Width) / 2

End With

lab:

Set Pshp = Nothing

Range("e2").Select

Next

[login to view URL] = True

End Sub

The goal is

show the image located in the path indicated in F [login to view URL]

in the cell E [login to view URL]

and IF the image there is not, the script should check the Cell G [login to view URL]

Cechk file in attachment

Kemahiran: Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: free vba script macro, vba script automated email, start vba script excel, int excel, excel vba convert decimal to integer, vba int function, vba int, vba fix vs int, vba trunc, excel vba integer, excel vba round, run vba script excel, fix messed script, hyperlink vba script outlook, vba script copy object word, excel vba script modify existing vba, fix php script, vba script message forward, fix php script errors wordpress, vba script access

Tentang Majikan:
( 153 ulasan ) Villanova Mondovì, Italy

ID Projek: #17972283

Dianugerahkan kepada:

mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several excel vba projects, I can help you in getting current script fixed to show image in appropirate cell as needed. I am available Lagi

€23 EUR dalam sehari
(91 Ulasan)
5.7

5 pekerja bebas membida secara purata €36 untuk pekerjaan ini

schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Fix Vba script . I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd Lagi

€70 EUR dalam 2 hari
(274 Ulasan)
7.5
sharpzulfiqar

Dear Client Ready to fix it for you right away. I am an experienced VBA and excel professional! Will be waiting for your response. Warm Regards Z

€30 EUR dalam 0 hari
(3 Ulasan)
5.1
prasannjeetp

Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.

€30 EUR dalam sehari
(32 Ulasan)
4.1
kumarapush777

Hi, I will be able to complete this task in quick time. My experience will be of great help for you in optimizing or completing other daily office tasks as well. General Profile Information: Also,I am 12 yrs Ex Lagi

€25 EUR dalam sehari
(3 Ulasan)
1.1