Excel 2010 Crashing when select to insert picture

[dcoledc]

Does anyone see any problems or know of any problems with using this code in Excel 2010 to select an image to insert?

myPicture = Application.GetOpenFilename _
("Pictures (*.gif; *.jpg; *.bmp; *.tif),*.gif; *.jpg; *.bmp; *.tif", , "Select Picture to Import")
If myPicture = "False" Then Exit Sub

This code seems to cause Excel 2010 to crash at random. It works sometmes with no problems at all and then suddenly it crashes Excel. Again this is only happening in 2010.

 

[Domenic]

As far as I can see, your code seems fine. And, I've tested it a number of times on Excel 2010 and had no problems.

 

[ZVI]

Just a thought, If myPicture = "False" Then Exit Sub plays only if myPicture is declared As String variable.
Check this declaration in the code: Dim myPicture As String
Because without it it's variant, myPicture = False (boolean) and the code goes down uncontrolled.

 

[dcoledc]

Thank you both fro checking that out. I do have mypicture defined just as you have it.

I have found on several occasions Excel 2010 randomly crashes when running code with no rhyme or reason. This may just be another one of those examples.

Thanks again.