Færdiggjort

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

Evner: Excel, Visual Basic, Visual Basic for Apps

Se mere: 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

Om arbejdsgiveren:
( 153 bedømmelser ) Villanova Mondovì, Italy

Projekt ID: #17972283

Tildelt til:

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 Flere

€23 EUR på 1 dag
(91 bedømmelser)
5.7

5 freelancere byder i gennemsnit €36 på dette job

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 Flere

€70 EUR in 2 dage
(274 bedømmelser)
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 in 0 dage
(3 bedømmelser)
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 på 1 dag
(32 bedømmelser)
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 Flere

€25 EUR på 1 dag
(3 bedømmelser)
1.1