Posted
by jwarzech
on Super User
See other posts from Super User
or by jwarzech
Published on 2009-10-05T14:08:45Z
Indexed on
2010/04/10
10:03 UTC
Read the original article
Hit count: 292
Can Excel 2007 use an external xml file as the connection for a pivot table? I am able to filter the dialog by xml when specifying a type of data however I get an error saying that it is not a valid datasource.
© Super User 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 am writing a blackberry application where i want to store the
data returned by a web service in my BB device.Earlier i was going to
use SQLite for storing the data in mobile but as i googled and also did programming using SQLite and found
that some BB devices dont support SQLite library and fail…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a requirement where a user is typing in XML in a text area, and I want to show the various nodes in a tree...But as the user is typing in the xml, it wont be a complete xml (since he is still typing in the XML)... How do I read an incomplete XML and correctly generate the tree? I understand…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
How can I use XMLParser to get the item-@url, item-@replace and item-"value inside"
for the content as a string of the node where item-@cone="one"?
<cstep>
<item cone="one"
url="http://google.com/{ccc}/cthree"
replace="{ccc}">
<itemsub conesub="conesub">
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is part 1 of our problem (Loading a dynamically generated XML file as PHP in Flash).
Now we were able to get Flash to read the XML file, but we can only see the Flash render correctly when tested(test movie) from the actual Flash program. However, when we upload our files online to preview the…
>>> More
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
Today, we are not only announcing Sample Browser v2 CTP, but we are also excited to announce the availability of RSS feeds of All-In-One Code Framework code samples. By using these feeds, you can easily track and download the new code samples.
English RSS feeds
All code samples: http://support…
>>> More
