Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In my QVW file having an TableBox object, now i am creating QVD for this Tablebox object.
I am using below macro code, but when i am using the Created QVD in another QVW file then it is not file type as QVD instead of that it is displaying Delimited.
Why it is happening ?
sub ExportTablebox
set obj = ActiveDocument.GetSheetObject("TB13")
obj.export "C:\Users\admin\Desktop\SaveQuery\test1.qvd",","
msgbox("Exported Table")
end sub
Thanks in advance
Regards
Venkat
Try ExportEx
set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportEx "C:\test.qvd", 4
You can create a qvd with a macro but it will not be optimized (its really a comma delimited file). You will have to bring the file back in through the script and then save it through the script as a QVD, this will optimize it and a "real" QVD.
Stephen
Hi sjcharles,
Thanks for your reply,
Actually i didn't got your point regarding QVD, pls can give me a little more clear explanation.
So that might be very useful to me.
Thanks in Advance
Regards
Venkat
Hi sjcharles,
From the macro code itself can i make it a real QVD.
Instead of creating like comma delimited and then getting that qvd into script. After that making a real QVD is not a better process in my task.
How can i make it a Real QVD from Macro in the first attempt itself.
I hope so you understand my requirement.
Thanks in advance.
Regards
Venkat.
Hi,
Let me Explain the whole process.
The Export and ExportEx both are used to export the data.
Now the difference is that Export command is used to export the data into delimited file, where as ExportEx is used to export data into HTML, Delimited, Image, QVD, Biff (i.e Excel).
But now problem is that You can not use the ExportEx function for tablebox, it is used only for pivot and straight table. and Export Command can be used with all three of them i.e pivot, Table and Straight table.
So Satish, in your case you are using Tablebox, thats why you are using Export and as i said it is used to export in delimited file, thus you can see it as comma seperated file. Meaning it is not in QVD format even though its has QVD as extension.
Now if you want in a proper QVD file format you need to take this Delimited file into another QVW and then use the store command in script to generate QVD out of it.
I hope it is clear to you now.
Regards,
Kaushik Solanki
Hi Kaushik,
Your post explains a clear process regarding QVD. And it helps me a lot.
Can i ask you one more question regarding same concept...
What is the main difference between ExportEx and ServerSideExportEx ?
Thanks in Advance.
Regards
Venkat
Hi,
I dont know the difference as i have never used ServerSideExportEx.
I would suggest you to use it and see the changes.
In general i think it should be used for exporting from browser.
Regards,
Kaushik Solanki
Hi,
Actually you can use the ServerSideExportEx in your case as this command is valid for Tablebox.
Try and let us know.
Regards,
Kaushik Solanki
When i use option 4 or anything (1 to 5), i get that letter(4 or anything) in csv output. I dont want it and need to have space as delimiter. please help.
Thanks,
Karthi