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!

  • Congratulations bkrike 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: halobender
  • Content: Threads
  • Order by date
  1. halobender

    excel web query

    Hey all I have an issue and could use some extra brains. Here is what I have.. I have a web query created in excel 2010 which has imported three columns and 500 rows A = web hyperlink text B = place C = place I need to find a way to use vba or the web query itself to visit the web hyperlink...
  2. halobender

    Read/Write excel files from folder loop

    Alright I have a new dilemma I need to have a macro in a spreadsheet (the master) that needs to be able to read from several different different named spreadsheets from a folder specified by the user. I am currently able to open one file at a time no problem but i wish to create a loop that...
  3. halobender

    VBA replace / remove text/line breaks

    Hey guys I am trying to write a macro to remove extra line breaks in blocks of text and hope to accomplish this in a loop as opposed to writing each line by hand. The issue is this, the users that have used this spreadsheet have word wrap turned on and to make a different entry inside the same...
  4. halobender

    reading data from excel / vba help

    Hey guys.. Need some ideas for gathering some information from a closed workbook. I currently have a script that will open a workbook gather information and paste to a set area in a new workbook then close, however i need to edit this to do the following. search column B for text string over 5...
  5. halobender

    Error 2311

    I know this has been brought up in the past however I am wondering if someone could explain to me the steps to fixing this problem in detail. All the information that I have is that there are 800+ agents with exts, from time to time agents move but keep exts. Some of the old agents and brand...
  6. halobender

    attachmate and tsys (total systems)

    Does anyone know if it is possible to make an excel spreadsheet that will communicate and gather information (like rows of text from certain transfields) from a tsys session that is running in attachmate? If it would be possible where would I start to config something like this?

Part and Inventory Search

Back
Top