Search:

Type: Posts; User: JeanM; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    18
    Views
    946

    Hi Zeddy Wow! That works really nice. I have...

    Hi Zeddy

    Wow! That works really nice. I have two suggestion: make the button in Step 1 larger--I almost didn't see it--I guess I shouldn't test things when I am tired. My other suggestion is I...
  2. Replies
    18
    Views
    946

    Hi RG This is exactly what I was looking...

    Hi RG

    This is exactly what I was looking for--hard to believe it got that complicated. The tab name is not important. Searching this topic under importing was not helpful--I tried move/copy and...
  3. Replies
    18
    Views
    946

    Hi RG So sorry about that. The password is...

    Hi RG

    So sorry about that. The password is HWSDUI.

    Jean
  4. Replies
    18
    Views
    946

    Import Button with Code

    Hi

    Attached are two workbooks. The Master workbook has a button without any code. I want the button to allow the user to open a workbook from a directory/folder. For this example the user...
  5. Replies
    18
    Views
    946

    Hi RG Can I attach my workbooks--because I am...

    Hi RG

    Can I attach my workbooks--because I am getting confused--and you can see more clearly what I am trying to do?

    Jean
  6. Replies
    18
    Views
    946

    Selecting Filenames & Directories

    Hi RG

    Thank you for the code to select filenames and & directories but I need to have the workbook sheets appear in another workbook that will be open at the time when the user chooses from the...
  7. Replies
    18
    Views
    946

    Hi Maud 1. I want the user to be able to pick...

    Hi Maud

    1. I want the user to be able to pick the workbook within the folder.
    2. The workbooks should all be xlsm but maybe I should have xlsx available too.
    3. Each workbook could have one...
  8. Replies
    18
    Views
    946

    Import Button with Code

    Hi Maud

    I think I need to start over. This is what I wanted to accomplish:
    I have a workbook--DDHVE.xlsm.
    I have a button that will allow me to chose a directory and import another or several...
  9. Replies
    18
    Views
    946

    Button with import code

    Hi

    I have the following code on a button and it is not recognizing any excel workbooks in the directory where they reside. My goal is to have the user pick the workbooks they want to import.
    ...
  10. Replies
    3
    Views
    128

    Hi I actually got it to work. It took forever...

    Hi

    I actually got it to work. It took forever to show up in my email and I have the workbook with just the sheets I wanted. Sorry that I was not more patient with my email delivery.

    Jean
  11. Replies
    3
    Views
    128

    E-mail code in Excel

    Hi

    I have the following code where I attach one sheet of a workbook but now I need to adjust the code to attach several sheets. The sheets all begin with ChkptTS--example ChkptTS1, ChkptTS2,...
  12. Replies
    26
    Views
    1,088

    Hi RG Where am I suppose to put this code? As...

    Hi RG

    Where am I suppose to put this code? As for continuing on with a pop-up box, do you think I should start a new post?

    Jean
  13. Replies
    26
    Views
    1,088

    Hi RG Thank you very much for testing,...

    Hi RG

    Thank you very much for testing, cleaning and adding all that was needed for the wb up to this point. I learned a lot but I would not have been able to do it without your help. I am...
  14. Replies
    26
    Views
    1,088

    Exit code with a password

    Hi RG

    I have another problem with closing the wb without entering in the data in the exit code. The suggestion was to use the following code:

    If UsrName="HSO" Then Exit Sub

    Obviously that...
  15. Replies
    26
    Views
    1,088

    Hi RG That works great with the fringe. As...

    Hi RG

    That works great with the fringe. As for the Project Number, my change works. Maybe if you like I can send what I have and you can test it?

    Jean
  16. Replies
    26
    Views
    1,088

    Exit Code Continued ...

    Hi RG

    I am continuing with the exit code and going in order of the worksheets and the fields I want to capture on exit. I have the user form with project number working. This is what worked:
    ...
  17. Replies
    26
    Views
    1,088

    Exit Code Revised

    Hi RG

    I have started to clean up the exit code and I understand what I need to do to expand on the code titled--Private Sub Workbook_BeforeClose(Cancel As Boolean)--but how do I incorporate the...
  18. Replies
    26
    Views
    1,088

    Hi RG That works great--exactly what I needed...

    Hi RG

    That works great--exactly what I needed for my user group. As for cleaning up the exit code, I am agreeable if you want to tackle it, but I hope I am not taking you from more challenging...
  19. Replies
    26
    Views
    1,088

    Hi RG I finally had a chance to play with the...

    Hi RG

    I finally had a chance to play with the form in the cover sheet and I really like how it works. I enabled the exit code and did not have the same success with the input box. On the exit...
  20. Replies
    26
    Views
    1,088

    Create a Custom Number Format

    Hi RG

    The sheet "Cover" is where I want the user to type in the Project Number. I did add in your previous code into this sheet. "This Workbook" has the exit code which will drive you crazy--so...
  21. Replies
    26
    Views
    1,088

    Hi RG The code here is great but I do not know...

    Hi RG

    The code here is great but I do not know how to incorporate into what I already have. This user group makes so many mistakes with entering the Project Number that it drives me crazy with...
  22. Replies
    26
    Views
    1,088

    Hi RG This works great if my user group...

    Hi RG

    This works great if my user group fills-in the cell but I wanted it to also work on exit or close. I was looking for a way that the input box would retain the format and the user would not...
  23. Replies
    26
    Views
    1,088

    Create a custom number format

    Hi RG

    Is there any way I can use the code you provided into the following existing code: It was so easy formatting percent!! Jean


    Private Sub Workbook_BeforeClose(Cancel As Boolean)...
  24. Replies
    26
    Views
    1,088

    Create a custom number format

    Hi

    I have an input cell where the user needs to enter a project number. An example of a project number is 0194-0722-AB. It always starts with a zero, 4 digits, a hyphen, 4 digits, a hyphen, and...
  25. Replies
    4
    Views
    289

    Hi Maudibe This works great. Before I heard...

    Hi Maudibe

    This works great. Before I heard from you I did come up with code that worked when opening the WB, but it took to long to open the WB. This works so much better. Thank you.

    Jean
Results 1 to 25 of 69
Page 1 of 3 1 2 3