Astuce: Les autres langues sont Google-Traduction. Vous pouvez visiter le English version de ce lien.
Se connecter
x
or
x
x
S'enregistrer
x

or

Comment convertir les URL d'images en images réelles dans Excel?

URL du document vers img 1

Si vous avez une liste d'adresses URL d'images dans la colonne A et que vous souhaitez maintenant télécharger les images correspondantes à partir des URL et les afficher dans la colonne B adjacente, comme illustré ci-contre. Dans Excel, comment extraire rapidement et facilement les images réelles des URL de l'image?

Convertir les URL de l'image en images réelles avec le code VBA

Convertissez les URL d'image en images réelles avec Kutools for Excel


Convertissez les URL d'images en images réelles rapidement et facilement

Kutools for Excel's Insérer des images à partir du chemin (URL) Cette fonctionnalité peut vous aider à extraire toutes les images réelles des hyperliens d’URL ou des chemins d’image. Cliquez pour télécharger Kutools for Excel!


Convertir les URL de l'image en images réelles avec le code VBA

Le code VBA suivant peut vous aider à extraire rapidement les images réelles à partir des adresses URL de l'image, procédez comme suit:

1. Maintenez le ALT + F11 clés pour ouvrir la fenêtre Microsoft Visual Basic pour Applications.

2. Cliquez insérer > Moduleet collez le code suivant dans la fenêtre du module.

Code VBA: Convertir les URL de l'image en images réelles:

Sub URLPictureInsert()
Dim Pshp As Shape
Dim xRg As Range
Dim xCol As Long
On Error Resume Next
Application.ScreenUpdating = False
Set Rng = ActiveSheet.Range("A2:A5")
For Each cell In Rng
filenam = cell
ActiveSheet.Pictures.Insert(filenam).Select
Set Pshp = Selection.ShapeRange.Item(1)
If Pshp Is Nothing Then GoTo lab
xCol = cell.Column + 1
Set xRg = Cells(cell.Row, xCol)
With Pshp
.LockAspectRatio = msoFalse
If .Width > xRg.Width Then .Width = xRg.Width * 2 / 3
If .Height > xRg.Height Then .Height = xRg.Height * 2 / 3
.Top = xRg.Top + (xRg.Height - .Height) / 2
.Left = xRg.Left + (xRg.Width - .Width) / 2
End With
lab:
Set Pshp = Nothing
Range("A2").Select
Next
Application.ScreenUpdating = True
End Sub

À noter :

  • 1. Dans le code ci-dessus, A2: A5 est la plage de cellules qui contient les adresses URL dont vous souhaitez extraire les images, vous devez modifier les références de cellules en fonction de vos besoins.
  • 2. Avec ce code, vous ne pouvez pas spécifier la taille des images extraites selon vos besoins.
  • 3. Le code ci-dessus uniquement peut extraire les images réelles dans les cellules en plus de votre colonne URL, vous ne pouvez pas spécifier de cellule pour afficher les images.
  • 4. Vous devez avoir des connaissances de base sur le code. Si un caractère est manquant ou incorrect, le code ne sera pas exécuté avec succès.

3. Puis appuyez F5 clé pour exécuter ce code, et toutes les images correspondantes ont été extraites à la fois des URL d’image vers la colonne adjacente, et les images seront placées au centre de vos cellules spécifiques, voir capture d’écran:

URL du document vers img 2


Convertissez les URL d'image en images réelles avec Kutools for Excel

Si vous ne connaissez pas le code VBA ou souhaitez remédier à la limitation du code ci-dessus, Kutools for Excel's Insérer des images sous le chemin (URL) Cette fonctionnalité peut vous aider à insérer rapidement les images correspondantes en fonction des adresses URL ou des chemins spécifiques de votre ordinateur.

Veuillez noter que :Appliquer cette Insérer des images sous le chemin (URL)Tout d’abord, vous devriez télécharger le Kutools for Excel, puis appliquez la fonctionnalité rapidement et facilement.

Après l'installation de Kutools for Excel, faites comme ceci:

