If the server where your excel files reside is on the local network all you have to do is create a shared folder and then you can easily access it from other machines using UNC path, you will also have to make sure that the user reloading the application has reading previleges for that folder:
If your server containing Excel files is inside your company network, share the directory and do a classical LOAD with an UNC path (e.g. LOAD....FROM [\\servername\serverpath\MySharedExcel.xlsx]...)
If your server is outside your company network, see if you can use either straight http: or ftp (when a username and password are required)
In your script, navigate to the spot where you want to load the Excel file over ftp. Enable the ftp-switch next to the Table Files... button, and then press the Table Files... button. A dialog appears that lets you specify login credentials, and navigate the ftp site. Enter the items the dialog asks for. Check the generated LOAD statement for any errors (the syntax should be obvious) and test.
While using FTP, one excel file is loaded at a time in qlikview. And to load the next excel file, again I have to apply all the login credentials of FTP Server. I want to avoid this, is there any other solution for it?
No it isn't. You can also transfer a file using HTTP, which is way faster than FTP (ftp is very old and very inefficient). However, AFAIK QlikView doesn't support authentication for those connections. See the Web Files... button in the script editor.
Unlike a database connection in QlikView script, an FTP transfer in your script doesn't support sessions (where you open a connection, do various tasks and finally close the connection). You'll need a real FTP-client to perform batch-transfers, or a connector. Check the Qlik Market.
