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

    Hi everyone - I have a problem

    Sorry about the generic heading, I forgot to specify it when I was writing the post. : Bryan Marble IEWS BAE Systems
  2. bultimatem

    Hi everyone - I have a problem

    Hi everyone - I have a problem accessing a table in my database from excel. When I run the sub procedure below, I get an error, presumably because I have a space in my table name. Is there any way to "fool" the computer into thinking of the table name as a whole rather than just as...
  3. bultimatem

    populate access across a network

    I have an access database on my company's intranet. I would like to access that database from an excel spreadsheet from any computer on our network. In other words, I want to know if I can use the OpenDatabase method with an IP address or computer name for the server ie...
  4. bultimatem

    link in excel formula

    Just as added info, I need to choose the sheet because the range isn't specific to one sheet. Bryan Marble IEWS BAE Systems
  5. bultimatem

    link in excel formula

    I am having a problem inserting a filepath in a formula. There is some really nasty splitting going on. In VBA I am inserting a formula in a cell in the form: =someStuff...
  6. bultimatem

    linking to range in specific sheet

    I have a sheet that produces copies of itself and therefore, all of the named ranges are also copied. In another sheet I want to access a particular named range, but one in a specific sheet. So for example, if Sheet1 has a range named newRange and so does sheet11, I need a formula that will do...
  7. bultimatem

    Concatenating ranges

    Thanks a lot! Bryan Marble IEWS BAE Systems
  8. bultimatem

    Worksheets

    On Error Resume Next ThisWorkbook.Sheets(&quot;sheet_name&quot;).Activate If Err <> 0 Then MsgBox &quot;Sheet sheet_name does not exist&quot; Exit Sub End If On Error GoTo 0 That should do it! Good Luck, Bryan Marble IEWS BAE Systems
  9. bultimatem

    Concatenating ranges

    I have a named range of rows (say, rows C:G) and I want to take it and add row A to it so that the range now covers rows A,C,D,E,F,G. Any ideas on how to do this in VBA? Thanks, Bryan Marble IEWS BAE Systems
  10. bultimatem

    flagging a sheet

    Alright, I changed the implementation so that each sheet, on activation is given a range with the specified flag name, which works, because I just needed to know if an active sheet was of that type. Thanks for the help Bryan Marble IEWS BAE Systems
  11. bultimatem

    flagging a sheet

    In XL97, I have a workbook that contains a few sheets, and a few charts. In my sheets I have 3 or 4 special sheets and I need to find a way to loop through those sheets only. I'd like to set some sort of a flag to mark those sheets as special. I've tried creating a named range that will only...
  12. bultimatem

    Open Workbook hangs Excel

    I've found that this is actually hanging, not in the open statement but in the first workbook's deactivate activities. Again, it runs through the debugger fine. I've gone through the deactivation routine and put a breakpoint at the very last End Sub before it returns to the code and it's fine...
  13. bultimatem

    Open Workbook hangs Excel

    When I try to open another workbook using VBA (it's not toooo large at 245K) Excel hangs (CPU goes to 100%) and I have to use the task manager to close excel and start over. When I step through the procedure doing the openning with the debugger (which then steps through all of the open events...

Part and Inventory Search

Back
Top