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!

  • Congratulations strongm 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: brans
  • Order by date
  1. brans

    Plugins "manager" for IE??

    Thanks, but that doesn't show things like flash or quicktime or traditional plugins. I need the versions for the traditional stuff.
  2. brans

    Plugins "manager" for IE??

    I am wondering if there is a plugin manager for IE (any version). I found one for Netscape, but I need to know which versions of plugins I have for IE. I have a website that runs various flash slideshows depending on the version and I need to make sure I have a copy of each version of flash...
  3. brans

    TextWidth (or equivalent) in VBA

    I just reread my post above and wanted to make sure noone thinks that I have figured it out yet. I know what I need, but definitely not how to go about getting it.
  4. brans

    VBA Excel hangs up when closing with macro

    Hi Jan, Have you tried Activeworkbook.close true Brans
  5. brans

    TextWidth (or equivalent) in VBA

    The problem is the number of characters doesn't really determine how long the name will be. It is the whole "m and i" problem, with the count they are seen as the same, whereas they are definitely different sizes and wordart magnifies this problem. I guess I need the point count or...
  6. brans

    TextWidth (or equivalent) in VBA

    I created a seating chart in excel that has a round table in the center and seats along either side. The problem was it has to be a variable number of chairs around the table and on each side, with the chairs, and name associated with the chair, correctly spaced and angled, automatically drawn...
  7. brans

    controlling wordart in excel using VBA

    Thanks, that gives me some ideas and definitely helps on the count. Unfortunately we spent most of the morning doing trig calculations UGH! But they seem to be working. Thanks again!
  8. brans

    controlling wordart in excel using VBA

    HELP! I have to make a circle with a variable number of wordart shapes around it (depending on the user). I need to be able to adjust the spacing and angle of the wordart shapes as well as do a count on the shapes using VBA. I can change the size and rotation, but only using a static number...
  9. brans

    WinME Photo Editor Problem

    Just thought I'd mention, Microsoft Photo Editor is included with Office, though not in a standard installation. In 2000 it's under office tools.
  10. brans

    If statement based on a Find in excel...

    Thank you, thank you, thank you. That will work perfectly. It will also help on a similar project I am doing.
  11. brans

    If statement based on a Find in excel...

    Sorry, The workbook, sheet, and column remain constant, but the row changes. I am doing a search in Column A on "branch", when it is found, a marker is setup in AY, all rows above it are deleted, and code is activated based on that marker. Then branch is found again so the process...
  12. brans

    If statement based on a find (search) in Excel...

    Can you do an If statement in Excel based on a Search finding certain criteria? I want it to do one thing if A1 contains Branch and another thing if A1 contains Region... Range("A1").Select Cells.Find(What:="branch", After:=Activecell, LookIn:=xlValues, LookAt:=xlPart...
  13. brans

    If statement based on a Find in excel...

    Can you do an If statement in Excel based on a Search finding certain criteria? I want it to do one thing if A1 contains Branch and another thing if A1 contains Region... Range("A1").Select Cells.Find(What:="branch", After:=Activecell, LookIn:=xlValues, LookAt:=xlPart...
  14. brans

    Copying an Access recordset into Excel

    I am trying to copy an access recordset using a macro in excel. This works on some machines and on others it gives a runtime error. We thought the problem was an Office 2K compatability issue, but we recently ran across an Office 97 machine that has the same issue. Here is the code: Sub...
  15. brans

    Count Rows based on a Find...

    Thanks for the help! :) JVFriederick, I'll definitely keep that in mind. The activecell.row worked, THANKS! I had tried all different versions of that except that one, DOH.
  16. brans

    Count Rows based on a Find...

    I am writing code to format a spreadsheet based on subtotals. The problem is that I need to allow the user a variable number of rows based on where their total is. (i.e. They add and delete rows often) I want to count the number of rows above the word Total. I get stuck on actually counting...
  17. brans

    relationships between multiple tables

    I've just started using access and the relationships still confuse me. I'm sure this is very basic, but I can't seem to understand the way they will actually link up. I am trying to set up a database that has a table for employee information, a table for uniform information, and a table that...

Part and Inventory Search

Back
Top