Search results for query: *

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

Hi JOJ Sorry, your formula works but it does not include the percentage. Anyway, I had worked around it with the cell formatting. By the way, why do you have to add 5 and then minus 5. Although the formula works, can you please kindly brief me about your formula. Thanks. Regards, lagoon1

Hi Guys Unfortunately, the functions above does not work. Any other ideas? Thanks. Regards, lagooon1

Hi Quick question. Is it possible to set up a line graph from charts with the following attributes. Horizontal Axis Financial Year being F '02 (Act) F '04 (Forecast) F '05 (Budget) Vertical Axis (1) Sales $000's Vertical Axis (2) Others Please kindly include a sample of how the...

Hi PHV I havent had the chance to test it out yet as I've left the file back in the office. I will keep you posted once i get around it next week. But nevertheless, I would like to thank you for your tireless efforts in trying to solve the problem. Thanks very much. Kind Regards, Lagoon1

Hi Need some help with a formula. 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 I need a formula that extracts just the value and % from the above cells. I've used the search function but seems...