Hi Robert, Just a quick check. May be I sound foolish but please check references. A reference to 'Visual Basic for Applications' must be made in order to access VBA Object model.
________________________________________ Thanks & Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ________________________________________ On Nov 25, 4:47 pm, "OpenExcel.com" <26may.1...@gmail.com> wrote: > Hi Robert, > > What kind of problem? > VBA.Environ("appdata") can be used irrespective of the OS(must be > windows). > > ________________________________________ > Thanks & Regards > Ashish Jain > (Microsoft Certified Application Specialist) > (Microsoft Certified > Professional)http://www.excelitems.comhttp://www.openexcel.com > ________________________________________ > > On Nov 25, 4:27 pm, roberto mensa <robb....@gmail.com> wrote: > > > > > > > > > hi Ashish, > > There are problems to use VBA.Environ("appdata") ? > > regards > > r > > > 2010/11/25 OpenExcel.com <26may.1...@gmail.com> > > > > Hi Friends, > > > > Visit > > >http://www.excelitems.com/2010/11/speed-up-excel-start-up-faster-exce... > > > onhttp://www.excelitems.com > > > > ________________________________________ > > > Thanks & Regards > > > Ashish Jain > > > (Microsoft Certified Application Specialist) > > > (Microsoft Certified Professional) > > >http://www.excelitems.com > > >http://www.openexcel.com > > > ________________________________________ > > > > -- > > > > --------------------------------------------------------------------------- > > > ------- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
