f********s
发帖数: 658 | 1 I created a VBA code in one Excel workbook. I add a button in the toolbar to
facilitate the use. My excel version is 2007. I want to use this vba code
in another workbook.
However, when I open other workbook and click on the button, I can't access
the code I created. I remember in the before when I use Excel 2003 and click on the buttion,
Excel can open the workbook which I created and saved this Macro and then
use it for the new version.
How do I sovle this problem? Do I need to creat an Add-in | S*********N
发帖数: 6151 | 2
to
access
click on the buttion,
at least you can copy & paste.
check if you have included the addin needed.
$30 for a complete solution.
Email your excel with detailed requirement.
【在 f********s 的大作中提到】
: I created a VBA code in one Excel workbook. I add a button in the toolbar to
: facilitate the use. My excel version is 2007. I want to use this vba code
: in another workbook.
: However, when I open other workbook and click on the button, I can't access
: the code I created. I remember in the before when I use Excel 2003 and click on the buttion,
: Excel can open the workbook which I created and saved this Macro and then
: use it for the new version.
: How do I sovle this problem? Do I need to creat an Add-in
| d*j
发帖数: 13780 | 3 ........
【在 S*********N 的大作中提到】
:
: to
: access
: click on the buttion,
: at least you can copy & paste.
: check if you have included the addin needed.
:
: $30 for a complete solution.
: Email your excel with detailed requirement.
| i****y
发帖数: 82 | 4 Application.Run(wbTarget.Name & "!Functionname", 1, 2)
to
access
click on the buttion,
【在 f********s 的大作中提到】
: I created a VBA code in one Excel workbook. I add a button in the toolbar to
: facilitate the use. My excel version is 2007. I want to use this vba code
: in another workbook.
: However, when I open other workbook and click on the button, I can't access
: the code I created. I remember in the before when I use Excel 2003 and click on the buttion,
: Excel can open the workbook which I created and saved this Macro and then
: use it for the new version.
: How do I sovle this problem? Do I need to creat an Add-in
| l**********t
发帖数: 5754 | 5 I believe you can save your macro/function as an excel add-on (xla file?), so
that you can use it in any excel files that you open, and share it with others if you like. | l******n
发帖数: 9344 | 6 too complicated
open the workbook and call it directly
so
others if you like.
【在 l**********t 的大作中提到】
: I believe you can save your macro/function as an excel add-on (xla file?), so
: that you can use it in any excel files that you open, and share it with others if you like.
| t*******z
发帖数: 606 | 7 正解
【在 i****y 的大作中提到】
: Application.Run(wbTarget.Name & "!Functionname", 1, 2)
:
: to
: access
: click on the buttion,
|
|
