GregIndiana Posted August 27, 2015 Report Share Posted August 27, 2015 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 Thank You!!! ~Greg Quote Link to comment Share on other sites More sharing options...
Cory Posted August 27, 2015 Report Share Posted August 27, 2015 Why use VBA instead of MEP to get to the upload page? Can you click the upload button in MEP? Quote Link to comment Share on other sites More sharing options...
Cory Posted August 27, 2015 Report Share Posted August 27, 2015 Are you sure there's no option to upload these files using FTP? Quote Link to comment Share on other sites More sharing options...
Cory Posted August 27, 2015 Report Share Posted August 27, 2015 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. Quote Link to comment Share on other sites More sharing options...
GregIndiana Posted August 27, 2015 Author Report Share Posted August 27, 2015 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 Quote Link to comment Share on other sites More sharing options...
GregIndiana Posted September 24, 2015 Author Report Share Posted September 24, 2015 Shameless Bump Quote Link to comment Share on other sites More sharing options...
Cory Posted September 26, 2015 Report Share Posted September 26, 2015 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. Quote Link to comment Share on other sites More sharing options...
Look_Up Posted October 8, 2015 Report Share Posted October 8, 2015 When the upload window appears can you select more than one file (control and mouse click) or select all (conrtol+a)[strg.+A] ??? Quote Link to comment Share on other sites More sharing options...
Samrae Posted October 13, 2015 Report Share Posted October 13, 2015 That depends on what the upload window looks like and how it works. Ask yourself, what should I type in the upload window to select more than one file? Once you answer that you can create a macro to perform those actions. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.