Having a subroutine write the code for a new subroutine

Sailorman Mark

New Member
Joined
Sep 11, 2002
Messages
18
I have a sub which by using InputBox will import a file then will ask what delimiter is used formatting etc and then will copy the file to a specific sheet in a workbook.
What I am trying to do is then to have it write the code for that specific situation.
I have thought about opening up a word file and when a question is answered having it copy the specific code to that file and then copying the entire contents to a module. I am fairly new at this and need some direction. Any suggestions would be appreciated.

Thanks
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Corticus

Well-known Member
Joined
Apr 30, 2002
Messages
1,579
I don't think this can be done...
(I shouldn't say that, someone will prove me wrong)

But if you could, it would seem like a serious security issue in that macro viruses would just be TOO easy to write.

I'm probably wrong, though.

Corticus
 

Corticus

Well-known Member
Joined
Apr 30, 2002
Messages
1,579
eat my words...


This message was edited by Corticus on 2002-09-13 10:48
 

Watch MrExcel Video

Forum statistics

Threads
1,118,432
Messages
5,572,074
Members
412,437
Latest member
PietTheijssen
Top