Posted
by sleepp
on Stack Overflow
See other posts from Stack Overflow
or by sleepp
Published on 2010-04-19T20:00:13Z
Indexed on
2010/04/19
20:03 UTC
Read the original article
Hit count: 181
Hi, I'm using VSTO, C#, and Excel but VBA probably applies here as well.
What's the difference between calling the Merge(missing) method on a range and setting the MergeCells property to true? Does Merge() fail more often? Thanks!
© Stack Overflow or respective owner
as seen on Super User
- Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error,
"This workbook contains Excel 4.0
macros or Excel 5.0 modules. If you
would like to…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format.
I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed.
For this web project I'm building, the server doesn't have office installed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Any ideas why this code will not work?
Workbooks.Open Filename:="C:\a.xls"
Workbooks("a.xls").Activate
Worksheets("b").Select
Dim OutputArray(10, 10)
OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value
I'm trying to run a macro in one file (unnamed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Given the following workbook events:
BeforeClose
BeforeSave
Please tell me:
- The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving.
- What happen if user cancels one of the saving…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I just installed Visual Studio 2010 yesterday. As part of that I installed VSTO 4.0. Now when I run any Office application, my VSTO 3.0 addins fail to load. The error in the event log is
Customization URI: file:///H:/PathToMyAddin/MyAddin.vsto
Exception: Customization does not have the permissions…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
hi guys,
I was wondering if there is someway to embed a Flash Shockwave Object or .SWF file in
MS Powerpoint (Presentation) 2007 and higher version. ie inside ".pptx" formats .
by embed i mean when i save the presentation,close it . i wont be needing the the .swf
file again.that way i can share…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi all,
I am trying to make a case to my bosses on why we should use VS2010 for an upcoming Excel Workbook VSTO application. I haven't used VSTO before but have used VBA. With 2010 just around the corner, I wanted to read about the improvements made to see if it was worth using 2010 to develop this…
>>> More
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
Note: Cross posted from Coding The Document.
Permalink
Sometimes in order to work with Open XML we need a little help from other tools. In this post I am going to describe a fairly simple solution for marking up PowerPoint presentations so that they can be used as templates and processed using…
>>> More
as seen on Exceptional Code
- Search for 'Exceptional Code'
If you ever find yourself troubleshooting a VSTO addin that does not load then these steps will interest you.
Do not skip the basics and check the registry at HKLM\Software\Microsoft\Office\<Application>\AddIns\<AddInName> or HKCU\Software\Microsoft\Office\<Product>\AddIns\<Application>…
>>> More
