| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to read lines of a module
I would like for a VBA macro to be able to read the lines of one of its
modules as data so that the macro can do something with. Is that possible? What follows is only a specific example. Suppose I have a module that contains: Public Const rName as String="MySheet!A" Public Const rAddr as String="MySheet!B" Public Const rDog as String="MySheet!C" I would like the macro to beable to read the above 3 lines (along with whatever else is in the module) and set row 1 (the column headers) of MySheet to: Name, Addr, and Dog Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to read all lines from a text file into cells C10:Cxxx ? | Excel Discussion (Misc queries) | |||
| Read Variable from Another Module | Excel Programming | |||
| Read lines from one worksheet, if value is true, write to new work | Excel Discussion (Misc queries) | |||
| How to read CSV lines into different Worksheets depending on a date field? | Excel Worksheet Functions | |||
| Lines in a Module(Procedure) | Excel Programming | |||
Threaded Mode
