Inserting a picture with Path name in a Variable Closed

Question

Hello Guys,

  I am getting an "Error 1004: unable to get insert property of Picture class" with the following code. Looking forward for your guidance. Thanks in Advance :)

Sub newfile()

Dim x As String

x = Application.GetOpenFilename()

ActiveSheet.Pictures.Insert("x").Select


End Sub

ac3mark · Answer

You are trying to insert your VBA project name with that method!  The application, is the one running, which would be Excel.  Then the method on the application would be your excel sheet file name.

Try this:
Dim x 

X = "C:\mydocuments	hepicturename.png"

ActiveSheet.Pictures.Insert(X)

Inserting a picture with Path name in a Variable

1 response

Similar discussions

Subscribe To Our Newsletter!