Ολοκληρωμένο

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

Ικανότητες: Excel, Visual Basic, Visual Basic για Εφαρμογές

Περισσότερα: 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

Σχετικά με τον Εργοδότη:
( 153 αξιολογήσεις ) Villanova Mondovì, Italy

Ταυτότητα Εργασίας: #17972283

Ανατέθηκε στον:

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 Περισσότερα

€23 EUR σε 1 μέρα
(91 Αξιολογήσεις)
5.7

5 freelancers κάνουν προσφορές κατά μέσο όρο €36 για αυτή τη δουλειά

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 Περισσότερα

€70 EUR σε 2 μέρες
(274 Αξιολογήσεις)
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 σε 0 μέρες
(3 Αξιολογήσεις)
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 σε 1 μέρα
(32 Αξιολογήσεις)
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 Περισσότερα

€25 EUR σε 1 μέρα
(3 Αξιολογήσεις)
1.1