| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - How to "execute" a dynamic variable assignment
GS wrote:
Good reply! Wasn't thinking about adding to a VBA project... In this case the entire module code could be written in a single column, then exported to a .bas, then imported into a VBA project. The page I linked to shows that exporting to a .bas is an unnecessary step. IIRC it can also be done via the VBScript runtime using eval() -- but it looks like that function may have been removed from Win7 (at least) because I can't get it to work here, even in a .vbs file... and I don't really care enough to continue investigating. -- Unless you're driving a f%*%$)g battleship, the train is ALWAYS going to win. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Formula to "Adjust" to New Column Assignment | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| When Using Format(Now(), "yyyymmmddhhmm") get wrong number of arguments or invalid property assignment Error | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Threaded Mode
