Search results for query: *

Ladies and Gents A Merry Xmas. I have copied data from a pdf and have this type of data in an excel2007 cell: K098768 J7685 I want to leave the cell as K098068 or have the same result in an adjacent cell. I seem to recall a similar problem on your website some years ago, but it involved...

I reformatted the hard drive on my desktop computer with Vista Ultimate and now have a problem accessing the internet from that machine. In Device Manager the Network Adapters (Realtek RTL8101 Family PCI-E Fast Ethernet NIC has a yellow warning on it (other devices SM Bus Controller is showing...

Ladies and Gentlemen I am looking at writing a program to emulate a card shuffling machine. What I know of the machine is that it uses a system whereby the cards are stacked into a slot. There are 53 of these slots. My question is, would it be more efficient to use stacks (clearly designed for...

Ladies and Gentlemen I have a table of 10,000 numbers. I am trying to work out a formula that will look up a table based on the result in the list of numbers. Initially I am looking at the last five results, wanting three occurences but may want to test for 6 or 7 numbers (with three...

Ladies and Gentlemen This is a follow on from my last question, but unlike the last post this gets to the heart of the matter. My apologies for not thinking of this before posting the earlier query. I have found lots of valuable information on arrays and one example that, whilst obvious in how...

Ladies and Gentlemen I have an array of letters, after having set up data on an Excel spreadsheet. Copied the array into VBA as normal and have been able to count the number of times each letter occurs and display this on the spreadsheet. The data looks like this: Letter...

Ladies and Gentlemen I am completing a program in VBA and am wondering if there is a way to solve a problem within the code. This section counts up the number of occurrences of a letter occurring in a range. The problem is the range expands one cell at a time until the count for any letter is...

Ladies and Gents Another problem involving settling a bet. My friend has come up with a scheme for beating a roulette wheel (I tell him every 6 months or so he is mad, he still comes up with ideas!). Anyway, I had set up a spreadsheet where he could feed in the results (generally limited to 300...

Ladies and gentlemen This seems fairly trivial and I apologize for the question if that is the case, but my extensive searching of Micrsoft and other sites has failed to find an answer (there may indeed not be one). I am doing a mail merge with data from Excel and a Word letter. I would like to...

Ladies and Gentlemen I have the following code to do some card shuffling in an existing program (borrowed off the net about 3 years ago). I have had the program running with two decks (104 cards) but the bloody Casino has now gone to 4 decks (208 cards). I thought that's easy just change the...

Ladies and Gentlemen, Hereunder is some code to add a new word doc programmatically. Could someone please advise me how to add a template (in this case a letterhead which is at C:\Documents and Settings\David\My Documents\Standard Documents\Carlton & Partners letterhead 05) instead of a new...

I have an array of 12 numbers say: Cards(14,10,15,11,9,14,7,10,12,8,11,14) I would like to randomize the array Cards. Is there a simple solution or is it like the old pick a number from an array (oops hat),for which there are a myriad of solutions? Thanks for your help David

Ladies and Gentleman I haven't used these inso long I've forgotten many of the manipulation tricks involved so my apologies ahead of time for what appears a simple problem. It is: I have an array of 208 cards which I need to split into 19 arrays (each array should have a minimum of 4 cards)...

I am trying to take data from an excel sheet and add it to a word document. My first approach was to use Word VBA but having spent a week trying to work out the syntax I'm wondering if doing the program from Excel (which I'm at least familiar with) would achieve the same result. Any advice...

I am trying to export customer address data from MYOB Accounts Software into Excel and then import it into a filemaker pro Database. The addresses are coming out of MYOB into excel in a virtually unuseable way. There are column headings: 1) Contact 2) Company Name 3) Phone 4) Address1...

My work computer is networked with two other office pcs. On Tuesday instead of doing a backup first I downloaded the Windows updates approx 20Mb. Some items wouldn't update and minor (or so I thought) errors occurred in the download process. Any way I proceeded to restart and everything appeared...

I'm having a problem with the latest Zone Alarm (ZA - 1012).I'm using IE6.0 and when ZA is set up and you go on the net (dial up) it will go to a web site but not complete loading the site or if it does load ok and you then go to a second site it causes the computer to lock up. This results in...

I have several lists(50 at last count but possibly 80 - 90) of various sizes(some have 120 items, some have 350 items). I am using Excel97 to store the lists on a spreadsheet in columns(ie column A is list 1 etc). I set out hereunder my fruitless attempt at solving this problem: Private Sub...