使用VBA将图像从一张纸的页眉/页脚复制到另一张纸 [英] Use VBA to copy an image from headers/footers of one sheet to another

问题描述

我需要编写VBA代码，将一个excel工作表页眉/页脚中的公司徽标复制到另一工作簿的另一工作表中.有什么想法吗?

I need to write a VBA code to copy a company logo in the headers/footers of one excel sheet to another sheet in another workbook. Any ideas?

推荐答案

Excel具有方便的记录宏"功能.

Excel has a handy Record Macro function.

您可以启动该操作，将页脚复制过来，然后停止录制.

You can initiate that, Copy the footer over, then stop the recording.

然后，查看代码，它应该几乎可以向您展示如何做到这一点.

Then, review the code, and it should pretty much show you how to do it.

这篇关于使用VBA将图像从一张纸的页眉/页脚复制到另一张纸的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！