Open different workbook in different path at the listbox

[ccs1981]

hi. good days,
how can i open a different path of the workbook in the listbox. if my listbox there only show the file name.

Please Login or Register  to view this content.

if the workbook in different path, it will show the error. please help me. thanks

Please Login or Register  to view this content.

[Kenneth Hobson]

Create another listbox and hide it or use a Public Array. You would then store the paths to one of these. Since you know the selected index from ListBox1, you can build the path&name from one of these plus your ListBox1.Value.

[ccs1981]

thanks you for your advices..
i solve it..