How to Declare Object Variable with Direct Memory Access?

I want to declare a variable by directly writing the declaration directly to memory. i assume we need to create in memory:

• Variable name and type info. Eg, "MyWorkbook"

I assume the variable can be created using commonly available methods such as StrPtr, VarPtr, ObjPtr, CopyMemory, etc.

Once created, then the variable could be instantiated with normal VBA (not direct memory access), using the variable-name as normal. Eg:

Code:

---

Set MyWorkbook = Workbooks(2)

---

Assume 64-bit (PtrSafe declarations etc)
Office 2016

Might be impossible, but Why?

Quote:

---

Originally Posted by Paul_Hossler

Might be impossible, but Why?

---

Power, speed, flexibility, ability to declare variables with strings, ability to declare variables in immediate pane, unknown future applications. To expand my skillset.

Also asked at
https://stackoverflow.com/questions/...-memory-access

Use With ... End With instead of Set.

Quote:

---

Originally Posted by snb

Use With ... End With instead of Set.

---

wrong thread?

Please read again and try to understand.

Quote:

---

Originally Posted by snb

Please read again and try to understand.

---

no idea