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...
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"...
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...
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.
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
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..