Inserting a picture with Path name in a Variable [Closed]

Question

Inserting a picture with Path name in a Variable [Closed]

Report

adikademani

Posts: 6
Registration date: Monday October 24, 2016
Status: Member
Last seen: November 24, 2016

- Nov 9, 2016 at 02:39 PM
Blocked Profile - Nov 9, 2016 at 04:59 PM

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

Inserting a picture with Path name in a Variable
How to insert a picture in a Word document? - How-To - Word
Insert a picture watermark only on selected pages - How-To - Office Software
How to insert background picture in word - How-To - Word
Macro to insert multiple pictures in excel - How-To - Excel
Insert a picture in gmail signature - How-To - Gmail

1 reply

Ask a question

Blocked Profile · Answer 1 · 2016-11-09T16:59:52-0500

Answer 1 / 1

Blocked Profile
Nov 9, 2016 at 04:59 PM

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\thepicturename.png"

ActiveSheet.Pictures.Insert(X)

Inserting a picture with Path name in a Variable [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!