Problem in accessing file name from Input box

  • I am attaching a code where I get the details of folder and file names and based on that do a series of actions on two files. The code gets stuck in the step "Workbooks(MyFilename).Activate". Basically the file name "MyFilename" from Open_File function is not getting passed to the " OpenWorkbookFromFolder" sub.

    any suggestions on where the problem could be?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!