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...
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...
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...
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...
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.