 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Publisher / Programming / April 2007Microsoft Excel and Microsoft Publisher
I need to automatically copy specific cells from Microsoft Excel into a graph in Microsoft Publisher - How can I do this? Select the cells, copy, paste into the Publisher table. Hold ctrl to select specific cells in Excel.  SignatureMary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com >I need to automatically copy specific cells from Microsoft Excel into a graph > in Microsoft Publisher - How can I do this? Thanks Mary, Do you know of any macro type function that will enable me to do this automatically or a way I can code anything to do this automatically either in Publisher or Excel. I know Excel has macros but don't think they will execute "externally" outside of that software and I don't know if Publisher has any macro capability. I appreciate your suggestion, just wondered if there was another way? Debi > Select the cells, copy, paste into the Publisher table. Hold ctrl to select specific > cells in Excel. > > >I need to automatically copy specific cells from Microsoft Excel into a graph > > in Microsoft Publisher - How can I do this? We have a Publisher guy that will help. I'm sure he will answer your questions. SignatureMary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com > Thanks Mary, > [quoted text clipped - 14 lines] >> >I need to automatically copy specific cells from Microsoft Excel into a graph >> > in Microsoft Publisher - How can I do this? Mary Sauer <gsauer@mycolumbus.rr.com> was very recently heard to utter: > We have a Publisher guy that will help. I'm sure he will answer your > questions. >> Do you know of any macro type function that will enable me to do this >> automatically or a way I can code anything to do this automatically >> either in Publisher or Excel. >> I know Excel has macros but don't think they will execute >> "externally" outside of that software and I don't know if Publisher >> has any macro capability. You can automate Excel from Publisher's VBA. All Excel commands are available by calling an instance of Excel from Publisher's VBA. Publisher has no macro recorder, so you will have to manually write your code, or hire someone to do so for you. Some tutorials on Publisher VBA can be found at http://msdn.microsoft.com/office/understanding/publisher/default.aspx Alt+F11 or Tools > Macros > Visual Basic Editor will bring up the VBE in Publisher. SignatureEd Bennett - MVP Microsoft Publisher I moved my publisher files over to new computer when mother board died in old one. I try to open my publisher files but it says it cannot open this version. I right clik on my old files and its says version 2000.06 I have my 2000 program on new computer but still can't open these files? HELP SignatureTom in Ohio > Mary Sauer <gsauer@mycolumbus.rr.com> was very recently heard to utter: > > We have a Publisher guy that will help. I'm sure he will answer your [quoted text clipped - 17 lines] > Alt+F11 or Tools > Macros > Visual Basic Editor will bring up the VBE in > Publisher. Well Tom, it depends on where you live in Ohio. I suspect it is the reason for your problem. I am in southern Ohio and I have no problems... Have you installed a virus program, is it Norton? How to use Office programs with the Norton AntiVirus Office plug-in http://support.microsoft.com/kb/329820/en-us What happens if you double-click a file? I am assuming the files are on your hard drive. How to troubleshoot a damaged publication in Publisher http://support.microsoft.com/kb/198256/en-us If all fails, send the files to me and I will see what I can do. mary-sauer at columbus.rr.com SignatureMary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com >I moved my publisher files over to new computer when mother board died in old > one. I try to open my publisher files but it says it cannot open this [quoted text clipped - 23 lines] >> Alt+F11 or Tools > Macros > Visual Basic Editor will bring up the VBE in >> Publisher. Mary I sent you an e-mail with a file attached SignatureTom in Ohio > Well Tom, it depends on where you live in Ohio. I suspect it is the reason for > your problem. I am in southern Ohio and I have no problems... [quoted text clipped - 40 lines] > >> Alt+F11 or Tools > Macros > Visual Basic Editor will bring up the VBE in > >> Publisher. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.