Threads Replies Last Post 125 Pages: <<  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  >>   export from Access to Excel has created problems with I am a new user with vision impairment, so it is extremely likely that I missed the help that has already been offered. For that I apologize and thank you for your input. I was working on a database in Access, but was having a problem because of my vision. It was suggested that I would have better luck working in Excel and since I have worked with it before I decided to try. I expo... 4 19.07.2006 00:05:01 Counting and colour coding ranges of occurances a have a list of employee ID numbers and need to count how many times they occur withing certain ranges. For example: if one occurs between 5-10 times I want all occurances highlighted in yellow, if it occurs between 10-15 times I want all occurances highlighted in blue, and if it occurs more than 15 times I want all occurances highlighted in red. Any suggestions?... 5 18.07.2006 23:38:39 Comments. I have two workbooks which have comments on a few of their cells. As is appropriate, when I point to each of those cells the comments they contain appear alongside. But often (not always), after I have saved the workbook then opened it up again on my return, I find that none of my comments appears when I point at it. Comments can be made visible again by selecting any cell... 7 18.07.2006 22:17:48 introductions I hope this is the place to introduce myself. I am vircats. Hi to everybody. I am glad to meet you. I am new here, still don't know my way around, sorry. -- vircats... 3 18.07.2006 21:45:18 An Operational Problem Using Excel 2002, Excel will not maintain toolbar customizations and will also not close properly. 1. If a button is added to a toolbar, it functions properly, but when Excel is closed and then relaunched, the new button has vanished. Found and deleted Excel10.xlb to no avail. 2. When we attempt to close Excel, using the upper X in the right corner, or from File | Exit the opened fil... 5 18.07.2006 20:38:04 Where's the converter to open Quattro Pro 7.0 .wb3 in Excel 2003? I've installed every option on my Office 2003 standard CD, loaded the Office2003 Converter Pack (oconvpck.exe from Article ID : 212265 ) and updated to the latest Office 2003 service pack. Still can't open Quattro Pro 7.0 .wb3 worksheets in Excel 2003. Where's the missing converter?... 1 18.07.2006 20:34:02 loading data from access in vba How can I load a database from an Access Application in VBA? I tried with GetObject function, but I don't know how to get the database. Remy... 3 18.07.2006 17:35:01 Stock Inventory Dear Sir, Is it possible in Excel that by just encoding the data in receive and issue voucher it will automatically post in STOCK CARD worksheet and then automatically update in the MATERIALS INVENTORY worksheet: See my sample below. Thanks for help RECEIVE VOUCHER DATE VOUCHER# CODE# DESCRIPTION QTY 6-Jul 1550 987 Sticker 200... 3 18.07.2006 16:56:01 Create a numerical sequence in a column: From 1 to .... I want to automatically generate a sequence of numbers from 1 to....X without typing them all. How?... 4 18.07.2006 16:46:01 How can I get auto sum of column when new figures are added I have put in formula to total a column of figures, it has empty cells for new items to be entered as they occur. It used to total in new items automatically, now it will not total in new items. It is a Monthly spreadsheet. I used" create a copy "to make blank copies to use for following months. I made changes to existing sheets as I needed to by using CTRL key and clicked on each future... 3 18.07.2006 16:21:06 make the cell hyperlink to any name within it is it possible to make the hyperlink relevent to the text within a cell. i.e if the cell said paul it would email to pauls email address or if the same cell said mark it would email to marks email address and so on. any ideas regards Hoyt... 3 18.07.2006 14:23:22 how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel I have a spreadsheet that the data, the date was input in Excel 2003 as mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to "dd:mm:yyyy"(31:12:2004)? I tried to change date format from "Format Cells----choose "date" or "custom" and tried different options, but they wouldnt change the data already in the cells. I have a spreadsheet that Microsoft is requesting inform... 5 18.07.2006 12:57:02 Getting Sheets Copied From One Workbook to Another Without ....? Hello, I have a situation where I want to move 3 sheets from one workbook to another. The Problem is that the sheets appears to carry their File Path with them creating a Problem for my formulas within the destination sheet.. Is there a way to keep the Formulas in tact to represent the destination sheet? The Workbooks have the same Data, but 3 sheets from the source workbook need to be ins... 7 18.07.2006 03:39:01 Re: Hyperlinks Not Instant In 2007 ?? Just heard from MS that they were 'playing' with this in the Beta2 timeframe to try and come up with a more satisfactory conclusion for all, but the next public release will return H/Ls back to the old instant functionality -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Nick Hodge" <nick_hodgeTAKETHISO... 3 17.07.2006 23:33:24 Help if possible. Sorry if this is posted in the wrong fourm but heres what I am trying to do: I need to set up a spreadsheet, i've got the basics down (I think) but am having some problems what i am trying to do is: I need to track how long a for intance a trailer has been in my yard so I set up a basic spread sheet with dates say in A1 I have the date the trailer comes in say 7/15/06 and then I need a aut... 7 17.07.2006 21:05:20 csv file import I have tried and succeeded in importing a .csv file into excel. This file has numerical values. After converting the file, I try and add a few of the numbers in one of the colunms and my answer is always #VALUE; which tells me those numbers are being read as values and not numbers. HOW do I import the file or what changes do I need to make in order to get those numbers to be seen as Num... 7 17.07.2006 16:07:02 save .xls w/o the formulas just the numbers i have a .xls file that has been layed out very nicely (and i wasnt supposed to change it), but the silly bugger who designed it, didnt put it the formulas to relate various cells where totaling stuff. i thought i had seen someway to save the .xls with only the 'results' of the calculations rather than w/ all the formulas in it i put in. was that a figment of my imagination? thanks... 2 17.07.2006 15:34:26 How Print In a Macro How do you print a string in a macro? For instance: Print "Hi there" So "Hi there" goes to the printer. I tried all kinds of things but it keeps saying someting about an object. I'm trying to print a string variable. Thanks John... 3 17.07.2006 15:31:47 how to design a form Hi I am new to excel and would like to design a form, that keeeps track of the construction maintenance jobs we have in then when they have been completed to produce an invoice saving all imfo in relative sheets. i.e. work in, work completed, work invoiced, outstanding invoices, invoices paid etc etc with data fields to be filled out by user then all this data to be automatically a... 2 17.07.2006 11:47:15 Vlookup problem with Access Query import into Excel 2000 I have exported from an Order Entry program to comma delimited text file customer purchases. The file has more entries than Excel can handle on one worksheet. So, I imported the file data into Access (107,000+entries). I then used Excel's "Query Database" feature to import customer level purchases into 4 worksheets. The Order Entry program didn't export customer names, only customer numb... 5 17.07.2006 02:31:01 Modifying a "Floating"(?) Cell Help! I am a novice trying to modify a worksheet that someone else created. I am baffled by something that I can only describe as a "floating" cell. Essentially, it is a cell that has several different assigned values that change when it is clicked. For instance, "1" appears first. Then when it is clicked, "2" appears. The when it is clicked again, "3" appears. And then when it is clicked a... 7 16.07.2006 21:50:44 String variables I dim Warning(100) as string Then I do the following: Warning(1) = Cells(1, 3) + " " + Cells(3, 3) + " " + "Assessments" + "= " + Cells(2, 13) + "," + Cells(2, 16) Cells (1,3) is a string Cells(3,3) is a social security number "Assessments" I mean the word Assessments Cells(2,13) and Cells(2,16) are numbers I want Warning(1) to = "Joe Blow 123-45-6789 Assessments 4,5" I get... 4 16.07.2006 20:08:48 VBA password protect Hi I have got this macro to run when opening. All works, but when I password protect the sheet, and then close and open i get a run error. I am not fluent with VBA and get by by recording and pasting other work off the treads Can anyone let me have the VBA code for protect / unprotect. and where it should be entered in the code below . The password is "template" thanks in advance ... 2 16.07.2006 18:23:56 conditional format problem I have two conditions 1. m2>0 2. =M2-P2<3 It only pays attention to the 2nd condition. As if its and "or" rather than an "and". I'm using conditional formating off the toolbar. I want to color the cell red if both conditions are met. It works fine if m2> 0 but it also works if m2=0. Why? John... 5 16.07.2006 16:23:26 How can I recover a deleted Excel workbook? I've spent a long time making a new spread sheet in a new workbook and just deleated it. Is ther any way to recover my work or must I start over?... 4 16.07.2006 16:08:10 125 Pages: <<  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  >>