Guest User

Untitled

a guest
May 23rd, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. ....
  2. For Each PictureFilename In FileList
  3. i = i + 1
  4. If i >2 then
  5. 'do next two pictures but how to handle the next two?
  6. Else
  7. Set Photo = PicWorksheet.Shapes.AddPicture(CStr(PictureFilename), msoFalse, msoCTrue, 1, 1, -1, -1)
  8. Set pic = Nothing
  9. Set pic = Photo
  10. colPictures.Add pic
  11. End If
  12. Next
Add Comment
Please, Sign In to add comment