data aquisition

Hi Folks; Bit of an abstract question about using Excel VBA or Visual Studio as a platform - what I'm really trying to ask is 'where is the tipping point' between Excel with forms and going to a software and database? How big can you take an Excel VBA application before it's too much to handle...

Hi Excel masters. I just need help with the formula to use in my report Let's say I have a summary table on Sheet 1 6000 rows of data on sheet 2. In Sheet 2 I have 3 columns, Name, Month and Score. Name Column (A) has names of students Month Column (B) has months January, February and so on...

Hey guys! First of all, this place is a life saver. I need to make an excel spreadsheet that retrieves information from another excel spreadsheet (the database) -- both of these are in an intranet. Now, the retrieval of information should be limited to whatever is in the database. Meaning in...

The set up is office 2007 windows XP professional IE8<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> At present I have an HTTP string which I dispatch via InternetExplorer.application the data is then sent back as xml and is pasted in the column A This bit...

up date to my post get data to and from a text/combo box on user form I am now using office 2007 and to simplify<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> All I basically need is the format/syntax to getting data to and from a user...

The pc that is affected is running xp home and office 2007 ie8 I am up dating that data relating to a list of ISBN’s via the internet, and using two pc’s to do this as there are some 6.9 million of them each pc processes about 28 000 per day. And running exactly the same excel work book just...

Win xp professional office 2003 ie 8 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> <o:p> </o:p> Battle with Error 2029 <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> This is the code that generates the error and I can not see why? As it runs for...

WIN XP PROFESSIONAL OFFICE 2003 IE 8 I am looking for some vba that will sort and delete, to expand upon the requirement I have data in two columns that are related to each other so the contents need to remain as a pair, there are another two columns with the same arrangement what I need to...

I wish to be able to get tabular data from a web page. The complication is that it is a secure page, so I first log on to https://blah.co.uk/Logon/Logon.aspx and then have to enter a username a validation and a password, that then passes me to a page of tables. The problem I have is how do I get...

WIN XP professional office 2003 IE 8<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Hello I am having some difficulty with ClearContents, <o:p></o:p> <o:p> </o:p> The problem arises when I clear the contents of column A to make ready for new...

Sorry that I have opened another thread I could not find how to append the original one, maybe some one could tell me how to append the original for next time also is the a way to say that you have received an answer that works and you no longer need help with that item?<?xml:namespace prefix =...

Win xp office xp 2003 IE 8<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Object to open IE by clicking a url on worksheet and then select all the copy then past data into column A<o:p></o:p> <o:p></o:p> <o:p></o:p> At the moment I am doing...

XP Professional office 2003 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> <o:p></o:p> Having difficulty spotting my error, the code I am using was kindly given to me and I modified it for my needs, it is meant to places the data in the next...

My os is windows xp professional office xp 2003 ? not 100% on that <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> <o:p></o:p> Hello thank you to those people that have helped me with the column issue, As I got it a bit mixed up that’s not what...

copy two columns form one work sheet to the next to available on another, look all over the web for this can’t find it any where plenty to next row but not next column<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> if you know of a post or...

Hello All, I have a large array of data that I am trying to work with. It is data from a data aquisition system. Each entry is marked with a date/time stamp. Due to elements beyond my control there are gaps in the data. For example it may jump from: Nov 28, 2008 06:15:00 to Nov 31, 2008...