Search:

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

Search: Search took 0.00 seconds.

  1. Creating pools/bundles of data from database

    Is it possible to bundle data together based on certain criteria? For example, I have 32 properties (average value of $718k) as a starting point. I need to make four bundles of 5 properties, and two...
  2. Re: Transfer Rows from One Worksheet to Another if Certain Condition is met

    I'm relatively new to coding so I guess I will have to try to manipulate codes from other threads
  3. Transfer Rows from One Worksheet to Another if Certain Condition is met

    Hi All,

    I want to transfer certain rows from one worksheet to another if for example, column T = "Complete". I have a bunch of columns listing out tasks, and when the task is complete, users input...
  4. Re: Batch file to open and run two macros in excel

    Nvm, I think I figured it out. Thanks for your help!!!
  5. Re: Batch file to open and run two macros in excel

    And if you want to run two macros, simply add the following (under "xlApp.Run "~your_macro_here"):

    xlApp.Run "~second macro name here~"

    Sorry, I'm very new to vba, vbs, etc. Thanks for your...
  6. Batch file to open and run two macros in excel

    Hi All,

    I want to create a batch file to open and run two different macros in excel. The reason I need a batch file is to do this automatically for me without me having to manually open the excel...
  7. Re: VBA, InputBox, Run-time error '424': Object required

    Any way I can avoid the Run-Time Error 424 in this code:

    Sub SendEmail_CancelWarning()
    Dim OutlookApp As Object
    Set OutlookApp = CreateObject("Outlook.Application")
    OlSecurityManager.ConnectTo...
  8. Re: Adding a comment to Conditional Formatting via VBA

    So I got Task Scheduler to work but can't bypass that security message. I tried the code above [Sub SendEmail_CancelWarning()], but I get this error: Run-time error '424': Object Required. Any idea...
  9. Re: Adding a comment to Conditional Formatting via VBA

    Thanks again! I tried using that last code but some error was popping up. I'll try getting task scheduler to work.
  10. Re: Adding a comment to Conditional Formatting via VBA

    It worked when I kept the codes separate!!! So the way around not having to keep excel open is setting up windows task schedule??

    Any way around the message which reads "A program is trying to...
  11. Re: Adding a comment to Conditional Formatting via VBA

    I tried the last code you sent... when I try to run it, it pops up with a message saying "Compile Error: Syntax Error" for the second line of code.

    I'm going to try to keep the two codes separate...
  12. Re: Adding a comment to Conditional Formatting via VBA

    Do I combine the previous code ie..

    Sub SendEmail()
    ActiveWorkbook.SendMail _
    Recipients:="abc@email.com", _
    Subject:="Subject header" & Format(Date, "dd/mmm/yy")
    End Sub

    With this code to...
  13. Re: Adding a comment to Conditional Formatting via VBA

    That works perfectly! Thanks so much!

    Last question, how would I automate it to do it everyday?
  14. Re: Adding a comment to Conditional Formatting via VBA

    That will do. Thanks!

    Any idea on how to automatically send daily emails (with excel file attached) from Outlook?
  15. Re: Adding a comment to Conditional Formatting via VBA

    That does help. The only issue is I have a drop-down menu which gives options for "Prepaid Deposit" or "Loan Proceeds". Based off the user's choice, other formulas within the worksheet are updated....
  16. Adding a comment to Conditional Formatting via VBA

    Hi All,

    I'm very new to the VBA world and don't have much experience with coding. I want to do the following, but am not sure how to:

    I have a column called "Classification", and if there is...
Results 1 to 16 of 16