Jump to content
Macro Express Forums


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About MrBiggz

  • Rank
  1. Hi, I'm trying to do something very similar. Basically I would like it to open a site, prompt for input of a 5 digit number and then have ME find it on the site and scrap the data around it and paste it into a text box for displaying. I would like it to do this without opening the webpage fully, if it can do it hidden or perhaps minimized would be best. This is far as I've gotten so far. <CLEARVAR1:T:ALL><TVAR2:01:02:FEnter 5 Digit numberFFCenter:Center><HTTP2:1:T:http://bob/main/officeListingServlet?country=USA&state=state_all&div=select_all&next=USCA_LIST&search_type=USCA&country_list=USA&state_list=state_all&div_list=select_all><TEXTTYPE:<CONTROL>f><MSD:0150><TEXTTYPE:%T1%>
  2. I GOT IT!! So here's the final code that got it to work! Clear Text Variables: All Variable Set String %T1% from Prompt Text File Begin Process: "Test.csv" If Variable %T2% Contains %T1% Break End If Text File End Process If Variable %T1% = variable %T2% Text Box Display: DIA End If If Variable %T2 does not contain variable %T1% Text Box Display: NO DIA End If
  3. Thanks. It kinda worked. So the CSV file has in the first column about 300 cells filled with information. I just need to do a check against that CSV file to see if the data entered from prompt (%T1%) is anywhere in that column. And if so display "Verified" and if not, display "NOT Verified". Unfortunately it's only reading the last cell that has data and putting that into variable %T2%. I'm not sure if I'm doing this correctly at all, I'm just kind of playing around to see if it is actually possible. Thanks for the help!!
  4. I need to create a Macro that prompts for an office number, and when the office number is given, it checks against a CSV file to see if that office is listed. If listed it returns a message on the screen of "VERIFIED" and if not's found in the file, returns a separate message of "UNVERIFIED". The problem I'm having is it checks against the file, but it returns both VERIFIED and UNVERIFIED messages even the office numbers are listed. Here's a copy of the code. <CLEARVAR1:T:ALL><TVAR2:01:02:FEnter 5 Digit Branch NumberFFCenter:Center><BTFBEG:002:000001:000000:C:\Test.csv><IFVAR2:4:02:1:T1><TBOX4:T:4:CenterCenter000278000200:000:DIAVERIFIED><ENDIF><IFVAR2:4:02:8:T1><TBOX4:T:4:CenterCenter000278000200:000:NO DIAUNVERIFIED><ENDIF><BTFEND>
  5. I'm hoping someone can help with an issue I'm having, not sure if it's possible but I would like to think it is. I haven't started the macro yet as I'm trying to figure out the best way to do this. The two elements of the macro are entering information into a web page (intranet) that displays some information and then to take that information and verify it against a spreadsheet. If the information is found in the spreadsheet, the macro will display a message saying "verified", and if it does not find the information in the spreadsheet, it displays a message that says "Not Verified". Does anyone have experience doing something like this or know how to begin to do this? Ideally I'd like to keep the spreadsheet hidden, but that doesn't work, so keeping it minimized would be the next best option as it's doing the lookup/query in the spreadsheet. Hopefully I've helped explain this clearly enough for everyone. Thanks again in advance for any help given!
  6. GOT IT! Thanks for the help Pat. Now on to figure out how to extract the data!
  7. Thanks Pat. Unfortunately I don't know vbscripting to get this to work as you have entended. I've copied the contents to notepad and saved as .vbs file, however from there I'm not sure what else to do. I'm going to play with this for a bit and see what I can do. Thanks again for the help
  8. Hi Pat, Well from balithag's post it sounds like he knows how to do what I'm trying to do, but I could be wrong. I would prefer this to file to be closed rather than open. Hopefully someone can help. :/
  9. I'm still fairly new to ME (best program EVER) and what I'm trying to do I think is the same thing. I have an excel spreadsheet that has a list of locations (Store #/City/State). I want to be able to run a macro that prompts me to enter one of these pieces of information and it brings up the rest of the information. Such as if I enter the Store # 1234 it displays the City and State information. Or if I enter in the City, it displays the Store# and State information. Sometimes we close stores and open new one's so the spreadsheet is always changing. Using ME to search and display this would be much easier and quicker than having to find the spreadsheet, open it, search it, and hope you have the latest information. Thanks in advance for the help!
  10. Is there a way to log when a .mex file is edited and changed? So every time someone add's a new Macro, makes a change, to the .MEX file, it will add that to the file? We have a shared .MEX file that everyone uses. Some is doing something and we want to be able to identify who. I have been able to create a macro that can pull username from the registry, I just need to figure out the rest. Thank you very much for the help
  11. Sorry for the late response. But yes, literally not in ME at all, then that message will pop up. However I haven't had that error in quite some time now. So maybe it was a corrupt macro that's now been deleted?? I dunno.
  12. Yes there is floating menu's. However I tested activating them and seeing if they popped up on other user's screen's, and it did not. Its just kind of random.
  13. We currently store our MEX file on a Shared Network Drive for everyone to access. And just lately we have had random floating menu's just pop up on everyone's screen's. Users will not even be touching their keyboards or doing anything to cause these to randomly pop up on the screen. Anybody experience this before?
  14. Has anyone seen this error before? And what does it mean? I'm not doing anything in ME and this error will just pop up. Thank you
  15. That's kind of scary! LOL...I just did it, it worked, but scary!
  • Create New...