PC Review


Reply
Thread Tools Rate Thread

ConsolidationReference pointing to current file in xml

 
 
Kan Tong
Guest
Posts: n/a
 
      2nd Apr 2009
Hi,
I'm building XSLT files to transfomr XML data to XML Excel spreadsheet
files,

From the worksheet that I created with the XML data I am taking the data and
creating another worksheet with pivot table, the problem is that this
requiring except the source worksheet name the file name too... ?!

something like:
<ConsolidationReference>
<filename>[XSL Output.xml]Report Data</filename>
</ConsolidationReference>

The problem is that the file name is not static and it could change from
time to time... so...

Is there a way to tell Excel too look for the worksheet in the current file
? i have tried <filename>Report Data</filename> (note that "Report Data" is
the worksheet name) and it doesn't work

Is there a workaround for this problem ?

thanks very much for whoever can help
--
best regards Kan
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a ConsolidationReference default to the current workbook. semph Microsoft Excel Misc 0 6th Aug 2007 02:13 AM
Current file name in ConsolidationReference FileName =?Utf-8?B?VGFtYmk=?= Microsoft Excel Programming 3 30th Jan 2007 05:15 PM
Making a ConsolidationReference default to the current workbook. pnschofield@yahoo.com Microsoft Excel Programming 1 20th Nov 2006 08:30 PM
pointing to a pst file Rob Microsoft Outlook 2 28th Jul 2004 07:58 PM
Pointing to the current record identifier Stephan Bour Microsoft ASP .NET 1 27th Oct 2003 08:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:39 AM.