I would like to upload an Excel file from my PC to a server. I have found PHP code that requests the user to select the file then submit it.However, I need to provide the file name directly (in code) and not via a request process.

In my Excel vba coding I can call an HTML file on the server using a hyperlink. My problem is how do I send the name and path of the Excel file to the HTML file, (as mentioned I need to avoid going through the file name request process).

Is there a way of including data (file name, etc) into the hyperlink that the HTML file can extract?

I'm really new at this server side coding so I don't even know if the above is possible.

Yes, that is correct. I'm still having trouble mapping the drive. I use the Windows mapping wizard but I'm obviously putting in the wrong info.

I've progressed somewhat with another method. I have a PHP file on the server which will upload a file from my PC if the name of the file is passed to it. I can achieve this from an HTML file on my PC which requests the user to select the file and submit the file name. This prompts the PHP file to upload a file from the PC.

What I would like to do is change the HTML file so that it executes on load and not from a user request.

That's where I'm stuck right now. The HTML code that doesn't work is as follows:

I am confident that i can help with this one, but will not be able to really commit any time to it before like monday sorry, am working right now and my weekend is kind of booked up. monday morning at the latest i should have a working script for you .

I set up FTP through the Windows Add Network Location wizard. Then I could see my server on my PC (Windows Explorer). I then added vba code in my Excel file so it would SaveAs on my server. Sometimes it worked other times nothing happened.I'd be interested in your PHP solution.