Re: References for VBA


"Amy Blankenship" <Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx> wrote in message news:ef3X2dC0FHA.464@xxxxxxxxxxxxxxxxxxxxxxx
That's not so much what I meant (sorry for the delay...been out of town). If you try some code in VBA from within whatever application and it doesn't work, how do I know what references to check to MAKE it work, since the help files never say "this functionality only works if you reference blah blah"


That is usually because the object you are using is not within the object model for that application. Its a bit hard for Microsoft to document everything that isn't there as well as everything that is!


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org 

.

Relevant Pages

  • Re: VBA errors in 2007 (works fine in 2003)
    ... It's just breaking on the Mac version of Excel. ... Pak allowing you to call functions in the ATP from within VBA. ... menu in VBA, choose References, and select "atpvbaen.xls". ... If there is the possibility of a name collision (two or more libraries ...
    (microsoft.public.excel.misc)
  • Re: VBA errors in 2007 (works fine in 2003)
    ... The file is working as intended now in Excel 2003 and 2007. ... Pak allowing you to call functions in the ATP from within VBA. ... menu in VBA, choose References, and select "atpvbaen.xls". ... If there is the possibility of a name collision (two or more libraries ...
    (microsoft.public.excel.misc)
  • Re: VBA errors in 2007 (works fine in 2003)
    ... The file is working as intended now in Excel 2003 and 2007. ... Pak allowing you to call functions in the ATP from within VBA. ... menu in VBA, choose References, and select "atpvbaen.xls". ... If there is the possibility of a name collision (two or more libraries ...
    (microsoft.public.excel.misc)
  • Re: VBA errors in 2007 (works fine in 2003)
    ... It appears to be getting through the UnHideSheets macro, ... Pak allowing you to call functions in the ATP from within VBA. ... menu in VBA, choose References, and select "atpvbaen.xls". ... If there is the possibility of a name collision (two or more libraries ...
    (microsoft.public.excel.misc)
  • Re: VBA errors in 2007 (works fine in 2003)
    ... It's just breaking on the Mac version of Excel. ... Pak allowing you to call functions in the ATP from within VBA. ... menu in VBA, choose References, and select "atpvbaen.xls". ... If there is the possibility of a name collision (two or more libraries ...
    (microsoft.public.excel.misc)