Search results for query: *

Hi In outlook 2007 there is a propose new time button. Can you do the same for location somehow? Thanks, Chris

sqlToRun = '''SELECT TOP 1 * FROM ADDRESS WHERE ad_city = @city ''' curs.execute(sqlToRun, {'@city': 'NEW YORK' }) #sqlToRun = '''SELECT TOP 1 * FROM ADDRESS WHERE ad_city = 'NEW YORK' ''' #curs.execute(sqlToRun) inlineSqlResults = curs.fetchall() print inlineSqlResults...

Hi, I have a Dell laptop with N wireless card in. I have a belkin draft n wifi router (belkin). I have qnap raid nas wired into the router via cat 5 cable. My laptop says it has got a 144Mps connection but when I try to copy a file from the laptop to the nas it does it at about 12Mbps (~1.5...

Hi, How do I have by default read receipts requested in Outlook EXCEPT for a specific set of recipients. Thanks, Chris

Hi, If I have a bunch of objects and I want them to have graphics which draw onto a form. How do I make that happen? In Java Swing (a while back) you could make objects extend JComponent and rectangle. And then use the paintMe method to draw. What do you do in c#? Cheers, Chris

what formulae could be used to find the addreess of a cell in a worksheet that contains a specific string? Thanks, Chris

Hi, Is there programmatically a way to create a excel.exe session but make it exempt from opening a workbook when a workbook xls is double clicked on? I want all other excel.exe sessions to be able to open the xls, however this one shouldn't. Ideally you double click the myExcel.xls and it...

Hi, I'm looking at code which uses the paramarray keyword. Here is an example public function FirstFunction(ParamArray args()) as long debug.print ubound(args) FirstFunction = SecondFunction(args()) end function public function SecondFunction(ParamArray argS()) as long debug.print...

In tracking options in outlook 2007 I have set to process receipts on on arrival and after processing move receipts to a folder. The receipts are not mnoved to that folder. Does anyone know why? Cheers, Chris

Anyone else noticed that when you do myDic.item("SomethingNotExisting") it returns empty but adds an item to the dictionary?

Hi, On some PCs when an excel session is shut with a specific sheet a vba project password prompt comes up, asking for the password for the file. Any idea why this happens? Thanks, Chris

Hi, Do you know of any below £200 that do this, any brand? Thanks, Chris

Anyone had this issue where they use \\othercomputer and the shares on that computer shows. And then it stops working all of a sudden if though you can ping othercomputer?

Hi, I have lots of data in a folder and I want to copy it to another folder (which already has some of the data) I don't want to have to wait for it to copy and overrite all files. I only want to overrite files which don't already exist in the 2nd file. I want to start the copy process and not...

Hi, How in VBA in Excel would I search for all Excel.exe processes that currently exist on the machine and set a reference to the Excel object which has a workbook called "TheWorkBookIWant.xls"? Thanks, Chris

Hi, If I set a cell to have the formula =A1 on a sheet and A1 has nothing in it I get nothing. If I set a cell to have the forumla =A2 on the same sheet and A2 has nothing in it I get 0. Does anyone know why there is this inconsistent behaviour? Both A1 and A2 having nothing in and are...

Here is an example: Say you have a config worksheet and you have loads of data in this table related to people. I now want to add the cars people own and then later extract the cars they own without using vba. The two ideas I have is taking (note | is next cell): Name | Car 1 | Car 2...

Hi, How do I get the "grand total" from a pivot table into cell B2 (for example). When I do = to the cell Excel automatically creates the formula =GETPIVOTDATA("Stuff",$Z$12) But when I change the pivot table then I lost the total. I want to get the total of the data the pivot table uses...

Hi, Why is the usedrange of a workbook often bigger than where the last filled cell is? If you clear everything why is it still there? Why do you have to delete rows? Thanks, Chris

Hi, What Excel function is there that takes in a range of peoples names that will only return the unique ones and spit it out on the sheet, a bit like advanced filter? Can you make an advanced filter persist and update on calculate? Thanks, Chris