Thread
:
Creating a Custom commandbar button
View Single Post
#
6
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Creating a Custom commandbar button
That code worked ok for me.
My bet is that you got extra characters when you copied from Google. Google
seems to add extra spaces and dashes in bad spots.
You may be able to connect directly to the newsgroup and copy from there.
Saved from a previous post:
If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).
news://msnews.microsoft.com/microsof...ic.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsof...heet.functions
news://msnews.microsoft.com/microsof...excel.newusers
news://msnews.microsoft.com/microsof...el.programming
(and a few more for MSWord)
news://msnews.microsoft.com/microsof....docmanagement
news://msnews.microsoft.com/microsof...word.word97vba
news://msnews.microsoft.com/microsof....word.newusers
news://msnews.microsoft.com/microsof...ord.pagelayout
news://msnews.microsoft.com/microsof...ord.vba.addins
news://msnews.microsoft.com/microsof....vba.beginners
news://msnews.microsoft.com/microsof....customization
news://msnews.microsoft.com/microsof...rd.vba.general
news://msnews.microsoft.com/microsof....vba.userforms
news://msnews.microsoft.com/microsof....word6-7macros
(You can always connect to more later)
Here are some links that explain it better:
Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm
David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm
Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tut...e_ng/index.htm
And if you're looking for old posts:
Or you can use google to search for stuff you've posted (and find the replies,
too)
http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_gr...Excel*&num=100
Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm
sifar wrote:
Hi, I get Error message "Cannot find Project Library" &
msoCommandButton gets highlighted.
What do i do?
have loaded the Addins viz., Analysis toolpack, Analysis Toolpack-VBA,
selected references viz, MS Forms 2.0 in References.
Does it mean that Excel not fully installed on PC?
How do i load all these files on Workbook_open() using VBA????
Rgds,
Sifar
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson