|
Just use the Excel object model!!!! To hide column A in the active worksheet, you can use this:
ActiveSheet.Cells(, 1).EntireColumn.Hidden = True
To delete it, use this:
ActiveSheet.Cells(, 1).EntireColumn.Delete
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
|
|
|
|
|
Hey,
I have an in-proc ActiveX control I developed myself. It does not use the standard .CAB based deployment strategy,
rather - I have my own setup program, and my own version checking via a website.
Now, imagine the following:
1. User enters the website with an old ActiveX, which is loaded.
2. Website has JavaScript that loads the ActiveX, tells the user that it is old and moves him to a different page with a download link for a new setup program that contains the new ActiveX.
3. User runs the setup program, but cannot upgrade the ActiveX - the OCX is locked by Internet Explorer.
Note that during step 3 there is NO webpage which uses the ActiveX - the download page has no JavaScript at all, in fact.
Does anyone have any tips as to what I can do in such a situation?
Or, better yet, does anyone know how to force Internet Explorer to unload an OCX?
Thank you!
|
|
|
|
|
The simplest way is to restart Internet Explorer
|
|
|
|
|
Is there a way to do this without restarting Internet Explorer?
I was thinking of instantiating a specific version of the ActiveX, perhaps via AppIDs.
Is this possible?
If I do not have a specific version, I can try and spawn a "generic" ActiveX (with no specific version), and test its version.
Is this feasible?
|
|
|
|
|
As far as i know, ActiveX is a passive side.
And you can't enforce IE to unload it.
|
|
|
|
|
One of the basics of ActiveX (COM) is that you can have only one version of a component in a machine. When you register a newer version, the older version is automatically unregistered (leading to what is known as DLL hell).
|
|
|
|
|
Okay, I get it. So what do I do? A new CLSID for each version of the component?
|
|
|
|
|
Probably yes, but you are the best judge 
|
|
|
|
|
haha
Thanks, very helpful 
|
|
|
|
|
Why not mark it an answer if that really helped ?
|
|
|
|
|
Because it honestly didn't help.
What would help would be guidelines that assist me in the activity of creating updaters for ActiveX controls, etc.
Alon
|
|
|
|
|
What is your problem with restarting IE, all ActiveX controls (including those from Microsoft) are updated that way, it means there is no way to update the controls without restarting IE. Let me know if you find a way of doing it 
|
|
|
|
|
How do you measure the performance of your C++ perf-critical code ?
Are you relying on automatic profilers or do you resort, for particular reasons, to compile time methods ?
If today, profiling is still an issue to you, then I would announce to you the availablity of easy profiler at Code Project along with source code that you may give it a try for your needs.
URL :
<a href="http://www.codeproject.com/KB/cpp/easyprofiler.aspx">Easy Profiler - Compile-time Profiler for Unmanaged C++</a>[<a href="http://www.codeproject.com/KB/cpp/easyprofiler.aspx" target="_blank" title="New Window">^</a>]
Use the article-forum to raise any issue and I will be glad to help.
Easy Profiler : Now open source !
http://www.codeproject.com/KB/cpp/easyprofiler.aspx
modified on Friday, November 6, 2009 1:52 AM
|
|
|
|
|
|
message tye changed to "News" instead of "Question"
Easy Profiler : Now open source !
http://www.codeproject.com/KB/cpp/easyprofiler.aspx
|
|
|
|
|
I want to invoke exe(MFC without GUI) from windows service(COM Exe runs as service).
I am using CreateProcessAsUser and trying to invoke, it invokes(when it invokes i am writing log) but not visible in taskmanager.
I doubt that the exe is getting invoked under "SYSTEM" and that is the reason its not visible in taskmanager and nor it works(obvious).
But I want to invoke under "User"(who is logged in).
To do so I tried using LogonUser but it needs username and password of user who is logged in machine. That I cant access.
Please guide me or give me clue.
Requirement is: Exe should run under the user who is logged in.
Regards,
KTTransfer.
|
|
|
|
|
Interaction between services and user-objects is difficult to achieve and also it is not advised that you do it.
Note finally that there is a service property in the "connection tab" in the SCM interface that you may have to enable.
Good luck.
Easy Profiler : Now open source !
http://www.codeproject.com/KB/cpp/easyprofiler.aspx
|
|
|
|
|
My application uses a Word document template to develop a document. There is a table (1 row that I use for the table heading). I iterate through a datatable and add a row to the Word document table for each DataRow.
I would like to add another "heading" row to the table whenever the table crosses over to a new page. I haven't found a way to find page breaks or trap a "page break event". Is it possible to do what I want to do?
Gary Greenacre
|
|
|
|
|
To do that, you mark the header row as such by setting it's HeadingFOrmat property to True. See the documentation[^].
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
|
|
|
|
|
Hello
I'm using MS WUA api to update my computer.There are three formats patch(.exe .cab .psf) in my patch list.
I don't know what psf is. and how to install psf file. Most psf format patch files are sp patch For example, windows sp3 ,windows 2003 sp2.
I hope someone can help me answer this question.
Thanks.
Ivan
|
|
|
|
|
bingxuefly wrote: I don't know what psf is.
Try Google.
|
|
|
|
|
I have searched google, but there is no useful information.
|
|
|
|
|
bingxuefly wrote: I have searched google, but there is no useful information.
I find that difficult to understand. When I search Google for "PSF file" it returns a number of hits, the first one being a definition of PSF and other file types.
|
|
|
|
|
I have added two functions to existing COM EXE which runs as Service.
But while calling those functions from another application I am getting unhandled exception like:
Unhandled exception at 0x00000000 in xxx.exe: 0xC0000005: Access violation.
Existing functions are getting called but only new functions are not working.
I have added functions to xxx.idl and implemented in another application by including the header generated after building.
I am trying to unregister old COM EXE but its not.
Please give me clue to sort out the issue.
I am new to COM, please let me know any further info is required to look in this issue.
Regards,
KTTransfer.
modified on Monday, November 2, 2009 5:26 AM
|
|
|
|
|
You have to add this two functions to the end of your interface
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
