D
DebiEDS
I need to automatically copy specific cells from Microsoft Excel into a graph
in Microsoft Publisher - How can I do this?
in Microsoft Publisher - How can I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mary Sauer
Select the cells, copy, paste into the Publisher table. Hold ctrl to select specific
cells in Excel.
cells in Excel.
D
DebiEDS
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
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
M
Mary Sauer
We have a Publisher guy that will help. I'm sure he will answer your questions.
E
Ed Bennett
Mary Sauer said:We have a Publisher guy that will help. I'm sure he will answer your
questions.
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.
T
Tom
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
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
M
Mary Sauer
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
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
T
Tom
Mary I sent you an e-mail with a file attached