Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: makavity
  • Content: Threads
  • Order by date
  1. makavity

    Upgrading from Windows XP to Windows 7 broke this macro

    I have a macro that was written a few years ago, and the team now using it is having trouble after upgrading their systems to Windows 7. The macro launches from Excel, opens an Internet Explorer window and captures data after entering a few things. I haven't been able to find the solution, nor...
  2. makavity

    VBA Object for Reflection for the Web 2011

    I am a barely proficient VBA programmer that had learned to write VBA code to import Excel data into Attachmate Extra. Our company has moved to using Reflection for the Web 2011, which has Java based macros. I'm trying to update my program to import the Excel data into the new Reflection for...
  3. makavity

    VBA Filling out IE form, but can't find form name

    I've been working on a macro to check inventory on merchandise. When I run the "Get Field" macro by CautionMP, the results are blank. Checking "For Each" form with a macro, it skips past the "Next" giving me reason to think there are no forms or they've hidden it beyond my skills. I believe...
  4. makavity

    Excel Macro to hit "Save" on an IE Form

    I'm using and application in Excel to fill out a form in IE. I've got the fields set, however I don't seem to be able to find the correct command to hit the "Save" button on the form. I'm new to using Excel to manipulate IE, and haven't found any reference to clicking on a button. Best I can...
  5. makavity

    Startup Macro Help

    My department has a few macros we'd like to run from Excel. We're attempting to use Excel to launch a process in a session, however when running a macro with Excel you can't do any work in Excel until it's finished. What we're targeting is having an Excel macro open a particular session, then...
  6. makavity

    Using Excel to Navigate in I.E.

    I'm the only person in my department who has any idea of writing excel macros, so I've been given the task of writing a macro to screen scrape a web site. "They're both microsoft programs, so it should be easy." I've tried a number of applications, and it appears that the site would have to be...
  7. makavity

    Internet Session "Timing Out" using Excel

    I'm trying to verify pricing on our web site with what our records show, and am using Excel to open the page and then use VB to extract the data. The odd thing is as I access our webpage from Excel, I receive info that the "Session Has Timed Out", however when I copy the same exact web address...
  8. makavity

    Subscript Out Of Range trying to Find a Worksheet

    I have a spreadsheet that pulls from another source that creates different worksheets based on sizes. Some sizes will not be found from sheet to sheet, so I'm trying to write a macro (with my VERY LIMITED knowledge) to pull some infomation from a sheet. I'm using For Next loops to go through...
  9. makavity

    Getting IE data into Excel

    My company is moving a lot of our reporting to Internet Explorer. In doing this, they have set it up to require a log-in, then you make selections on the IE web page, however each report does not have a unique address. The http://"StuffYouNeedToKnow.com" remains constant as you navigate to the...
  10. makavity

    How to get data from Excel without opening it

    I am trying to write an application in Extra that would access a shared Excel worksheet and pull information from it, without opening the worksheet. The information would then be displayed in a message box. The worksheet is available to over 1,000 other users, so I'm trying to limit the number...
  11. makavity

    Auto Hide Column

    Hi All! I'm working on a spreadsheet using a specific calendar to my company. We divide each 3 months using 4 weeks, 4 weeks, 5 weeks. I'm trying to set up each month to have 5 weeks, but to use a conditional format or something to automatically hide the 5th week column on the 4 week months...
  12. makavity

    Vlookup from different month worksheets

    Hi All. I'm working on a spreadsheet where I have 13 worksheets. One master, and 12 monthly spreadsheets. I'm trying to use VLOOKUP formulas on the master worksheet, and use the current month to indicate which worksheet the vlookup info should come from. I have the current month indicated...

Part and Inventory Search

Back
Top