Need help saving worksheet based on combobox option

Hello forum members and guests!

I need your help in solving an issue I get when trying to assign a worksheet to a worker based on a combobox option (worker's name). When the value of combobox "Assign" is "Now", the worksheet should be saved to a folder named for the worker who is getting the file. The value of combobox "Worker" should provide the name of the worker so that the file is saved to his folder with his name in the file's name.

Here's the code I'm trying to use to accomplish the task but it isn't working... I get the error: "Object doesn't support this property or method".

Please Login or Register  to view this content.

The function "IsFileExists" is declared and defined inside a worksheet module. I've been working on this for a while and I can't seem to find the solution to the problem... I may be missing something trivial but can't put my finger on it at the moment. Please let me know if anyone can come up with something.

Many thanks!!!

Good day forum members and guests

It took me a while but I finally found a way to make the routine work the way I wanted it to... it's a bit long and impractical but it worked! I created a "Select Case" for the combobox "Workers" in which I defined the path for "myFolder" and the name for "myFile" for each of the workers in the list. So, instead of having the code written as previously posted, I now have something like this:

Please Login or Register  to view this content.

I'm sure that there is a better and more elegant way of resolving the issue but the above code worked for me... and I hope it helps someone else resolve his/her problem.

Cheers!!