Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting VB files
I am trying to export some files from my personal.xls spreadsheet so
that they can be imported on other PC's. I can successfully export & import both modules and class modules, but when I export a workbook it saves it as a class and then imports it as a class. Any ideas? Thanks, Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting VB files
Hi Rob,
Rather than overwriting someone else's Personal.xls file, try creating and distrubuting an add-in. For the creation, distribution and installation of an add-in, see Jan Karel Pieterse's tutorial Create Addins http://www.jkp-ads.com/Articles/DistributeMacro00.htm --- Regards, Norman Microsoft Excel MVP "RobH" wrote in message oups.com... I am trying to export some files from my personal.xls spreadsheet so that they can be imported on other PC's. I can successfully export & import both modules and class modules, but when I export a workbook it saves it as a class and then imports it as a class. Any ideas? Thanks, Rob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting VB files
I looked at using an add-in, but the code which worked fine in
personal.xls did not run correclty when using an add in instead. Hence looking at the import and export process for the roll-out. Rob |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting VB files
Hi Rob,
Can you give an example of a procedure which does not run correctly in an add-in? --- Regards, Norman "RobH" wrote in message oups.com... I looked at using an add-in, but the code which worked fine in personal.xls did not run correclty when using an add in instead. Hence looking at the import and export process for the roll-out. Rob |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting VB files
For details see a previous post on this forum from a couple of days
ago, entitled 'Run-time error 9 when running add-in' Rob |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting VB files
Alternatively, give the workbook a unique name (RobsBook.xls) and place it
in each user's xlstart directory. It will open when Excel opens, but will not overwrite anyone's personal.xls. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Norman Jones" wrote in message ... Hi Rob, Rather than overwriting someone else's Personal.xls file, try creating and distrubuting an add-in. For the creation, distribution and installation of an add-in, see Jan Karel Pieterse's tutorial Create Addins http://www.jkp-ads.com/Articles/DistributeMacro00.htm --- Regards, Norman Microsoft Excel MVP "RobH" wrote in message oups.com... I am trying to export some files from my personal.xls spreadsheet so that they can be imported on other PC's. I can successfully export & import both modules and class modules, but when I export a workbook it saves it as a class and then imports it as a class. Any ideas? Thanks, Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting to seperate .ini files | Excel Discussion (Misc queries) | |||
EXPORTING EXCEL FILES | New Users to Excel | |||
Exporting CSV Files | Excel Programming | |||
Exporting to several xls files | Excel Programming | |||
Exporting CSV files | Excel Programming |