Embedding code withing Excel macros

[Jenney_g]

Hello,

I am looking for a way to embed or insert an small executable program or
code within an Excel macro so that I could extract the payload from the
spreadsheet on another system later on. I have a little experience
writing VBA scripts for Excel but I know no way of doing this - can
anyone help?

Thanks,

Jennifer G

 

[Kalle]

there a some different approaches to that, depending from your little
program.
What does this little programm do? Which language was used writing it?
and what do mean with "payload of the sheet?

kalle

 

[Jenney_g]

Hi kalle,

The embedded payload will be C code or the executable of the C code.
The C program that I wrote checks on the overall security setup of Excel
on the system. By payload of the sheet, I mean to say, if there is
embedded C code or executable in my macro, how do I then extract it to
run it later?

Thanks,

Jennifer

 

[Stephen Bullen]

Hi Jenney_g,

The embedded payload will be C code or the executable of the C code.
The C program that I wrote checks on the overall security setup of Excel
on the system. By payload of the sheet, I mean to say, if there is
embedded C code or executable in my macro, how do I then extract it to
run it later?

Just out of interest, how does that differ from a virus?

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie