Use userform collected data to open a file

Hi, I'm trying to use a userform to open a previously saved file to avoid having the users dig through the folder and maybe work on the wrong file.

I have a file I have created to test if the code works, but the macro keeps giving me the reponse I set in case it doesn't find the file.

The data for Account (Account1 and Subaccount1) is coming from a text box, as well as for category (Category1). The data for Company is an optionbutton frame with 4 options for the user to select from. Thanks in advance for any help!!!

Please Login or Register  to view this content.

Store the path & name in a hidden sheet

I mant you could store the path in a worksheet then retrieve it with the code.

can you attach a sample workbook

I can't really heck this but it looks like the name is incorrect try checking it by adding a messagebox

Please Login or Register  to view this content.