Jacko Posted March 23, 2021 Report Share Posted March 23, 2021 Hi I would like to have a Macro that logs into a website and then uses a .txt file contents to search for response's and to be able to record the search and number of hits for the response on the search term i have written the login and navigate to the area to search i have a txt file but cannot figure out how to add the contents of the file line by line and how to write the results to a new file. Please contact me if you have interest in this project Quote Link to comment Share on other sites More sharing options...
Cartwheels Posted March 30, 2021 Report Share Posted March 30, 2021 Window Activate: Macro help required willing to pay ASCII File Begin Process: "C:\Users\YourUserName\Documents\Temp\YourFile.txt" (Tab Delimited Text (.txt)) Text Type (Simulate Keystrokes): <CTRLD> Text Type (Simulate Keystrokes): f Text Type (Simulate Keystrokes): <CTRLU> Delay: .3 seconds Text Type (Simulate Keystrokes): %T[1]% Delay: .3 seconds Text Type (Simulate Keystrokes): <TAB> Text Type (Simulate Keystrokes): <ESC> Clipboard Copy Variable Set String %Results% from the clipboard contents Text Box Display: Results If Variable %T[1]% Equals "%Results%" Text Box Display: Results2 // Found Else Text Box Display: Results3 // Not Found End If ASCII File End Process This may help get you going in the right direction, recording results and number of hits would require more time, which I may have tomorrow. Other people may have ideas on how to accomplish this project as well. There is another way too, but need real world example of what we are trying to do. Quote Link to comment Share on other sites More sharing options...
rberq Posted March 30, 2021 Report Share Posted March 30, 2021 5 hours ago, Cartwheels said: need real world example of what we are trying to do Sample of a few lines of your text file would be useful. Sample of what the output text file should look like. Ideally, sample or URL for the web page if it's not proprietary. Sometimes it works well to copy the entire web page to the clipboard, then from clipboard to a variable, then find and count the search items by repeated "IF VARIABLE CONTAINS" commands. Expanding on what Cartwheels has coded.... 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.