Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can vba import code to vba project ?
OK. There must be a gas leak in the house & i'm not thinking straight, but i have an idea regarding VBA security i'd like y'all to gun down just so i don't spend hours tinkering and bombaring this place with questions...
It seems that VBA be used to add code to a given module from an external file ie .txt or formal .bas etc If (and it is a very big if) the importing procedure involved actual processing of the data on-the-fly, then core code could be stored in an encrypted external file & imported at runtime and decrypted on the fly (i think there is even a blowfish class for excel around etc). ( Obviously, this sort of flight of fancy would only come to someone who has no idea how to convert a multi-module / form VBA system into a COM / VB app ! ) If code can't be appended, end of discussion. If it can, i suggested on-the-fly decryption as i assumed that "garbage" in would cause some compile errors before the decrpyt system could correct it... it may need to be imported to a blank sheet, decrpyted there and then copied to code - on-the-fly decryption will only work for a few algorythms now i think about it (ie MD5 would need whole string to parse for it to work) Any comments ? (be gentle - i'll start things with "learn VB...") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import from MS Project? | Excel Discussion (Misc queries) | |||
How do I import a date from a project scehdule task into excel? | Excel Worksheet Functions | |||
How do I import MS Project data into Excel? | Excel Discussion (Misc queries) | |||
How do I import MS Project data into Excel? | Excel Discussion (Misc queries) | |||
VBA-How to insert vba code file in a project using coding rather than manual import | Excel Programming |