Saving file using wildcard

[Jhansen5452]

I can get the file to save to a directory I specify, but it looks as though I need to save the workbook to a more specific and variable folder. The book gets saved to a customer folder. That part I've got down, as well as naming the workbook, but I need to the path to go to a more specific file within the customer folder that always changes depending on the part number. The first 2-4 characters change and the remaining characters are x's. All parts with those matching first 2-4 characters are in that specified folder. I'm having trouble using the wildcard function to specify the sub folder inside the customer's folder.

Please Login or Register  to view this content.

[alansidman]

Suggest you post your current code for analysis and explain specifically what you want it to do that it is not doing, ie. and example.

[Jhansen5452]

In this section

Please Login or Register  to view this content.

I'm wanting to remove the "Inspection Reports" part and instead specify a sub folder that changes for each part. I've tried using the wildcard to specify that the sub folder starts with the first part of the part number but was unsuccessful.

[alansidman]

Change that part of the path to a variable (Dim y as string). Then if you want to control the variable, create an input box that you can populate with the sub folder name.

Please Login or Register  to view this content.