Recent content by Lagoon1

Hi guys I am fairly new to networking and need some help, I was wondering if you could point me in the right direction. I have connected the cables for the computer. The version of Windows used is Windows ME for one computer (Main computer) and the other computer is Windows XP. I am not sure...

Hi I am trying to format my pc but not sure how to backup all the emails I have in MS Outlook and Outlook Express. Can someone pls kindly help out? Thanks very much. Kind Regards, Lagoon1

Hi bcastner Thank you so much for your reply. I have tried all the above but still to no avail. Any more thoughts? Thanks very much and Hope to hear from you soon. Kind Regards, Lagoon1

Hello Is anyone able to help out as I have an Internet Explorer problem? The version of I.E. is Version 6.0.2800.1106 The problem I have is that I cannot seem to set my homepage to my desired one. I have tried setting under Internet options to my desired homepage but everytime I close the...

Hi PHV Yes, I have tried reading the html source of the URL that i tried to grab. Up to the stage where there is a question mark, i reckon those would be the parameters? Would there be any signs or symbols that might point it out or make it stand out? Thanks. Lagoon1

Hi PHV What do you mean by a frames issue? Very limited knowledge about this. Can you please kindly explain and provide any resolution to overcome this frames issue. Thanks. Lagoon1

Hi Drlex I will try to see if there is anything that I can do. Otherwise, I might have to come back and see if you can come up with anything else. Thanks very much for your help. Cheers, Lagoon1

Hi Drlex Thanks very much for your reply. I am actually trying to bring in data from Powerplay. Below is the vba code that i used in the vb editor in microsoft excel. Sub URL_Test() With ActiveSheet.QueryTables.Add(Connection:="URL;http://This/Is/a/test/", Destination:=Range("a1")) 'write...

Hi Thanks for all the help. 1. Is it possible to exclude all the hyperlinks and also when the data is copied into excel, it seems those drop-down arrows turned into text with hyperlinks (i.e. sort descending or ascending). 2. Does anyone know of the method to extract the data via the url...

Hi I need help launching files from Cognos to Excel via a macro button. I've tried running a macro from excel to extract data but with the following problems: 1. Seems to work once and not the other. (Is there a problem with the IP address?) 2. Data extracted comes up with the sort...

Hi Tomreid I've tried a few web site but with no success. Any ideas? Cheers, Lagoon1

Hi Xlbo Thanks for responding. I've tried your suggestion and it seems to work pretty well with the exception that there are a few things which I wouldnt want to show up on my extract in excel. Example On the web site, there seems to be those dropdown arrows and when I extract the data onto...

Hi SkipVought Example Original Value Cell A1 - Adjust by / 0.5% and total Cell A2 - Adjust by / 1% and total Cell A3 - Adjust by 10.5% and total Cell A4 - Adjust by 110.5% and total End Result Cell b1 - 0.5% Cell b2 - 1% Cell b3 - 10.5% Cell b4 - 110.5% Thanks.

Hi Can someone please help out with web queries. 1. Are there any limitations on the type of data I import from the web. Even though I've set the import only html tables to false, it seems that the data that I am able to import is not what i would have expected Example of a web site's data...

Hello Can someone please kindly assist whereever possible. Thanks. Rgds, lagoon1