PDA

View Full Version : VBA to login and post in FACEBOOK



mji
03-10-2016, 05:03 AM
How i login in facebook and post via vba.

Regards.

MJI

mancubus
03-10-2016, 05:26 AM
did you search it?

this is what i get for login bit.



Sub vbax_55399_facebook_login()

With CreateObject("InternetExplorer.Application")
.Visible = True
.Navigate http://www.facebook.com/login.php
Do While .Busy And Not .ReadyState = 4
DoEvents
Loop
.Document.All.Item("email").Value = "email_address_here"
.Document.All.Item("pass").Value = "password_here"
.Document.All.Item("loginbutton").Click
End With
End Sub


insert double quotes before and after url.

mancubus
03-10-2016, 05:31 AM
for posting bit, see:
http://www.mrexcel.com/forum/excel-questions/863019-visual-basic-applications-automate-facebook-post-thumbnail.html

the OP seems successful with posting text but having difficulties when it comes to post a link.

Aflatoon
03-10-2016, 06:02 AM
Why would you want to do this?

mancubus
03-10-2016, 06:49 AM
social media marketing issue, i guess...

it is very powerful when used efficiently, especially combined with other apps like instagram and twitter.

first you connect with as may people as possible, create a group, add them to this group, then promote what you wish to sell in such a way so that you don't have to pay FB a dime. :)

Aflatoon
03-10-2016, 07:02 AM
Hmm. I definitely don't want to help someone automate that then. ;)

mancubus
03-10-2016, 07:44 AM
just a guess. the OP may have different goals...


another use is to promote ngo / charity activities to raise funds etc.

Aussiebear
03-10-2016, 05:10 PM
Hmm. I definitely don't want to help someone automate that then. ;)

I'm definately with you on that one.

mji
03-11-2016, 04:41 AM
I doing this for work purposes hope you will provide me support thanks

mancubus
03-11-2016, 05:27 AM
do you mean you want to automate posting to your company's FB timeline?

how about posts 2 and 3 above?

you should play with them to adopt.

mji
03-11-2016, 05:31 AM
I doing this for work purposes hope you will provide me support thanks

mancubus
03-11-2016, 06:29 AM
to mji -(stop)-
vbax -(stop)-

i am not doing this for work purposes hope you -(stop)-
stop repeating yourself thanks -(stop)-

sincerely -(stop)-
mancubus -(stop)-
vbax -(stop)-