Use Selected Items in Multi Listbox To Perform Actions

[jamer02]

Hey guys,

I have a multiselect listbox which lists all the files within a certain folder, but I am unable to work out how to do the following:

For each selected item (which is the name of a file), I want it to open these files in turn, print out two copies of sheet 1 and then close and delete each file.

I will then be left with two printed copies of each file that has been ticked by the user and the corresponding file wiped from the hardrive.

Any ideas guys?

Many Thanks

Jamer

 

[wigi]

What action do you need help with? Because these are all standard actions in Excel VBA, at least in the help files and here on the board you will find thousands and thousands of topics with code for it.

 

[jamer02]

I cannot seem to find any specific to what I need, which is use the name of a selected item to match this exactly to a file name in a certain folder, for that file to then be opened, printed then deleted.

I really do appreciate your feedback.

Jamer

 

[wigi]

What are the items called in the listbox, and what are the EXACT file locations on the filesystem?

 

[wigi]

If you Google on:

excel vba listbox loop through selected items

and take the 1st site it returns, you already have the loop... Opening a file is done with Workbooks.Open. Printing a sheet with .PrintOut and closing a file with .Close. Deleting a file is done with Kill.

 

[jamer02]

OK, so for example the listbox lists all the file names from the directory "C:\Users\James\Documents\TEST\", using the following code:

Private Sub userform_Initialize()
  c00 = "C:\Users\James\Documents\TEST\"
  c01 = Dir(c00 & "*.*")

  Do Until c01 = ""
    c02 = c02 & "|" & c01
    c01 = Dir
  Loop

  ListBox1.List = Split(Mid(c02, 2), "|")
End Sub

I know want the selected items in this listbox (which are of course files in essence), to be opened, printed, closed and deleted.

Now, why I am getting confused over this is because I am not sure how to use the name of the selected item in the listbox to find the corresponding file in the directory to perform the actions.

I hope this helps you help me.

Many Thanks

Jamer