Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Include file
I have several type definitions and variable declarations that I want to
reuse. Can I store these definitions in a file and include it in VBA like you do with C? include <stdio.h I have several spreadsheets that reuse the definitions and I reguarly have changes. Instead of creating /modifying spreadsheets all I would need to do is modify the include. Thanks in advance for you help. Guy Normandeau |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Include file
im not 100% sure but i think the closest thing VBA has to this is Module. Put your reusable stuff in a module which can be imported into and use by any vb project:confused -- bail ----------------------------------------------------------------------- bails's Profile: http://www.excelforum.com/member.php...fo&userid=3615 View this thread: http://www.excelforum.com/showthread.php?threadid=55944 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Include file
Guy,
You can make them Public and put in Personal.xls so they are available whenever you open Excel. NickHK "Guy Normandeau" ... I have several type definitions and variable declarations that I want to reuse. Can I store these definitions in a file and include it in VBA like you do with C? include <stdio.h I have several spreadsheets that reuse the definitions and I reguarly have changes. Instead of creating /modifying spreadsheets all I would need to do is modify the include. Thanks in advance for you help. Guy Normandeau |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set the save default not to include .xls in name of file | Excel Discussion (Misc queries) | |||
How do I include file name and path in the header? | Excel Discussion (Misc queries) | |||
include VBA macros as text file | Excel Programming | |||
Include external file .BAS in Excel VBA | Excel Programming | |||
Include external file .BAS in Excel VBA | Excel Programming |