Search results for query: *

thx for the reply's guys. jrbarnett your saying that I should create the database and table in access and access it with a visual basic program?

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...

Thx Dale that did the trick

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...

Thx for the responses guys. I sent a copy of my application to Dale. Hope he can help me out

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...

This is the code that retrieves the data from another worksheet. The sub Combine data performs the sum of the two column and does the cut copy. Private Sub getDataBtn_Click() Dim fullReportBook As String Dim sizingPath As String Dim sizingBookName As String Dim fileNotFoundMsg...

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...

hey NeilRP Thx for the reply. Your on the right track but i want to compare only the non blank cells to the interval.

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...

Hey guys thx for the quick responses. Is there a way to create the progressbar without using as userform? Thx

Hey John, I was sort of looking for an already programmed progress bar. Something I could maybe activate inside the references and use. I have a button that the user clicks on to perform a certain operation. This operation takes arround 15 seconds. I would like to incorporate a progress bar...

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...