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 Rhinorhino 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. behbeh

    Excel - Prevent User from Deleting a Worksheet

    Thanks, cLFlaVA!! I tried it programmatically in my module(s) and it worked great. I do have to keep toggling the Protect off and on throughout my app (depending on what I'm doing) but it works great. Thanks! [thumbsup2]
  2. behbeh

    Excel - Prevent User from Deleting a Worksheet

    Hello! Is there any way I can capture when a user tries to delete a specific worksheet and cancel the delete or display a message stating they cannot delete a specific worksheet? Thanks!
  3. behbeh

    Excel - Detecting user is in Edit Mode

    Hi Loomah (and ETID), I could not get it to work correctly; not saying it doesn't work, I just couldn't get it to work in my project. The xls app I'm working on is bursting at 4MB (lots of scope creep) and Excel is being totally whipped already with major functionality squished into the vba app...
  4. behbeh

    Excel - Detecting user is in Edit Mode

    Hello! Is there any way to detect if the user is in Edit Mode in Excel (double-click a cell and the cursor is flashing within it)? I need to either disable my custom CommandBar buttons or display a message when this happens. Currently, if the user is in Edit MOde and goes to click a button on...
  5. behbeh

    Excel - Formula Bar

    Thanks for the link, Loomah!!! Happy Friday to you as well! Also, if a man says something and there are no women there to hear him, he is still wrong, unless he is a member of this forum! :-{}
  6. behbeh

    Excel - Formula Bar

    Well,I've been playing around with this and found that Excel disables the VB/VBA CommandBar buttons (as well as a few other CommandBars)when the cursor is in the Formula Bar. Unfortunately, hiding the Formula Bar is not an option. :( The problem is that my custom commandbar macros do not run...
  7. behbeh

    Excel - Formula Bar

    Does anyone know how to programmatically detect when Excel's Formula Bar has focus? I need to disable a custom CommandBar when the the cursor is in the Formula Bar. Thanks!
  8. behbeh

    Excel - Prevent Control Toolbox from Displaying

    Hello! I am working on an Excel application with a form for user input. I found that when I am on the last control on the form (a cancel button) and hit the Up arrow on the keyboard, the VB Control Toolbox displays. How can I catch this and prevent the toolbox from displaying? Thank you in...
  9. behbeh

    RegEx Max Limit

    whoops...I meant 35,000 characters!
  10. behbeh

    RegEx Max Limit

    When all is said and done, the length of the string would be around 3,500 characters. I guess I'm not so concerned at this point about the memory being hosed (this would have to be tested), I just want to make sure there isn't a MAX limit to the length of a regex. If there is no limit to the...
  11. behbeh

    RegEx Max Limit

    I have one regex I would need to have a little over 1,800 words listed in the alternation part. This would be sucked out of a database table as a regex string and then used in the front-end of the app.
  12. behbeh

    RegEx Max Limit

    Hello! Does anyone know if there is a maximum number or words/strings you can use in regex alternations? (Ex: OH | Ohio | PA | Pennsylvania | RI | Rhode Island |...) I know regex's are fast but if there is a limit or if hundreds of words in the alternation would slow it down to a crawl, I would...
  13. behbeh

    RegEx Max Limit

    Hello! Does anyone know if there is a maximum number or words/strings you can use in regex alternations? (Ex: OH | Ohio | PA | Pennsylvania | RI | Rhode Island |...) I know regex's are fast but if there is a limit or if hundreds of words in the alternation would slow it down to a crawl, I would...
  14. behbeh

    Finding where a table starts in a Word doc

    Hey thanks Tony! I didn't know about "Sent.Information(wdWithinTable)". I'll check it out. Thanks for your help! :) BehBeh
  15. behbeh

    Finding where a table starts in a Word doc

    Hi Tony, Programatically, I need to open a document and extract information (in sentence order). I have to bust the free-form text into sentences and throw those into an array for text. I also have to grab the info in the table(s) and throw that info into an array for tables...don't ask...
  16. behbeh

    Finding where a table starts in a Word doc

    Cool...I'll checkout Bookmarks (I haven't used those before). If I can scan the doc, insert bookmarks where all of the tables begin (if there are any in-between text paragraphs) and check for bookmarks as I go through the doc, that will probably work. Thanks...I'll give it a shot! :)
  17. behbeh

    Finding where a table starts in a Word doc

    Hello! Does anyone know if you can grab the Line Number on a page where a table starts in MS Word programatically?
  18. behbeh

    Detect Installed Applications

    I need to detect whether or not several applications are installed on a local PC. After researching the subject, I found a few API calls (GetFileVersionInfoSize and GetFileVersionInfo) that will give info if it finds the application in the DEFAULT path for that application (which has to be...
  19. behbeh

    Parameter StoredProc and Return Value

    Hey! Thanks for your suggestions and I did kick myself for the spaces. Unfortunately after making the necessary changes it still doesn't work. [sadeyes] This is just too freaky. It's one of those things you encounter as a programmer and due to time constraints, just bow out, accept the defeat...
  20. behbeh

    Parameter StoredProc and Return Value

    Here it is: CREATE PROCEDURE dbo.usp_parm_CheckIfEntityExists ( @strCompany AS VARCHAR(100), @strStreet1 AS VARCHAR(100), @strCity AS VARCHAR(100), @strState AS CHAR(2) ) AS DECLARE @intResponseID AS INTEGER DECLARE @intEntityID AS INTEGER DECLARE @strYear AS CHAR(4) BEGIN SET...

Part and Inventory Search

Back
Top