Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. How to open up internet explorer and download file

    Hi,

    I have a file which can be accessed through internet explorer. Do you know how to write a macro to download the file through excel?

    I'm imagining maybe shell command might work.
    ...
  2. Replies
    7
    Views
    174

    Re: cannot find library

    OK that worked!

    Duh... I should have figured it out myself.

    Thanks!
  3. Replies
    7
    Views
    174

    Re: cannot find library

    I think it was called "solver.xlma"
  4. Replies
    7
    Views
    174

    cannot find library

    Hi,

    I believe (but am not sure) that there is a problem with the compatability of the 64 bit vs. 32 bit settings.

    I am trying to run a macro and am getting the error "Cannot find library" ......
  5. Replies
    2
    Views
    397

    Re: Couldn't find hstbar.xla Error

    OK thanks!
  6. Replies
    2
    Views
    397

    Couldn't find hstbar.xla Error

    Hi,

    When I open an excel workbook, I get the message "Sorry, we couldn't find \\...\hstbar.xla Is it possible it was moved, renamed or deleted?"

    Does anyone know what the issue is or how to fix...
  7. Replies
    1
    Views
    236

    Prompting to save not working

    Hi,

    In one of my workbooks, if I try to save it after changes, I am not prompted. The workbook just closes. There are no macros in the workbook.

    How can I turn the prompt back on? I close...
  8. Thread: Formulas

    by MetLife
    Replies
    2
    Views
    169

    Re: Formulas

    Yup that was the problem! Thanks
  9. Thread: Formulas

    by MetLife
    Replies
    2
    Views
    169

    Formulas

    Hi,

    Excel isn't working. It isn't calculating basic calculations. When I type in the formula in cell A1 = "C23" it does not show the result for cell C23, it just shows the formula itself. ...
  10. Replies
    1
    Views
    196

    .dll function in code

    Hi,

    I received a model with some strange function declarations. Does anyone know what this type of declaration is supposed to do?


    Declare Function closesession Lib "vpmsdl32.dll" (ByVal...
  11. Replies
    5
    Views
    253

    Re: IRR vba vs. worksheet function

    It is a 1-D array.

    Actually I figured out this issue. The "guess" was different in VBA.

    When I change this to match excel, the two match.

    Thanks!
  12. Replies
    5
    Views
    253

    Re: IRR vba vs. worksheet function

    No the array "arr1' is populated in the code.

    The original program used the worksheet function pointing to the arr1 output. Now the vba just does the irr calculation on the array directly. Both...
  13. Replies
    5
    Views
    253

    IRR vba vs. worksheet function

    Hi,

    I updated a macro so that it uses the IRR within vba rather than the IRR worksheet function.

    To test this compared the worksheet function vs. IRR function & notice that the vba function is...
  14. Replies
    1
    Views
    146

    Running macro - use other workbook

    Hi,

    I am running a macro in one workbook. I want to open and work on another excel workbook.

    Is this possible? Excel 2016

    Thanks
  15. Thread: assign value

    by MetLife
    Replies
    3
    Views
    244

    Re: assign value

    Thanks for the explanations!
  16. Thread: assign value

    by MetLife
    Replies
    3
    Views
    244

    assign value

    Hi,

    I just noticed something about assigning worksheet values to vba variables.

    age1 = Worksheets("Inputs").Range("Age")

    is the same as

    age1 = Worksheets("Inputs").Range("Age").value
  17. Replies
    11
    Views
    369

    Re: ways to call "sub" routines

    I see in "tools-> options-> Editor Format" they have the options to change color for comments and errors. I don't see the variables or sub routines though.
  18. Replies
    11
    Views
    369

    Re: ways to call "sub" routines

    I think the exact same thing. For me it is better if we are limited to just using "Call Bob" etc...

    I also think it is better if the vba will automatically color code variables/functions...
  19. Replies
    11
    Views
    369

    ways to call "sub" routines

    Hi,

    I am analyzing someone else's code. One thing I notice is that they alternate between

    run("some_macro")

    and

    call some_macro
  20. Replies
    3
    Views
    314

    Re: overflow with double precision

    Thanks!
  21. Replies
    3
    Views
    314

    overflow with double precision

    Hi,

    I am getting the error "overflow", when I assign a variable of type double a number >32,000. What is going on?

    dim guess as double
    guess = 73000 'no overflow error
    guess = 73 * 1000...
  22. Thread: Solver macro

    by MetLife
    Replies
    1
    Views
    154

    Solver macro

    Hi,

    I am reviewing a macro. There is logic that appears to use the solver, but I wasn't sure.

    SolverReset
    SolverOk SetCell:="$E$7", MaxMinVal:=3, ValueOf:="0", ByChange:="$D$16"
    ...
  23. Replies
    3
    Views
    134

    Re: formulas with "NA"?

    OK thanks it works, I just needed to make it an array.
  24. Replies
    3
    Views
    134

    formulas with "NA"?

    Hi,

    I asked a similar question with the "SUM" function. Now I want to use Max and Min but the range will occasionally have "#N/A" in the data.

    I want the max/min to skip those cells. How do I...
  25. Replies
    5
    Views
    251

    Re: reading csv and precision

    The csv file is used by more than one program. It used by C++ as wel.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4