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: *

  • Users: damrus
  • Content: Threads
  • Order by date
  1. damrus

    splitting values into classes

    Hi, I would like to update my dtb (in Access) on class information. The database looks like that: nr_sim Euler_id EL_Gross class 3172 15013729 13452345 3167 15297205 234514 3169 96873838 1345 3173 70984066 25134 3170 70584807 123 3168 70816660 235134 3171 70282458 1452145 3173 70941751...
  2. damrus

    compact database

    Hoping that someone help me... I would like to compact database in the middle of running a code in VBA. Is it possible to compact dtb using VBA under the same Access database? For example: sub t() For i = 1 To 999 DoCmd.RunSQL "blabla" Next ' ! here I would like to put a code to compact...
  3. damrus

    problem with hidden worksheet

    Hi, I have problem with making sheets visible. I can't see them in Excel, but in VBAProject there are exist. When I try to change status for xlsheetvisible (in properties) I get message: Setting properties is not possible...
  4. damrus

    cutting a piece of formula

    How to cut a formula from cell? I mean not whole formula, but piece of formula. For example I have formula like this: =(B17-0,5*B21-0,5*B23)/(Model!M11*60%) and I want automatically get a piece formula until the "/" sign (but without this sign). So the result should be: =(B17-0,5*B21-0,5*B23)
  5. damrus

    list box - multi option

    Hi, I'd like to create list box and use multi option, which is only useful when you are using VBA procedute. How to use this procedure? Here you are link describing it: http://support.microsoft.com/kb/291073/ (see 'Note' about VBA) Regards
  6. damrus

    ExApp.Workbooks.Open not working

    hi, Why does this code work in Excel 2000 and doesn't work in Excel 2007? VBA shows runtime error '1004' at line: Set Wb = ExApp.Workbooks.Open(nextfile, 0) Sub h() directory = ThisWorkbook.Path & "\" Dim ExApp As Excel.Application Dim Wb As Workbook Dim nextfile As String Dim myfile As...
  7. damrus

    trimming all selected cells

    Hello! How to trim each cell in chosen selection? I mean... how to use this code: Cells(10, 1) = Trim(Cells(10, 1)) in each cell of selection? Regards
  8. damrus

    getting datas of each workbooks in directory

    Hi! I need to get some datas from each workbooks in directory. How to do it? For example: I need to get value from cell "A1" of each workbooks in directory. Regards

Part and Inventory Search

Back
Top