Jump to content
Macro Express Forums

Recommended Posts

Hello,

 

Wondering if someone can point me to some info on how to solve a problem I'm looking to solve with Macro Express. I have a list of ~ 100 variables Such as A1000, B1200, B1300 etc. These variables coincide with text files I need to upload to a website. I'd like to loop through these variables and upload textfiles that are essentially the names of these variable i.e. A1000.txt to the website. The website has a page with a button that asks you to locate the file in question. After locating the file you click submit and the file is uploaded. I've been able to use VBA to bring me to the page where these files need to be uploaded one at a time, but having trouble using MacroExpress to perform the upload. Thoughts? This problem is causing me to bang my head into the desk. I'll send homebrew to the kind soul who can help :rolleyes:

 

Thank You!!!

~Greg

Link to post
Share on other sites

And your loop seems odd. I think it would be better to Repeat with Folder or make a text file list of files to upload and loop though them with Text File Process command.

Link to post
Share on other sites

Thanks Cory for the uber fast response. FTP would make my life much easier but unfortunatley this option is not available. I'm thinking your suggested solution of repeat with folder may be the way to go? To provide more detail:

 

Have a cross reference file with 100 text file names. It would look something like this:

A1000_Upload.txt

B1000_Upload.txt

C2000_Upload.txt

 

I'd like to create a URL to load a webpage using the data from within the cross reference file to create a piece of the URL. Example:

generate a URL like : http://wwww.something.com/Fileupload_A1000_Generation.html. The A1000 in this URL example would be generated from the first 5 charachters of each line in the cross reference text file. This webpage has a button that when clicked asks for a specific text file, A1000_Upload.txt, B1000_Upload.txt, C2000_Upload.txt, etc., based on where we are with looping through the list in the cross reference text file.

 

Thanks and any thoughts appreciated!

~Greg

Link to post
Share on other sites
  • 4 weeks later...

It's hard to give you exact instructions because I'm not clear what the normal process is. As I understand it now you go to a URL that you described and click and upload button. Once the upload dialog box appears you enter the file path and name and click OK or something. Assuming that ho w it works...

 

I haven't used MEP to do anything like this for some time but it seems pretty simple. Loop though the file and extract the text you need to form the URL and then launch IE with that URL. Then figure out how to make the upload button function using the keyboard. Usually a series of tabs and an enter. Then when the dialog box pops up use the controls features in MEP to stick the file name in there.

Link to post
Share on other sites
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...