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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ceddins

  1. ceddins

    VBA code only works when stepped through or played from within the VBE window

    zelgar, great catch! I've added the code to delete the sheets. Thank you. Andrzejek, well said. Never again will I take lightly any advice from the wise wizards of TT! [thumbsup2] combo, thanks for elaborating so I have an understanding of why Excel is behaving the way it is. All of you: Thank...
  2. ceddins

    VBA code only works when stepped through or played from within the VBE window

    combo, I did not mention in my previous post, but that's exactly why I did. I printed the codename to the .txt file just like you've written it. That's how I know the codename for each imported sheet is blank, or "". That is what leads me to my question: Does anyone know why the newly added...
  3. ceddins

    VBA code only works when stepped through or played from within the VBE window

    Andrzejek, sorry I did not try this previously, it's a fantastic trick. I was able to drill down to the problem with your .txt file method by printing the variable values in the SUMIF3D sub. When y did not print at all, I knew that the If statement before y is introduced was never equaling...
  4. ceddins

    VBA code only works when stepped through or played from within the VBE window

    SkipVought, good idea calling them both from a 3rd sub, but that did not work either. combo, I added the msgbox code exactly where you've placed it, and this time the SUMIF3D sub DID execute. Does it have something to do with Excel being able to stop before entering the SUMIF3D procedure? This...
  5. ceddins

    VBA code only works when stepped through or played from within the VBE window

    Hi, Combo, so thankful for your input. I know the SUMIF3D code does not execute because the Rollup tab values all remain zero after clicking the button and importing the files. However, it WILL execute if I do one of the following: 1) I go into the SUMIF3D after I've clicked the button, imported...
  6. ceddins

    VBA code only works when stepped through or played from within the VBE window

    SkipVought, I want to add - in case I was unclear - that the SUMIF3D procedure DOES run on it's own, but it DOES NOT run when it is called from within the Import_Properties sub. That is the issue. I am trying to figure out why it will not run from within the Import_Properties sub. The...
  7. ceddins

    VBA code only works when stepped through or played from within the VBE window

    SkipVought, I didn't realize that is what you were asking me; I am truly sorry for my misunderstanding! I am very grateful for you continuing to lend your time to help me. This link has the Rollup file with 4 imported tabs. Please let me know how else I can...
  8. ceddins

    VBA code only works when stepped through or played from within the VBE window

    Sorry about that; the workbook with the SUMIF3D is the first link.
  9. ceddins

    VBA code only works when stepped through or played from within the VBE window

    SkipVought, here is the rollup tool and 4 test files to import into the rollup tool. I've never uploaded a file to this site, so I hope I did it right http://files.engineering.com/getfile.aspx?folder=9a257a5d-5388-4b6d-925e-4dc801a777f3&file=Rollup_Tool_Web_Version.xlsb...
  10. ceddins

    VBA code only works when stepped through or played from within the VBE window

    SkipVought: All of the Import_Properties code executes and works when I click the button EXCEPT for the SUMIF3D portion of the code. Andrzejek: when I put a break point on the SUMIF3D line and I click the button, code stops at the break point. Then, when I continue it from the break point, the...
  11. ceddins

    VBA code only works when stepped through or played from within the VBE window

    I mean that all of the cells on the Rollup tab where the SUMIF3D should be putting values remain zero after the code is run which is what they are before the user clicks the button when no data has been imported yet.
  12. ceddins

    VBA code only works when stepped through or played from within the VBE window

    When the button is clicked, the Import_Properties code runs. I right-clicked the button and assigned the Import_Properties macro to it. I know it is assigned correctly because the macro runs when I click the button; it just doesn't play the SUMIF3D sub as it should unless I play from within the...
  13. ceddins

    VBA code only works when stepped through or played from within the VBE window

    zelgar, I did try moving all of the SUMIF3D up to the main sub, and that didn't work either.
  14. ceddins

    VBA code only works when stepped through or played from within the VBE window

    Hi SkipVought. I have a tab whose codename is Rollup. It should run, but it doesn't! For some reason it only works when I step through or press play from within the code window. I need it to work when the user presses the button.
  15. ceddins

    VBA code only works when stepped through or played from within the VBE window

    Hey zelgar. Thanks for replying. I tried your suggestion, and I got an "Object doesn't support this property or method" error when running it. I put Rollup in the parenthesis of the sub header Sub SUMIF3D(Rollup) which required me to also put it in parenthesis after it's called in the...

Part and Inventory Search

Back
Top