Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Include external file .BAS in Excel VBA
Can i load external .BAS file, with some kind of include or import? I use this way to get control over the code. Tks in Advance! Rafael Porche -- locoloc ----------------------------------------------------------------------- locoloco's Profile: http://www.excelforum.com/member.php...fo&userid=1551 View this thread: http://www.excelforum.com/showthread.php?threadid=27084 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Include external file .BAS in Excel VBA
In VB editor you can right click on the project and select Import File. This allows you to get a .bas into your project. It should work as lon as none of the code uses commands not included with VBA (i.e. VB onl commands). Not sure whether the module is saved again with the spreadsheet o whether it stays where you found it though. Probably with th spreadsheet, but you should check. -- kkkni ----------------------------------------------------------------------- kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754 View this thread: http://www.excelforum.com/showthread.php?threadid=27084 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Include external file .BAS in Excel VBA
Sub AddCode()
ThisWorkbook.VBProject.VBComponents.Import _ FileName:="Y:\Docs\bovey\modAPIPlaySoundA.bas" End Sub -- Regards, Tom Ogilvy "locoloco" wrote in message ... Can i load external .BAS file, with some kind of include or import? I use this way to get control over the code. Tks in Advance! Rafael Porcher -- locoloco ------------------------------------------------------------------------ locoloco's Profile: http://www.excelforum.com/member.php...o&userid=15511 View this thread: http://www.excelforum.com/showthread...hreadid=270842 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I include file properties in an excel spreadsheet | Excel Discussion (Misc queries) | |||
Include password in formula that links to a protected excel file | Excel Discussion (Misc queries) | |||
how to include fonts file in excel document to send outside? | Excel Discussion (Misc queries) | |||
How do I include a supporting help file for a excel function? | Excel Worksheet Functions | |||
How can I include bmp file in excel 2000 header? | Excel Worksheet Functions |