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
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
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.
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
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
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
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
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