I'm writing a stylesheet which generates XML that MS Excel can interpret. Part of this XML will be for a pivot table. My issue is that I need the pivot table to reference the current file no matter what the filename is.
pivot tables require a ConsolidationReference. In these tags I need to specify the FileName, my problem is that I can't figure out how to make the filename something that will just be the current filename. Right now the only way I can get it to work is to hard code the filename. This wont work as the user can save the file with whatever filename they wish.
Does anyone know the answer to this?
pivot tables require a ConsolidationReference. In these tags I need to specify the FileName, my problem is that I can't figure out how to make the filename something that will just be the current filename. Right now the only way I can get it to work is to hard code the filename. This wont work as the user can save the file with whatever filename they wish.
Does anyone know the answer to this?