Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Using VBA to Set File Path and File Name in Web Pages in Order to Upload Data

Posted on 2014-04-14
1
676 Views
Last Modified: 2014-05-21
Have VBA code to logon and walk thru a password secured website the last  web page shows a dialog/text box and browse button, the input type of the text box is "file", so it will only accept input from the file browse there is also a transmit button to upload the file. I am unable to alter the webpage - it is a 3rd party page.
My problem is I am unable to programmatically  insert the path and filename of the file to be uploaded into the textbox.
need some helpscreen shot of webform to upload a file.
0
Comment
Question by:durick
1 Comment
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40000422
Are you asking if Access can navigate to a web page and poke some data into a field and then press a button?  The answer is an unequivocal maybe.  Can you use the paste function of windows to populate the field?  If you can't, then Access won't be able to either.  If you can, I think you will need to figure out the name of the field and the name of the button.

It is pretty dangerous to try to paste data into a web page that you have no control over.  I would talk to the webmaster to find out if they have a service you can use instead.  That will make a cleaner, less likely to break, interface.
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question