Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WalterContrata

    precision in C

    Neat! EvLer, If the number is greater than or equal to 1 ( or less than 0.1) how should it be rounded? For example, does 1.12345123451 get rounded to 1.1234512345 (10 digits after decimal) or 1.123451234 (10 significant figures) ?
  2. WalterContrata

    Calculating Derivatives in Access

    PHV, Slick! Wish I had thought of that. Thanks, Walter
  3. WalterContrata

    Calculating Derivatives in Access

    What is a good method of calculating derivatives in Access (or of calculating anything that depends on multiple rows of a table.)? I have a table of phase ([φ]) versus frequency (f), and I need to calculate d[φ]/df, the group delay. Here is a sample: ID f [φ] 11 3.045...
  4. WalterContrata

    Pie chart in excel (with conditions)

    Irin, Is it that you want the labels of the split out pie chart to show percentages of the split out population? It may be possible to do that, but I do not see how. Would it be an acceptable work-around to make a second pie chart of the split-out data only? Best Regards, Walter
  5. WalterContrata

    Pie chart in excel (with conditions)

    Irin, I think that Excel will split out any sectors you like to make a second pie chart. From your last post, you have a table like OnDrugs1 20 OnDrugs2 10 OnDrugs3 3 NotOnDrugs 67 (In this case, the sum is 100, but it need not be.) In Excel 2000, it works...
  6. WalterContrata

    Pie chart in excel (with conditions)

    Irin, Sorry not to respond sooner. Work has been very busy. For the 1st part, can you see a way to summarize the data again, using the COUNTIF function? This time the range would be the indicator column, and the condition would be "0" for one row and "1" for the other. For the second part, I...
  7. WalterContrata

    Pie chart in excel (with conditions)

    Hey Irin, Check out how the COUNTIF function works. It has two arguments. The first argument is a range of cells, and the second argument is a value or a condition. The function counts the number of cells in the range that match the condition. In our case, the range is the helper column...
  8. WalterContrata

    Pie chart in excel (with conditions)

    Irin, An example is at http://www.geocities.com/straight_manus/TempOfficeFiles/Pie.zip or http://www.geocities.com/straight_manus/TempOfficeFiles/Pie.zip The first sheet has fake data on it, and the second has a summary and a pie chart. Hope this helps, Walter WC
  9. WalterContrata

    Pie chart in excel (with conditions)

    Hello Irin, By "summary table", I meant a table that summarizes the data; it is not a special feature of Excel. You can put it on another sheet, if that is convenient. You can even put it in another workbook, although I don't recommend it! I would use 2 columns for the summary table. In the...
  10. WalterContrata

    Need script to detect broken Hyperlinks in Excel

    jryan3, You can use for ... next to step through all of the hyperlinks in the worksheet. Option Explicit Sub CheckHyperlinks() Dim oWB As Workbook Set oWB = ActiveWorkbook Dim oFS As FileSystemObject Set oFS = New FileSystemObject Dim oSh As Worksheet Dim...
  11. WalterContrata

    Copying 2 worksheets to a new workbook, and saving

    t16turbo, Sorry, I forgot clean-up again. ... Set oOldSh = Nothing Set oOldWorkbook = Nothing Set oNewSh = Nothing Set oNewWorkBook = Nothing End Sub Best Regards, Walter
  12. WalterContrata

    Copying 2 worksheets to a new workbook, and saving

    Hello t16turbo, I would try recording the act of copying, pasting, and saving with the macro recorder. The resulting code could be modified to fit your application, maybe like the following. Option Explicit Sub SaveWorkSheets() Dim oOldWorkbook As Workbook Set oOldWorkbook =...
  13. WalterContrata

    Excel keeps crashing when spreadsheet is used

    t16turbo, I'm just guessing here, but I've had various trouble with Excel after workbooks became to large: too much data, too many charts, too many formulae or user defined functions. Recently some discussion of this occured in thread68-947957 If you like, you can have the macro delete itself...
  14. WalterContrata

    Excel VBA printing query

    As for printing, why not use the VBA macro recorder to make code, and then modify it? Best Regards, Walter
  15. WalterContrata

    Excel VBA printing query

    vbab, Good start. Now to follow Uncle Mike's advice, Option Explicit Sub LotCalc() Dim myVal As Long Dim i As Long Dim iRemainder As Long Dim nLot As Long 'Const nMin As Long = 0 'Const nMax As Long = 9999 myVal = InputBox("Input a number between 0 and 50,000") Select Case myVal...
  16. WalterContrata

    compare text

    ...also WinDiff may be useful, if you have it WC
  17. WalterContrata

    How to remove a radio btn from an Excel sheet.

    Goot, The method I described works if the button was created with the Control Toolbox Toolbar, but not if it was created with the Forms Toolbar. In the latter case, get the Select Objects tool from the Drawing Objects Toolbar, select the buttons by dragging a rectangle over them, and delete...
  18. WalterContrata

    media player on worksheet

    Maybe this is useful. If you manually embed the Media Player in a worksheet, then 1. Get into design mode. 2. Select the embedded Media Player. 3. Display its Properties. 4. One of the properties is named something like "Property Page". Click on the "..." next to this property. A form opens...
  19. WalterContrata

    media player on worksheet

    You can play something from the code using oWmp.URL = "C:\Windows\Media\chimes.wav" but replace my "chimes" path with the appropriate path or URL for what you want to play. Now trying to figure out how to activate the buttons for manual play. As a workaround, you could put your own buttons...
  20. WalterContrata

    Excel popup

    Very glad it worked! Walter

Part and Inventory Search

Back
Top