Store Macro through C#

Question

I wanted to write a macro and run it from C#. The
following is the code.

Microsoft.Vbe.Interop.VBProject vbp = new Microsoft.Vbe.Interop.VBProject();
Microsoft.Vbe.Interop.VBComponent vbc = vbp.VBComponents.Add(Microsoft.Vbe.Interop.vbext_ComponentType.vbext_ct_StdModule);

StringBuilder sb = new StringBuilder();
sb.Append("Sub FormatSheet()" + "\n");
sb.Append(" Selection.Find.Text= 'A-Gen'" + "\n");
sb.Append(" Selection.Find.Execute(ref fndtext, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing)" + "\n");
sb.Append(" Selection.Range.Paragraphs.OutlineLevel = Microsoft.Office.Interop.Word.WdOutlineLevel.wdOutlineLevel1");
sb.Append("End Sub");

string sCode = sb.ToString();
vbc.CodeModule.AddFromString(sCode);


But it shows the error as
{"Retrieving the COM class factory for component with CLSID {0002E169-0000-0000-C000-000000000046} failed due to the following error: 80040154."}


Thanks in advance for any help!

Answer 1

If not using server on session, then you can use cookies on client side

but I fail to understand why you don't want to use session? it helps in managing user requests in betterway. what you want to achieve by not using session? 

Answer 2

if you have memory issues, then instead of storing session in-proc (in memory),you can store the session in database server. this way ur memory will not be occupied by session

if at all you dont want to use session, then you can maintain user data using cookies or using query string

Answer 3

1000 concerent users is nothing, even the sites with millions of concerent users implement sessions

it depends on what resources you have

are you going to host by your own? or on cloud?

 

it will be better if you provide all the info. together while posting question, instead of writing bits and pieces in different replies 

Answer 4

You think it as 1000 concerent users.

 Then.......?

Answer 5

Huge user , memory issue

 

However cookies are not safe.