Search results for query: *

Hi, I'm about to start a project and I'm wondering if Access is the right software to use. I would like to create a table containing information on clients. This table must be consultable and appendable. Clients can be deleted added and modified by the use of forms. I want to be able to install...

Hi, Using Excel 2000. I have a worksheet that is linked to another worksheet in another workbook. I would like to be able to copy the data in the workbook without the links to the other worksheet for backup purposes. I need to keep the formats though. In otherwords I need to copy everything...

Hi, I have a workbook that gets data from another workbook. The linked cells contain full paths to the other workbook. These two workbooks will always be inside the same folder and this folder may be moved arround therefor breaking the links. I would like to link these workbooks more...

Hi, Using Excel 2000 I extract data from one Excel workbook to another. The data is pasted inside a worksheet surronded by borders to make it more readable. I want the user to be able to perform cut and copy actions inside the borders without errasing them them. In otherwords i would like the...

Hi, Using Excel 2000 I just want to know if it's possible to combine a string with the result of a function inside a cell? Here's an example of the result I want : +- Result of a simple calculation Hope this is clear and thx in advance

Excel 2000 I have a button in an Excel worksheet that extracts data to another workbook. This workbook is created everytime the button is clicked so I have to set the cell formats manually through VBA. Here's my problem. If I have a digit like this : 23.3 (One decimal after the point) I use...

Hi. I have a worksheet containing colums of data. I want to copy data from one worksheet to another in order to create a report. One of the columns I wish to copy contains dates. The other contains data. What I want to do is copy the data column so that only the non blanks are copied. I want to...

Hey, I'm using Excel 2000 VBA I do a copy from one sheet to another. At the end of macro execution I still have a blue highlighted area where the copy was performed. Is there a way to unselect the copy area after macro execuiton?? I tried application.cutcopymode = false and I want to avoid...

Hi, I have a worksheet that extracts data from another worksheet. Upon extraction two fields from the original file are combined or added together to form one field. The way I do this is I copy the contents of the original to the new file once copied i then do the sum of the two fields to be...

Hi, I want to perform calculations on data based on the contents of two fields. LOWER UPPER OCCUR. IRON 65.299 99999.990 20 SILICA 2.849 3.651 20 MANGA 0.999 1.401 20 DEMI 0.000 23.001 13 IDEAL 72.999 99999.990 13 -1/4" 0.000 0.501 23...

Hi, I have an operation that takes time to complete. I would like to insert a Progress bar inside my code. Can anybody tell me what I need to know to implement this. Thx

Hey, I have a database inside an excel 2000 worksheet. I want to extract data from a certain month into another sheet. I use the property selection.column to return the selected column. I would like to recieve a letter instead of a number. Instead of returning 2 well I would like to get B. At...

Ok, I'm aware that there's probably not many people here that use a franch keyboard but here's the question anyway. Using windows 98. The keyboard doesn't write accents anymore. It used to work fine but now some of the accents do not work anymore. This isn't a Keyboard issue because I tried...

Hi, I'm using Word 2000. I would like to create a table of contents with links. Does anybody know how to make it so that the user will click on a link and word will go to the appropriate locaiton? Thx in advance

Hi, I'm working on an Excel 2000 applicaiton. I have made a few modifications on it and for some reason it craches Excel on startup now. I would like to deactivate the startup macros so that I could at least visualise the code but I made myself a digital signature and trusted my myself so now...

Hi, I'm working with Excel 2000 VBA I have a sub which initialises many doubles. All it does is set 10 variables to 0. I was wondering if it was possible to initialise them to 0 in one or two lines. I know that in c++ you could do something like this : temp = temp2 = temp3 = 0 This would...

Hi, I have a worksheet which calls upon another worksheet to extract data. This worksheet is fairly large and contains macros at startup. I want to know if its possible to disable marcos at startup so that I could open and close the file quicker. Thx in advance

Hi, using excel 2000 VBA. I have this string : 2003071-SI I would like to isolate 2003071 The problem is that this string could vary. It coulb be the following : 03071-SI so what I would like to do is extract the "-SI" and store the remainder of the string. Hope this is clear...

Is it possible to verify if a directory exists using Excel VBA. If it doesn't I would like to create it in oreder to save a file inside it. Is this possible??? Thx

Hi, I'm creating an Excel application which calls upon a userform. On this form there are four textboxes. Three of the four textboxes will contain manual inputs. The fourth textbox should contain the sum of the other three textboxes. On the afterupdate event of my three textboxes i do a sum of...