[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2014-04-14
1
Medium Priority
?
723 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
[X]
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
1 Comment
 
LVL 39

Accepted Solution

by:
PatHartman earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
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 …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

650 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