Cherry Picking a file to process

[andrew_canfield]

Some drawings need to be converted to pdf's (separate thread in progress for that)

How can files be selected to be opened, processed & closed.

Everything is in one large folder, some have been converted others are WIP:

(it's a PDM system & task scheduler can't access the working folder).

I'm thinking along the lines:

(then come up with a way to add a list of numbers)

where the number can be concatenated into the file path & use "for, next" - to work through the list?

Pretty simple but testing me!

In my test i had the line for A= 1 to 3 & the message box opened up three time with the number changing.

altered to 11;22;33;44  hoping the message box would display 11 then 22 then 33

I wish task scheduler would work!

Regards

Andrew

[andrew_canfield]

This looks promising, just need to replace ("Red", "Green", "Blue") with the file number - in a user friendly way.

Create an array of drawing numbers..

Sub ArrayLoop() 
    Dim avColors As Variant 
    Dim vItem As Variant 

    avColors = Array("Red", "Green", "Blue") 

    For Each vItem In avColors 
        Debug.Print vItem 
    Next 
End Sub 

[chandra.shekar.g]

@andrew_canfield,

Hoping that below VBA code helps

Sub ArrayLoop() 
    Dim avColors As Variant 
    Dim vItem As Variant 

    avColors = Array(11,22,33,44) 

    For Each vItem In avColors 
        Debug.Print vItem 
    Next 
End Sub 

Thanks and regards,