Error in .SelectedItems during File Picking [Closed]

Question

Error in .SelectedItems during File Picking [Closed]

Report

adikademani

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

- Nov 14, 2016 at 04:02 AM
yg_be

Posts: 14452
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: March 4, 2021

- Nov 15, 2016 at 04:29 PM

Hello Guys,

I am trying to save a file path in a variable using .SelectedItems but the code is showing "Runtime Error 450". Kindly help me by rectifying the mistake in the code. Thanks in Advance :)

Sub pickafile()

Dim x As FileDialog
Dim y As Variant

Set x = Application.FileDialog(msoFileDialogFilePicker)

x.Filters.Add "Images", "*.jpg,*.jpeg"
x.Show

y = x.SelectedItems

ActiveSheet.Pictures.Insert(y).Select

End Sub

Error in .SelectedItems during File Picking
Error 3 cannot find file map ✓ - Forum - YouTube
Parse error: syntax error, unexpected end of file in - How-To - PHP
Solution For Fatal Error: Cannot create output file - How-To - Windows 7
Save Adobe Acrobat Warnings and Errors in a Log File - How-To - PDF
Error while deleting the file - How-To - Windows

1 reply

Ask a question

yg_be · Answer 1 · 2016-11-15T16:29:11-0500

Answer 1 / 1

yg_be

Posts: 14452
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: March 4, 2021

4
Nov 15, 2016 at 04:29 PM

On which line do you get "Runtime Error 450"?

Error in .SelectedItems during File Picking [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!