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

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

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

Hi I have set up a listing of file names on, say Sheet 1. I would like a code that loops through the folder and returns "file found" or "file not found." I have already set the filter for the type of files that I need. Can someone pls kindly assist. Thanks very much...

Hi I am trying to extract data via Microsoft Excel's Web Query tool. Is it possible to do so? I've tried setting up the .iqy files but with no success. I'm not really sure what the implications are but with web queries from normal websites, it seems to work fine but not with the Cognos Cubes...

Hi Can someone please help out. I am trying to create a web query and I've been going through these few steps. Please kindly advise where I've gone wrong. 1 Save a txt file in notepad with the .iqy extension 2 In notepad, I've the following codes. Comments Codes Web 1 Servers/File...

Hi I need some help with my query update in excel via External data. With Selection.QueryTable .Connection = "ODBC;DSN=.............;" .Sql = Array( _................where........... ACCN Like ' " & myvalue3% & "' The parameters I select in Microsoft Query for the above...

Hi I seem to get this error message with Windows Media Player. Is there anyway of rectifying this issue? No combination of filters could be found to render the stream. (Error=80040218) Thanks. Cheers, Lagoon1.

Hi Is there anyway of copying and dragging the cell so that the formula such as Sheet2!A1 in cell A1 becomes Sheet3!$A$1 in cell A2. Thanks very much. Cheers, Lagoon1

Hi I would like to call up an application , say for example an AS400 tool as part of my customized menu. Please kindly advise of the syntax in VBA that I can utilise to create this macro. Thanks very much. Regards, Lagoon1.

Hi The problem that I am facing are listed as follows:- Sql.= Select distinct a,b,c,d from ...... where......... Distinct applies to all the fields that I've selected. Can I omit "d" from being distinct? The above is the sql property from Microsoft Query and by selecting unique...

Hello I need some help with trying to update a query that I created in Excel. As the amount of data that I extract periodically each time is quite huge, therefore, I have to add a criteria in query to filter via Month (Period). This requires constantly going into the query table to change...