• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. debxxx1

    How to get a variable value from another file

    Thanks Sir, this is bit long but a very nice solution. :) Cheers
  2. debxxx1

    VBA Code to Detect Non Password Protected Attachment

    Thanks everyone for contributing. If you find any other solutions and alternatives while testing with above please share here. Cheers
  3. debxxx1

    How to get a variable value from another file

    Hi Genius people, I have 2 workbooks. Let's say one is X.xlsb and one is Y.xlsb. (X.xlsb is a production file which I can't modify means I can only modify Y.xlsb) In X.xlsb I have a public variable public const publicVar ="123" How can I get the value of this public variable in Y.xlsb? I...
  4. debxxx1

    How to convert a large string into multiple lines (=10 characters)

    That works. Thank you so much sir.
  5. debxxx1

    How to convert a large string into multiple lines (=10 characters)

    Hi Briliant people here, Can you please help me. I have a big string in VBA and I want to convert into a small string where each line should not contain more than 10 characters. Below is the example. Thank you in advance, This is my Input LString= "abc123acz1abc123acz113rfvfvejcvjcvjhvsdhvh"...
  6. debxxx1

    retrieving data from mails(outlook) using excel/vba

    Thank You So Much
  7. debxxx1

    VBA Code to send an Email with .msg attachment

    Hi Genius people, If you can help me with below I will be very helpful. Thanks in advance. I have some Outlook message(.msg) files in my local system. I am trying to send an outlook email where these (.msg) files will be attached. Below is the code which I am using but in the attachments.add...
  8. debxxx1

    VBA Code to Detect Non Password Protected Attachment

    Hi Genius People, I have designed a VBA code which handles all my outlook outgoing emails. Currently I am trying to enhance it like: When I will send a Zip/Excel attachment through outlook, my code can able to check and warn whether the attachment is password protected or not. Please Help.
  9. debxxx1

    VBA Code To Detect Outlook Voting response

    I solved it by my own. I needed a code not any newbie's outlook advise btw If TypeName(item) <> "MailItem" Then Cancel = False Exit Sub ElseIf Left(item.Subject, 3) = "Yes" Then Cancel = False Exit Sub ElseIf Left(item.Subject, 2) = "No" Then Cancel = False Exit Sub End If
  10. debxxx1

    VBA Code To Detect Outlook Voting response

    Hi Guys, I am trying to set an action in my outlook code that will automatically detect the voting response (Yes,No) and ignore them. Please Help
  11. debxxx1

    Vba code to find a text within merged cell

    Please help. I want to find a particular text that is located in a merged cell in my worksheet. Thank you in advance.
  12. debxxx1

    Plz help: How to paste pictures from my excel sheet to outlook mail

    I have 3-4 jpeg pictures in my excel sheet I want to paste them in my outlook mail, plz tell how to do it using vba ??
  13. debxxx1

    How to get monday and friday of last week

    Thanks bro for helping... it worked but a small mistake instead of ";" we have to use "," ... but thanks a lot... :-)
  14. debxxx1

    How to get monday and friday of last week

    Plz tell me how to get the monday and friday of last week. I have tried using several codes some work correctly but when I'm changing the date to tuesday of next week it's again giving wrong answer.. Any one have the solution please post..
Back
Top