data aquisition

  1. K

    VBA vs Visual Studio

    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...
  2. C

    Show a list of data based on a value in a column on another sheet

    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...
  3. R

    Retrieving info between two spreadsheets in an intranet

    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...
  4. E

    Can any one tell me how to assign a worksheet as the xml source?

    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...
  5. E

    data from and to user form

    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...
  6. E

    office 2003 works better than office 2007

    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...
  7. E

    Battle with Error 2029

    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...
  8. E

    sorting between column pairs

    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...
  9. J

    Getting external data from the web

    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...
  10. E

    difficulty with ClearContents,

    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...
  11. E

    controlling IE using vba from within a worksheet additional info

    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 =...
  12. E

    controlling IE using vba from within a worksheet

    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...
  13. E

    Data not being transfered to firs column

    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...
  14. E

    controlling data

    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...
  15. E

    Data management

    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...
  16. N

    Data Aquisition Time Stamp Issue

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top