Use OLE
-
To preview xls file i call CreateFromFile or CreateFromClipboard and it works But if xls file has password and i do not enter it then my program hangs. It gives switch to/retry message. Is there any way to solve this problem
MKC002 wrote:
Is there any way to solve this problem
How about using Excel automation instead (where the password can be provided to the
Openfunction)?"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
-
MKC002 wrote:
Is there any way to solve this problem
How about using Excel automation instead (where the password can be provided to the
Openfunction)?"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
-
Ok, so what's the problem?
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
-
Ok, so what's the problem?
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
CreateFromFile hangs my program. If excel file contains some password and i call CreateFromFile for that file, it asks me to enter password. If i click on cancel button and do not enter the password then my program hangs. It gives retry/switch-to message. How to solve this problem.
-
CreateFromFile hangs my program. If excel file contains some password and i call CreateFromFile for that file, it asks me to enter password. If i click on cancel button and do not enter the password then my program hangs. It gives retry/switch-to message. How to solve this problem.
MKC002 wrote:
How to solve this problem.
Use Excel automation instead, where the password can be provided to the
Open()function."One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
-
MKC002 wrote:
How to solve this problem.
Use Excel automation instead, where the password can be provided to the
Open()function."One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
-
I want to open excel file contents in my own window, not in excel window. Is that possible with excel automation?
MKC002 wrote:
Is that possible with excel automation?
Yes.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
-
MKC002 wrote:
Is that possible with excel automation?
Yes.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
-
Thanks for confirmation Is there any example available in VC++ Can you please give some link
MKC002 wrote:
Is there any example available in VC++
Can you please give some linkGoogle produced the following: http://support.microsoft.com/kb/216686[^] http://support.microsoft.com/kb/196776/[^] http://code.msdn.microsoft.com/office/CppAutomateExcel-be36992e[^]
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous