Search results for query: *

Hi, I'm currently wondering about how to solve a current task of mine. I am going to produce a 'handbook' on how to perform periodical reporting on various issues. There is a total of app. 8-10 different reporting work-flows, each of which will have an underlying work flow as well - so that if...

Hi Glenn, Thank you for a fast answer : ) I tried both options, and I also find that SUMPRODUCT is well suited and works fine. However, I have to use ';' instead of ',' inside the array and between the array and the 'search in field'. Just for future reference; what does "--NOT" mean? Br Bo

Hi all, I'm trying to look through multiple values in a cell and find out if the cell contains one of more values (OR): Cell to search (example - cell A1): R10 R40 R44 R56 (text value) Search function (doesn't work!): =IF(ISERROR(SEARCH("R10" OR "R30" OR "R88");"no match";"match ok")) My...

Hi WinblowsME, Thank you for the subroutine which I'm already using : ) /Bo

Hi, I have an xls spreadsheet that contains 7 columns of which 2 contains up to 8-10 comma-sep. values in each cell. The data needs to be imported into an Oracle database. Before I can do that, I need to split the multiple values into new rows, in which the values in all other columns are...

Thank you - I'll look into that possibility : ) BR Bo

Oh yeah - now that I'm at it, one more question down the same alley: Would it be possible to add an event posted on an intrawebsite (again using ASP) to an Outlook calender? (E.g. with a 'add to my calender' link). Br Bo

Hello, I am currently planning a small group-schedule area on an existing ASP-based intrawebpage and would like to retreive free/busy information from Outlook to display on that íntrawebpage. Would that be possible at all - or would it raise all kinds of access / security / exchange etc...

First of all, thank you all - thanks to your help, I managed to get my PC up and running in one day after my first post. It turned out that in order to use a floppy on my new PC, I had to get hold of a 'slim connector FDD cable'. This was nowhere to be found in any of the computer shops that I...

Hello, I'm trying to connect an IDE hard disk and a DVD RAM drive to the same IDE-channel on my PC. However, when started up, my PC (XP Pro) is unable to recognize my hard disk. I think that I may have configured the drives wrongfully; right now I have the hard drive as master and the DVD as...

Thank you very much for a swift answer - and you were right (a bit embarrasing really ; ) The IDE-cable needed a 180 deg turn. Shuttle arranged it in a way that you actually need to apply a little violence to turn the cable the right way. About the S-ATA driver, would it be possible to...

Hi, Just a couple of days ago, I bought a brand new Shuttle SB86i barebone PC plus an Intel P4 processor. The rest of the necessary HW, I stripped from my old PC (DDR, optical + S-ATA drive). The optical drive is now connected to the IDE cable (tried both slave and master) and the S-ATA disk...

Hi, I use Photoshop a lot for slicing up images for web pages. However, as I prefer Corel Draw for mocking up / designing the web page images that I later slice up in Photoshop, it can be quite a pain to slice up first 'out' images from one graphic file and the open another graphic file to...

Hello, In my company (like in so many others?!), we use an Excel spreadsheet to register hours consumed at various tasks. Now, people tend to forget to register hours on a daily basis, for which reason too much time and effort is laid into 'reconstructing' days and activities in the past when...

Well as I'm getting desperate - a bit more info (I'm only a few hours away from changing to PHP and quitting ASP for good ...): What localhost tells me, is that localstart.asp cannot assign the requested class (line 46 in localstart.asp). I've inspected the system log, and the only errors I...

Hi, Until recently, my IIS / Win XP Pro was working just fine, crunching all my ASP pages as it was supposed to. But - recently, I decided to try and install EasyPHP on my PC. EasyPHP works, but now IIS stopped displaying my pages?! When I try to connect to localhost or try to view an...

Hi, This function appears to be just what I need to use for expanding and collapsing grouped rows in my Excel sheet via VBA. However, inexperienced as I am in using VBA in Excel, could anyone provide me with an example of how to actually use this function? Best regards and thanks in advance, B...

Hi all, I'm quite new to ASP and databases, but need to build a simple CMS to manage content on a website. I'd like to stick to ASP 3.0 and MS Access. I could work my way through my 1200-pages Wrox ASP book, but I don't really have the time to do that right now ... I've looked everywhere for a...

Hello everyone. Until recently, I was running XP Pro on my Athlon 1800+ / 256Mb DDR without any major problems (SCSI master / IDE slave). A few days ago, I began having problems; the machine was becoming increasingly slow and finally started crashing. I chose to re-partition and format...