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 derfloh 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: bdmangum
  • Content: Threads
  • Order by date
  1. bdmangum

    Copy worksheet from one instance of Excel to another

    I know that typical copy methods will fail since I'm running two instances of Excel. The problem is that I have to run two seperate applications of Excel, however I need to copy a worksheet from one instance to the other. One of the applications is running a database I built for some people. It...
  2. bdmangum

    Write Data to Website Form using VBA

    I have website which has a textbox I would like populate and then a button I would like to click once the textbox is populated. I can get the code to click the button, but I can't seem to populate the textbox. I can read the value of the textbox, but I am unable to write to it. I'm guessing...
  3. bdmangum

    Require Username/Password on Excel Workbook Open

    I have a workbook to which I would like to add user and password control. I want the user to login with their network id and password. Currently I have the code below which grabs the user's profile from the active directory. I can't seem to find a method for matching the password though. Anyone...
  4. bdmangum

    Form Listbox Height Not Setting

    On a form i'm creating I'm attempting to set the height of a listbox based upon the number of items entered into the listbox. The listbox is added dynamically at runtime via code and is called ListAdd. I have a variable called ListHeight which contains the total height needed for the listbox...
  5. bdmangum

    Redirect Workbook Open

    I have a workbook which needs to run in an instance of Excel by itself. The workbook runs entirely based upon forms with the application hidden throughout most of the functions of the workbook, thus my need for it to run in a seperate instance of Excel. I've made it so the workbook always...
  6. bdmangum

    Programmatically Add UserForm in Excel 2003

    For a project of mine it would be greatly beneficial to create a userform programmatically. I've found some exmaple on the web, but none of them work on my computer. As far as I can tell all the examples were written based in office 2000. I need mine to work with office 2003. Below are some of...
  7. bdmangum

    Prevent Any Workbook from Opening in Current Excel Application

    All, For a workbook I created it is important that it is the only workbook loaded in a single instance of Excel. i have already coded it so the workbook will always load in a new application of Excel. I'm now trying to prevent another workbook from being opened in that instance of Excel. The...
  8. bdmangum

    PowerPoint Presentation in Excel UserForm

    I'm attempting to display a slideshow within an excel user form. I grabbed some old VB6 code off the web and have been attempting to modify it to work. I can get the slideshow to run in a seperate window, but I can't get it to run in the frame on my userform. Currently when the code hits the...
  9. bdmangum

    Check if Network Shared Excel Workbook is Open

    I have an Excel workbook I built which users in my department use as a database. The workbook resides in a network folder. I built an executable which launches the workbook. The executable is simply a converted batch file which calls a vbscript file. The vbscript file is what actually loads...
  10. bdmangum

    Display VBA UserForm Using VBScript

    I'm attempting to load a VBA userform via VBScript. However, I'm not certain of a method which will work. Once the form loads the user will select some options with the result of some variables needing to be outputted to the VBScript in order to determine the next path in the code. Does anyone...
  11. bdmangum

    Layered User Forms

    Howdy all, Does anyone know of a way to have multiple user forms loaded simultaneously and alternate control between them? I have a file where one form is loaded from another form, however the first form needs to stay visible and possibly active. Is there a way to alternate the order of the...
  12. bdmangum

    Word Descrambler

    Hey guys, The other day I was playing around and thought it might be fun to try and build a word descrambler in Excel using VBA. Most places online tend to use C++ or some scripting language to run this sort of code. My thought was to store the list of possible words in a spreadsheet. Below...
  13. bdmangum

    Track Last Several User to Open a File

    Howdy all! I'm attempting to write a code which will be able to load a file and tell me who were the last several users to open the file. There isn't really any restriction on the type of file, as I will need to check a wide variety of files which currently reside in a particular folder. The...
  14. bdmangum

    Automate Import of Digital Certificate

    I'm currently in the process of deploying an office-wide database. I already have a digital certificate applied to the file, which by the way was created in Excel 2003. I'm looking for the most efficient way to automatically trust the digital certificate assosciated with the Excel file. I was...
  15. bdmangum

    Unpack tar file using VBA

    A new project I've been assigned to requires me to extract a single file from a tar file and then run some test on the file. I will need to do this same process for about 1000 different tar files. I've already written the macro to handle all the work after the tar file has been unpacked...
  16. bdmangum

    Insert Save Button in UserForm Window Bar

    Howdy, I was recently contemplating dfiferent methods of allowing a user to save the workbook while running a user form. I thought it might be neat to add a save button next to the close form button (the X in the top right corner). VBA has a built in option of adding a Help button next to the...
  17. bdmangum

    Allow User to Adjust UserForm Size?

    Howdy, Using Excel 2003, is it possible to allow a user to adjust the size of a userform? I was recently asked by a user of a form I created if I could make it so they can resize the form similar to an Internet Explorer window. I am unaware of a method for accomplishing this task. Does...
  18. bdmangum

    Listbox Mouse Wheel Scroll

    Howdy! I'm not even certain this is possible, but I would like to have the ability to use the mouse to scroll up and down a listbox contained within a user form. I'm running Excel 2003. I have a form which contains a large numnber of items in a listbox, thus the ability to use the mouse...
  19. bdmangum

    Set Row Equal to Another Row, Include Formatting

    Per the title, I'm trying to set the value of one row equal to another row, all the while maintain the first row's formatting. I would like to accomplsih this without using a copy/paste method, as per my understanding, the copy/paste method is slow when dealing with large amounts of data...
  20. bdmangum

    Macro Status

    Through the use of Excel forms, I have created a database. This database will become a large file (thousands of rows), thus one macro which requires a look at all of the rows for comparision reasons will take a long time to run. I'm attempting to create a loading/status message window which...

Part and Inventory Search

Back
Top