Run Time Error "1004": Unable to get the Insert property of the picture class

[rmeckm2]

I have this code to look up a picture in a folder. It was working just fine when i coded this earlier today, then i emailed it to a coworker and now it wont work at all. Any advice would be appreciated.

Please Login or Register  to view this content.

[xladept]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


*is the backslash the ultimate entry on the sFileExtension??

[rmeckm2]

Not sure what code tags are and could not see the red hashtag after highlighting my code.

not sure what you mean by ultimate entry.

also i have a 2 versions of this the spreadsheet that use this code. One uses active x controls and the other uses form control. This code still works perfect in the version that uses active x control but does not work in the version that uses form control even though it worked just fine previously.

[xladept]

Code Tags do this:

Please Login or Register  to view this content.

*Ultimate entry is the last character - it must be a backslash to engage the directory

[rmeckm2]

screenshot.png Here is a screenshot if that helps. The file path is valid and the picture being looked up if a valid picture in that folder

[xladept]

You need to put the code tags on your post#1.

The screenshot doesn't help - just check to see that the directory call ends in a backslash.

AND:Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[rmeckm2]

Issue resolved. It was the ID 10 T error. I had password protected the worksheet and forgot to put the code back in to unlock the worksheet, run the macro, and then reprotect the worksheet. Works like a champ now just needed to sleep on it.

Thanks for the help.

[xladept]

You're welcome although it wasn't much help - glad you figured it out!