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...
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...
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.