I have the following problem: i have a qvw file which uses a csv to load some data. This csv file resides on the server. But the users must be able to modify the file. I used a chart with inputfields and a macro which exports the values in the chart to the csv file.
When i tested the file locally, it worked just fine. It saves the data in the csv file and after the reload the values are changed.
But when i posted it on the server and had the users test it, the macro doesn't work. The trouble is that it tries to save the file on the local machine, not on the server.
I use the following macros:
sub ExportaTabela( NumeTabela, NumeFisier, Cale) sFileName = getVariable(Cale) & NumeFisier set val = ActiveDocument.GetSheetObject(NumeTabela) val.Export sFileName , "," ' Export in CSV end sub
function getVariable(varName) set v = ActiveDocument.Variables(varName) getVariable = v.GetContent.String end function
rem ----------------------------------------------------------
sub SalveazaEstimari ActiveDocument.ClearAll true ExportaTabela "MOD_EST", "\ModificariEstimari.csv", "modificari2" end sub
The modificari2 variable has the path to the csv file.
Is it possible to change the macros so the csv file will be saved on the server?
