$$Excel-Macros$$ Where can I learn about ActiveX Libraries?

2009-10-12 Thread Tony Bender
I have an Excel based application that references Microsoft ActiveX Data Objects 2.8 Lib. I am about to push this application out to multiple users within our company, but some of them only have Microsoft ActiveX Data Objects 2.5 Lib. Will my application run properly if a user has an older versi

$$Excel-Macros$$ Is there code that when and Excel file opens it closes any open PowerPoint files?

2009-10-08 Thread Tony Bender
I have an Excel application that enables the user to export an Exccel chart directly into PowerPoint. The macro to do this works fine provided PowerPoint was not already open. I am trying to figure the VB code so when the application opens it automatically closes PowerPoint - if in fact PowerPoi

$$Excel-Macros$$ Re: Problems re-opening userform

2009-10-08 Thread Tony Bender
me to repspond. Tony Bender --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2.

$$Excel-Macros$$ Re: Problems re-opening userform

2009-10-08 Thread Tony Bender
me to repspond. Tony Bender On Oct 8, 5:03 am, Paul Schreiner wrote: > You should set a breakpoint and > try to step through your macro to see what's going on. > > Which file has the ExitApp macro? > Is it in the Rpt1.xls file? > > If it is, then once the activework.close l

$$Excel-Macros$$ Problems re-opening userform

2009-10-07 Thread Tony Bender
I have an application consisting of a report menu and the corresponding templates the menu points to. The menu is a UserForm (UF1) and resides on a separate workbook (Wkbk1). When the user opens Wkbk1 it automatically opens the UserForm (UF1). The user then selects a report template from one of

$$Excel-Macros$$ Re: initiate macro when mouse hovers over a shape

2009-10-01 Thread Tony Bender
Thank you, yes this works great On Sep 30, 9:13 pm, Tony Bender wrote: > I have an Excel application and on my 'front end' I would like to > generate a pop-up note when the user hovers over a 'shape'.  (This > would be similar to how a comment appears when the u

$$Excel-Macros$$ initiate macro when mouse hovers over a shape

2009-09-30 Thread Tony Bender
understand the code I'd need to write to do this. Thank you, Tony Bender --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text

$$Excel-Macros$$ Make a cell a control that launches macro when clicked

2008-09-11 Thread Tony Bender
Is there a way to set a cell so when the user clicks on it, it launches a specified macro? If so can you show me how it's done? Thank you, --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this