Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    118

    I did not explain myself well... here is my...

    I did not explain myself well... here is my code...


    Private Sub Workbook_Open()
    AddIns("Analysis ToolPak").Installed = True
    AddIns("Analysis ToolPak - VBA").Installed = True

    ...
  2. Replies
    3
    Views
    118

    Programmatically displaying Add-Ins tab

    I am trying to programmatically show the Add-Ins tab when excel starts. I also want to hide that tab when excel closes. This is only for a particular workbook. I tried to record the steps with the...
  3. Replies
    4
    Views
    1,690

    Thanx so much to both of you... I used Zeddy's...

    Thanx so much to both of you... I used Zeddy's approach because I really didn't need to display a message about it being deleted. Just that it was gone and as such... recreated the button... FYI..
    ...
  4. Replies
    4
    Views
    1,690

    Checking for existence of command button

    I know how to programmatically create a command button... size, text and all that... but how do I check for its existence in order to create it? I want to check to see if someone has mistakenly...
  5. Thanks so much for your input... was hoping to...

    Thanks so much for your input... was hoping to avoid vba as the person I am doing this for wants it as simple as possible but will take a look at it.
  6. Non Repeating Output List from Excel Equal to Input list

    I have this list in a column... 20 different values... I want to generate a random output list from the input list and not repeat. I have used =INDEX($D$1:$D$20,RANDBETWEEN(1,20)) in each of the 20...
  7. Replies
    3
    Views
    1,808

    Thanx so much for the input... that did not solve...

    Thanx so much for the input... that did not solve the problem either... guess I will have to live with it and use google as my work around.
  8. Replies
    3
    Views
    1,808

    Help Viewer not working

    In 2010 Word & Excel I receive the following message...

    "The Help viewer has encountered an unexpected problem and cannot continue."

    BUT... the help works fine in Powerpoint. I have Reset IE...
  9. Replies
    4
    Views
    361

    That was not checked BUT... in planning for the...

    That was not checked BUT... in planning for the future, I had placed "Option Explicit" in the code. Once I commented that out all seems to work just fine. Thanx SO much for pointing me in the right...
  10. Replies
    4
    Views
    361

    dialogstyle not working

    What worked just fine in 2003 is now causing a problem in 2010. The code reads...

    dialogstyle = vbQuestion + vbYesNo + vbDefaultButton2

    Now gives me the error message of...

    "Compile...
  11. Thanx so much but this is not an option... IT...

    Thanx so much but this is not an option... IT dept won't allow permissions to do that. I did find a possible workaround over at Ozgrid that I will try.
  12. Add In MS Date Time Picker missing for XL 2010

    My IT dept decided NOT to install the add-in for the MS Date Time Picker control. I have a program that I wrote that allows users to choose a date on a calendar... is there any kind of work around...
  13. Replies
    6
    Views
    820

    THAT'S IT!!! Thanks so much.

    THAT'S IT!!! Thanks so much.
  14. Replies
    6
    Views
    820

    OK... will upload a file called 0test0. If you...

    OK... will upload a file called 0test0. If you look on the tab called "Data" at cell D18 you will see that the cell if formatted to display 5 digits... the actual value in the cell is 0 (zero). If...
  15. Replies
    6
    Views
    820

    Formula NOT displaying 0 (zero)

    On one tab I have a cell that has the value 0 (zero) in it and formatted to display as five zeros (00000). Another sheet has a formula that looks at that cell and returns either a null (blank)...
  16. Replies
    1
    Views
    495

    append Win 7 environment

    My current environment is as such..
    TEMP = c:\temp
    TMP = c:\tmp

    There are progs that will not function with that environ...

    Can I append it to read something like...

    TEMP = c:\temp;...
  17. Replies
    2
    Views
    652

    This does the trick. Thanx so much

    This does the trick. Thanx so much
  18. Replies
    2
    Views
    652

    I want to count whether every other cell has an...

    I want to count whether every other cell has an entry or not. I can do this...

    COUNTA(C4,E4,G4,I4)

    But that gets rather long when dealing with 25 columns. I tried this... but am not getting...
  19. Off 2007 beta destroys Off 2K (Office 2007)

    I downloaded and installed Office 2007. It destroyed my Office Pro 2k. Now when I try to reload my Off 2k it refuses to install. When I try to un-install Off 2k I get the error message

    "This patch...
  20. Replies
    1
    Views
    438

    Lost printer (XP SP2 Home)

    For whatever reason, XP keeps losing my HP Photosmaret 7550. I can go for hours and nothing happens, but then all of a sudden, the printer is gone. The only way to get the printer back is to cycle...
  21. Replies
    1
    Views
    514

    Word crashes (Word 2K3 SP1)

    I was in the process of developing a form in Word... some of the fields got corrupted. Don't know what or why. Now, when I open that particular form, it crashes word. I would hate to have to start...
  22. Replies
    2
    Views
    457

    Re: ChDir (XL2K3 SP1)

    Jan...

    Thanx so much... worked like a dream.

    Dennis
  23. Replies
    2
    Views
    457

    ChDir (XL2K3 SP1)

    I am trying to get Excel to save the file to a certain path / folder / directory but I cannot get Excel to Change Directory. Here is the code..

    Sub Filename01()
    Sheets("Filenaming").Select
    ...
  24. Replies
    1
    Views
    445

    Breaking out of a Loop (XL2K3 SP1)

    I have written this deliberate loop. It is a countdown timer. I am looking for a way to break out of it preferably by a user pressing a button. The code...

    Sub StartTimer()
    Do
    Calculate
    ...
  25. Replies
    3
    Views
    464

    Quitting XL (XL2K3 SP1)

    I am trying to get Exel to quit but it is failing to do so. Here is my code.

    Private Sub ErrMsgQuit()
    Sheets(1).Activate
    msg = "You have failed three times to make and entry in this...
Results 1 to 25 of 108
Page 1 of 5 1 2 3 4