Search results for query: *

Modeless won't work with the setup I'm running. The form is submitted to the computer be operated as a stand-alone window which allows the user to treat the form the same way they would treat any other window. It gives them the ability to minimize/resize along with several other settings I added...

It's due to some of the code I'm using to run the database. The database functions from userforms with the entire Excel interface hidden from the user. I'm using some code to make it appear to the user as though the database is a stand-alone program. The code (and some other coding) used to...

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

This should do what you need, though there may be a better way... Sub CurUserNames() uSize = UBound(ThisWorkbook.UserStatus) For i = 1 To uSize MsgBox ThisWorkbook.UserStatus(i, 1) Next End Sub BD

This should do it: Private Sub App_DocumentBeforeSave(ByVal Doc As Document, SaveAsUI As Boolean, Cancel As Boolean) Dim myDialog As Dialog If SaveAsUI = True Then Set myDialog = Application.Dialogs(wdDialogFileSaveAs) With myDialog .Name =...

Maybe I misunderstood your post, but here is what I came up with. I don't understand why you need to use the SaveAs dialog, thus I just saved the new file via code. In the "ThisDocument" module: Private Sub Document_Open() Call Register_Event_Handler End Sub In a Class Module named...

By having it so you are not prompted for errors, how can you know if all the work you are doing actually completes? Perhaps an error occurs and none of the work is performed...

This is the last time I will bump this post up and I apologize for bumping it again, but I really need this capability for a program I'm writing at work. Does anyone have any ideas or websites with information on how to accomplish this task?

hmmm, I still can't get this to work. Anyone have ideas?

JB, Thanks for the reply, but I would like to avoid using the SendKeys approach. It can be too unreliable. If per chance the user happens to switch the focus to another application then something undesired could happen. I'm thinking I need to use one of the things were the code is: xxxx.Post...

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

Thanks strongm! Exactly what I was looking for...

Assuming the data does not contain blanks rows in between data values prior to the addition of the new rows the following code will work. I included a delete rows macro as well. Sub InsertRows() Dim count As Integer count = 1 'Starting row of data While ThisWorkbook.Sheets(1).Cells(count...

Valid points Skip, in fact the same ones I brought up myself when tasked with the additional security. However the people who requested the project would like this additional security due to the sensitive nature of the information to be stored in the spreadsheet. Yeah, it's like using the front...

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

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

Agreed. I'll look into the template option. Even as a security feature there are ways around it unfortunately. If you have the user run an install.exe file most Excel features can be changed in the registry. I won't explain how due to the potential for improper use of this trick. For instance...

Well I found the problem. It had nothing to do with references. I fixed it by going to Tools-->Macros-->Security-->Trusted Publishers and then selecting the box labeled "Trust access to Visual basic Project" This creates a new problem though. I outlined my goal in my last post. Now the question...

Gerry, I want to create a new blank form and then add controls to it. Let me provide a brief reason for the design. I have an Excel file located on and run from a shared network folder. The file contains a custom timeout feature which closes the file after 10 minutes of inactivity in order to...

It never fails. Soon after I submit a post with my problem I find the solution. For anyone interested, the solution is at this website: http://www.ozgrid.com/forum/showthread.php?t=58697