1. Cliquez Kutools > insérer > Insérer des images sous le chemin (URL), dans la boîte de dialogue déroulante, définissez les opérations suivantes, voir les captures d'écran:

URL du document vers img 3 URL du document vers img 4

2. Puis clique Ok bouton, et les images seront extraites des URL, voir capture d'écran:

URL du document vers img 1

Cliquez pour télécharger et essai gratuit Kutools for Excel maintenant!


Kutools for Excel résout la plupart de vos problèmes et augmente votre productivité de 80%

  • Réutilisation: Insérer rapidement formules complexes, graphiques et tout ce que vous avez utilisé auparavant; Crypter les cellules avec mot de passe Créer une liste de diffusion et envoyer des emails ...
  • Super Formula Bar (éditez facilement plusieurs lignes de texte et de formule); Disposition de lecture (facilement lire et éditer un grand nombre de cellules); Coller à la gamme filtrée...
  • Fusionner les cellules / rangées / colonnes sans perdre de données; Contenu des cellules divisées; Combiner les lignes / colonnes en double... Prévenir les cellules en double; Comparer les plages...
  • Sélectionnez Dupliquer ou Unique Des rangées; Sélectionnez les lignes vierges (toutes les cellules sont vides); Super Find et Fuzzy Find dans de nombreux cahiers d'exercices; Sélection aléatoire ...
  • Copie exacte Plusieurs cellules sans changer la référence de la formule; Créer automatiquement des références à plusieurs feuilles; Insérer des balles, Cases à cocher et plus ...
  • Extrait du texte, Ajouter du texte, Supprimer par position, Supprimer l'espace; Créer et imprimer des sous-totaux de pagination; Conversion entre contenu de cellules et commentaires...
  • Super filtre (enregistrer et appliquer des schémas de filtrage à d'autres feuilles); Tri avancé par mois / semaine / jour, fréquence et plus; Filtre spécial en gras, en italique ...
  • Combinaison de classeurs et de feuilles de calcul; Fusionner les tables en fonction des colonnes clés; Fractionner les données en plusieurs feuilles; Conversion par lots xls, xlsx et PDF...
  • Plus que de puissantes fonctionnalités 300. Prend en charge Office / Excel 2007-2019 et 365. Prend en charge toutes les langues. Déploiement facile dans votre entreprise ou organisation. Fonctionnalités complètes Essai gratuit du jour 30.
kte tab 201905

Office Tab apporte une interface à onglets à Office et simplifie grandement votre travail

  • Activer l'édition par onglets et la lecture dans Word, Excel, PowerPoint, Publisher, Access, Visio et Project.
  • Ouvrez et créez plusieurs documents dans de nouveaux onglets de la même fenêtre, plutôt que dans de nouvelles fenêtres.
  • Augmente votre productivité de 50% et réduit le nombre de clics de souris pour vous chaque jour!
fond officetab
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Oscar · 1 months ago
    Kutools no importa las imagenes alojadas en Drive. Como hago?
  • To post as a guest, your comment is unpublished.
    Ronnie · 6 months ago
    hey! with the Help of the Vba Code the Image has been extracted to the sheet but as i am moving my workbooks location the Image are Corrupted so help me here
  • To post as a guest, your comment is unpublished.
    karim · 8 months ago
    working perfect
    thanks a lot
  • To post as a guest, your comment is unpublished.
    Jo · 8 months ago
    if the url is in https, for sure there is no way to work around it?
  • To post as a guest, your comment is unpublished.
    Karthik Karthik · 10 months ago
    Hello I'm here asking for your help. My research ended up in 2 different macros that combined will give a good utility for my work.
    1. Will insert image as comment, 2. Will fetch Hyperlinks(Local folder path only, not web based URL) and paste them in destination cell
    I really tried to combine them to do one job, but I guess I don’t have enough knowledge on this.
    I need the images to be inserted as comment as the 1st code does to the destination range user selects.

    Sub InsertPictureAsComment()
    Dim PicturePath As String
    Dim CommentBox As Comment
    With Application.FileDialog(msoFileDialogFilePicker)
    .AllowMultiSelect = True
    .title = "Select Comment Image"
    .ButtonName = "Insert Image"
    .Filters.clear
    .Filters.Add "Images", "*.png; *.jpg"
    .Show
    'Store Selected File Path
    On Error GoTo UserCancelled
    PicturePath = .SelectedItems(1)
    On Error GoTo 0
    End With
    'Clear Any Existing Comment
    Application.ActiveCell.ClearComments
    'Create a New Cell Comment
    Set CommentBox = Application.ActiveCell.AddComment
    'Remove Any Default Comment Text
    CommentBox.Text Text:=""
    'Insert The Image and Resize
    CommentBox.Shape.Fill.UserPicture (PicturePath)
    CommentBox.Shape.ScaleHeight 6, msoFalse, msoScaleFormTopLeft
    CommentBox.Shape.ScaleWidth 4.8, msoFalse, msoScaleFromTopLeft
    'Ensure Comment is Hidden (Swith to TRUE if you want visible)
    CommentBox.Visible = False
    Exit Sub
    'ERROR HANDLERS
    UserCancelled:
    MsgBox "Done"
    End Sub

    Sub URLToCellPictureInsert()
    'Updateby Extendoffice 20180608
    Dim Pshp As Shape
    Dim xRg As Range
    Dim xCol As Long
    On Error Resume Next
    Set Rng = Application.InputBox("Please select the url cells:", "KuTools for excel", Selection.Address, , , , , 8)
    If Rng Is Nothing Then Exit Sub
    Set xRg = Application.InputBox("Please select a cell to put the image as comment:", "KuTools for excel", , , , , , 8)
    If xRg Is Nothing Then Exit Sub
    Application.ScreenUpdating = False
    For i = 1 To Rng.Count
    filenam = Rng(i)
    ActiveSheet.Pictures.Insert(filenam).Select
    Set Pshp = Selection.ShapeRange.Item(1)
    If Pshp Is Nothing Then GoTo lab
    xCol = cell.Column + 1
    Set xRg = xRg.Offset(i - 1, 0)
    With Pshp
    .LockAspectRatio = msoFalse
    .Width = 80
    .Height = 80
    .Top = xRg.Top + (xRg.Height - .Height) / 2
    .Left = xRg.Left + (xRg.Width - .Width) / 2
    End With
    lab:
    Set Pshp = Nothing
    Range("A2").Select
    Next
    Application.ScreenUpdating = True
    End Sub
    • To post as a guest, your comment is unpublished.
      Sharath · 6 months ago
      Before first End Sub Call the Module URLToCellPictureInsert and remove the msgbox Done paste before 2nd End sub

      Like this: Call URLToCellPictureInsert
  • To post as a guest, your comment is unpublished.
    Chile · 1 years ago
    Hello

    I try to get 33 images from URL but only gives me 1, all URL paths to the images are correct... what can that be?
  • To post as a guest, your comment is unpublished.
    Justyna · 1 years ago
    Hi,

    I have pictures with different resolutions. What should I write in height and width to keep the proportion of images?
    • To post as a guest, your comment is unpublished.
      skyyang · 1 years ago
      Hello, Justyna,
      May be there is no other good way to keep the proportion of images if the pictures with different resolutions.
      If you have the good solution, please comment here, thank you!
  • To post as a guest, your comment is unpublished.
    Ed · 1 years ago
    Hi all, This Macro is great. However, it does not really add pictures to the file but links that generate pictures each time I open the file. Thus I cannot compress pictures as they are not really inside the file. Could you please help me to really save pictures inside the file?
    • To post as a guest, your comment is unpublished.
      enrico rinero · 9 months ago
      Hi! I have the same question.
      There is a way to save the image effectively in the excel? (and not linked outside)
  • To post as a guest, your comment is unpublished.
    Shozib · 1 years ago
    Hi skyyang, first for such an informative post. I have a question, could you please help me. Using this code of your's I want to extract just one pic and want to place it in a specific cell. Is it possible??
    • To post as a guest, your comment is unpublished.
      skyyang · 1 years ago
      Hello, Shozib,
      To put the images to any other cells as you want, please apply the following VBA code:

      Sub URLPictureInsert1()
      'Updateby Extendoffice 20180608
      Dim Pshp As Shape
      Dim xRg As Range
      Dim xCol As Long
      On Error Resume Next
      Set Rng = Application.InputBox("Please select the url cells:", "KuTools for excel", Selection.Address, , , , , 8)
      If Rng Is Nothing Then Exit Sub
      Set xRg = Application.InputBox("Please select a cell to put the image:", "KuTools for excel", , , , , , 8)
      If xRg Is Nothing Then Exit Sub
      Application.ScreenUpdating = False
      For I = 1 To Rng.Count
      filenam = Rng(I)
      ActiveSheet.Pictures.Insert(filenam).Select
      Set Pshp = Selection.ShapeRange.Item(1)
      If Pshp Is Nothing Then GoTo lab
      xCol = cell.Column + 1
      Set xRg = xRg.Offset(I - 1, 0)
      With Pshp
      .LockAspectRatio = msoFalse
      .Width = 80
      .Height = 80
      .Top = xRg.Top + (xRg.Height - .Height) / 2
      .Left = xRg.Left + (xRg.Width - .Width) / 2
      End With
      lab:
      Set Pshp = Nothing
      Range("A2").Select
      Next
      Application.ScreenUpdating = True
      End Sub

      Please try it, hope it can help you!
  • To post as a guest, your comment is unpublished.
    SamR · 1 years ago
    I'm using an Intel I5 processor, windows 7 professional 64bit, Office 2016 64 bit. I assume that the problem is a setting in Excel. Any help would be greatly appreciated.
    range is set, filenam = url and changes with each pass, Pshp is always nothing, URL's are verified, Any Ideas
  • To post as a guest, your comment is unpublished.
    Sam Ruppenthal · 1 years ago
    range is set, filenam = url and changes with each pass, Pshp is always nothing. Any Ideas
  • To post as a guest, your comment is unpublished.
    Zafar Khan · 1 years ago
    Thanks for your post. How I can get the pictures in the center of the cell. With the current codes the pictures are showing in the top left corner
    • To post as a guest, your comment is unpublished.
      skyyang · 1 years ago
      Hello, Khan,
      the following VBA code can help you to extract the picture and put them into the center of the cells, please try it.

      Sub URLPictureInsert()
      Dim Pshp As Shape
      Dim xRg As Range
      Dim xCol As Long
      On Error Resume Next
      Application.ScreenUpdating = False
      Set Rng = ActiveSheet.Range("A2:A6")
      For Each cell In Rng
      filenam = cell
      ActiveSheet.Pictures.Insert(filenam).Select
      Set Pshp = Selection.ShapeRange.Item(1)
      If Pshp Is Nothing Then GoTo lab
      xCol = cell.Column + 1
      Set xRg = Cells(cell.Row, xCol)
      With Pshp
      .LockAspectRatio = msoFalse
      If .Width > xRg.Width Then .Width = xRg.Width * 2 / 3
      If .Height > xRg.Height Then .Height = xRg.Height * 2 / 3
      .Top = xRg.Top + (xRg.Height - .Height) / 2
      .Left = xRg.Left + (xRg.Width - .Width) / 2
      End With
      lab:
      Set Pshp = Nothing
      Range("A2").Select
      Next
      Application.ScreenUpdating = True
      End Sub
      • To post as a guest, your comment is unpublished.
        Vipin Sahu · 1 years ago
        Hello,
        I want to download the images from the URL's (Column A) in a specific folder and rename the same images with a code/number which is there in Column B.
        • To post as a guest, your comment is unpublished.
          skyyang · 1 years ago
          Hello, Vipin,
          To save the URL'S images into a folder and rename them with the new names in Column B, may be the following VBA code can help you:

          Note: Column A contains the URL addresses and Column B has the new names.

          #If VBA7 Then
          Private Declare PtrSafe Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
          #Else
          Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
          #End If
          Sub URLPictureInsert()
          Dim I As Integer
          Dim xStr As String
          Dim xFd As FileDialog
          Dim xArr, xFdItem As Variant
          Application.ScreenUpdating = False
          Set xFd = Application.FileDialog(msoFileDialogFolderPicker)
          If xFd.Show = -1 Then
          xFdItem = xFd.SelectedItems.Item(1)
          xArr = Range("A2:B5").Value
          For I = 1 To UBound(xArr)
          If xArr(I, 1) <> "" Then
          xStr = Mid(xArr(I, 1), InStrRev(xArr(I, 1), "."), Len(xArr(I, 1)))
          URLDownloadToFile 0, xArr(I, 1), xFdItem & "\" & xArr(I, 2) & I & xStr, 0, 0
          End If
          Next
          End If
          Application.ScreenUpdating = True
          End Sub

          Please try it, hope this can help you!
          • To post as a guest, your comment is unpublished.
            David · 10 months ago
            the renaming part on column B uploads into the folder but is adding a number count next to the name of the picture, how I can omit that?

            Thank you
            • To post as a guest, your comment is unpublished.
              skyyang · 10 months ago
              Hi, David,
              May be the below vba code can help you to extract the iimages and rename them wihtout the subfix number, please try. Hope it can help you!

              #If VBA7 Then
              Private Declare PtrSafe Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
              #Else
              Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
              #End If
              Sub URLPictureInsert()
              Dim I As Integer
              Dim xStr As String
              Dim xFd As FileDialog
              Dim xArr, xFdItem As Variant
              Application.ScreenUpdating = False
              Set xFd = Application.FileDialog(msoFileDialogFolderPicker)
              If xFd.Show = -1 Then
              xFdItem = xFd.SelectedItems.Item(1)
              xArr = Range("A2:B5").Value
              For I = 1 To UBound(xArr)
              If xArr(I, 1) <> "" Then
              xStr = Mid(xArr(I, 1), InStrRev(xArr(I, 1), "."), Len(xArr(I, 1)))
              URLDownloadToFile 0, xArr(I, 1), xFdItem & "\" & xArr(I, 2) & xStr, 0, 0
              End If
              Next
              End If
              Application.ScreenUpdating = True
              End Sub
              • To post as a guest, your comment is unpublished.
                david · 9 months ago
                Omg!! You just provided a miracle, It works like a charm. Thank you so much.
      • To post as a guest, your comment is unpublished.
        Justin · 1 years ago
        Couldn't get this to work can you show the completed code for this request?
  • To post as a guest, your comment is unpublished.
    DKcrm · 2 years ago
    Works great for pulling images, but they are put randomly and not in the expected cells... Excel 2016 from Office365...
    • To post as a guest, your comment is unpublished.
      skyyang · 1 years ago
      Hello, DKcrm,
      Thank you for your comment, the code in this article has been updated, please try the new one, hope it can help you!
  • To post as a guest, your comment is unpublished.
    Iris De Smedt · 2 years ago
    Hi guys,
    It would love to get this working but when I copy this in VBA & click on run I only get this text:
    Sub URLPictureInsert()
    Can you please help me to get the picture thumbnail?
    • To post as a guest, your comment is unpublished.
      skyyang · 2 years ago
      Hello,
      When applying the code, you can change the width and height size of the picture to match you cells.
      Thank you!
  • To post as a guest, your comment is unpublished.
    Taylor Hays · 2 years ago
    Is there any way to run this so that it is across a row instead of a column? I have tried simply changing the range and the final location of the image but it only ever produces the first cell.
    • To post as a guest, your comment is unpublished.
      skyyang · 2 years ago
      Hi, Taylor,
      May be the following VBA code can help you to extract the real pictures in a row URLs:


      Sub URLPictureInsert()
      Dim Pshp As Shape
      On Error Resume Next
      Application.ScreenUpdating = False
      Set Rng = ActiveSheet.Range("A1:E1")
      For Each cell In Rng
      filenam = cell
      ActiveSheet.Pictures.Insert(filenam).Select
      Set Pshp = Selection.ShapeRange.Item(1)
      With Pshp
      .LockAspectRatio = msoTrue
      .Width = 100
      .Height = 100
      .Cut
      End With
      Cells(cell.Row + 1, cell.Column).PasteSpecial
      Next
      Application.ScreenUpdating = True
      End Sub

      Please try it, hope it can help you. Thank you!
  • To post as a guest, your comment is unpublished.
    Mark Boucher · 2 years ago
    To get this to work in Excel 2010 I had to add these declarations.


    Dim Rng As Range
    Dim cell As Range
    Dim filenam As String
  • To post as a guest, your comment is unpublished.
    Mark · 2 years ago
    In Excel 2010 I had to add these declarations

    Dim Rng As Range
    Dim cell As Range
    Dim filenam As String
  • To post as a guest, your comment is unpublished.
    Florent · 2 years ago
    Works perfectly but can anyone help me add something to check if the image exists and if it doesn't, post a text in the cell like "Image unavailable" ??
  • To post as a guest, your comment is unpublished.
    Jeremy · 2 years ago
    For me, all that shows up in each cell is the name of the method. They all say "Sub URLPictureInsert()"
  • To post as a guest, your comment is unpublished.
    belliney · 2 years ago
    AMAZING! this is so great! i had 350 rows of hyperlink and it took only 5 mins to pull all images!
    • To post as a guest, your comment is unpublished.
      Naresh · 1 years ago
      hey, can anyone attach a link of excel sheet with macro code enabled it so that i can download and experiment, I'm new to VB and I badly need to do this.
  • To post as a guest, your comment is unpublished.
    ZAFAR KHAN · 2 years ago
    Hi everyone, I have modified these code so that it works for the selected range instead of entering the specific range, However, can anyone suggest me how to modify these code to have the image in the centre of the cell. Currently the image is showing in the top left corner

    Sub URLPictureInsert()

    Dim Pshp As Shape

    Dim rCell As Range

    On Error Resume Next

    Application.ScreenUpdating = False

    For Each rCell In Selection

    filenam = rCell ActiveSheet.Pictures.Insert(filenam).Select

    Set Pshp = Selection.ShapeRange.Item(1)

    With Pshp

    .LockAspectRatio = msoTrue

    .Width = 100

    .Height = 100

    .Cut

    End With

    Cells(rCell.Row, rCell.Column + 1).PasteSpecial

    Next Application.ScreenUpdating = True

    End Sub
  • To post as a guest, your comment is unpublished.
    Moses · 2 years ago
    Thank you. It worked for me

    How do i change/modify the syntax to display image url's that are password protected
  • To post as a guest, your comment is unpublished.
    Russell Thrasher · 2 years ago
    Run-time error '1004':
    Unable to get the insert property of the Pictures class
    • To post as a guest, your comment is unpublished.
      Meg Russell · 2 years ago
      This is not working for me either. I have Excel 2013 and I simply need a straightforward piece of code that will insert images besides the urls that are in a column in my spreadsheet. Every single solution I have tried that is available via Google Search or via YouTube has rendered a pictures insert value error. What am I doing wrong??? Are the urls supposed to NOT be hyperlinks? Are they SUPPOSED to be hyperlinks? Am I supposed to identify the column range that the output goes to? I can't find a simple to follow set of instructions anywhere, please help. When I use YOUR code, I get "Unable to get the insert property of the Pictures" class:
      • To post as a guest, your comment is unpublished.
        Peter · 2 years ago
        I had the same problem and it turns out you need to check your url. if it is HTTPS that means it is a secure connection and VBA will not be able to extract it. if it is a regular HTTP there should be no problem
  • To post as a guest, your comment is unpublished.
    Danny · 2 years ago
    What issue are you getting?
  • To post as a guest, your comment is unpublished.
    RadmilaHU · 2 years ago
    I have tried the formula, but it does not seem to work. Would it have to do something with the version of Excel (I have the newest version, though)

    I appreciate your answer
  • To post as a guest, your comment is unpublished.
    Danny · 2 years ago
    This was a great help, ty so much
  • To post as a guest, your comment is unpublished.
    Shayla · 2 years ago
    Could you change the "on error resume next" to something that will wait until Google Chrome has time to open the picture? I tried this code and it works, but some of the pictures are getting pasted several rows below where they should, so I'm assuming the "on error" statement is not giving it enough time. If you think it could be something else or have any other suggestions, I'm open to hear it. Thanks!