ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I keep an Excel macro that gets transferred to Pocket Excel (https://www.excelbanter.com/excel-discussion-misc-queries/36772-how-do-i-keep-excel-macro-gets-transferred-pocket-excel.html)

Holdfast

How do I keep an Excel macro that gets transferred to Pocket Excel
 
I run a couple of macros on an Excel 2003 workbook that later gets
transferred to my Pocket PC. Data is added via Pocket Excel, then later the
wookbook is transferred back to the desktop to repeat the process. By then
of course the macros have been stripped from the file.

Is there any easy way to keep the macro with the workbook and still use the
PPC?

Currently I have to import the macro files everytime I want to use them.

Paul B

Holdfast, as you have found out pocket excel does not support macros, you
can do as you are doing now and import them each time, or you may want to
put the macros in your personal workbook so they will be available to the
file that you are using on the pocket pc

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Holdfast" wrote in message
...
I run a couple of macros on an Excel 2003 workbook that later gets
transferred to my Pocket PC. Data is added via Pocket Excel, then later

the
wookbook is transferred back to the desktop to repeat the process. By

then
of course the macros have been stripped from the file.

Is there any easy way to keep the macro with the workbook and still use

the
PPC?

Currently I have to import the macro files everytime I want to use them.





All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com