Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Export query as Excel by script

Created by: b.kiyoshi at: 5/24/2019 3:14 PM (6 Replies)

Rating (2)

Thanks 2

7 Entries

5/24/2019 3:14 PM	Rate (0)
b.kiyoshi Posts: 44 Rating: (6)	Hello guys, is there a way to export queries to Excel files by script? Couldn't find anything on the documentation. Regards,
b.kiyoshi Posts: 44 Rating: (6)
Suggestion To thank Quote Answer

5/24/2019 3:24 PM	Rate (2)
J.J. Advanced Member Joined: 1/21/2014 Last visit: 10/7/2024 Posts: 17 Rating: (12)	Hello Kiyoshi, Hereby an example. You can test this in the "Object debugger" where "object A" will be your query. Best regards, Jethro Set objDocQuery = A Set MyTopQuery = objDocQuery.XObj.TopQuery strFullFilePath = "C:/ your path including file name .xlsx" strTableName = "Query" 'can also be something else qeExportType=1 'qcExportTypeTxt = 0, qcExportTypeXls = 1, qcExportTypeXml = 2, qcExportTypeMdb = 3 MyTopQuery.Execute MyTopQuery.Query.ExportData qeExportType,strFullFilePath, strTableName
	Last edited by: J.J. at: 05/24/2019 15:27:12
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users AutoGen_4490593

5/24/2019 10:43 PM	Rate (0)
b.kiyoshi Posts: 44 Rating: (6)	I've just tested your code and it works perfectly! Thank you!
b.kiyoshi Posts: 44 Rating: (6)
Suggestion To thank Quote Answer

5/10/2022 9:30 AM	Rate (0)
LucaSum Posts: 10 Rating: (0)	Hello Guys I found your script while searching for such a solution. I would like to adjust the script so i can run it directly from the query. In would like to start an export to excel directly from the scriptblock of the query. I tried to set the query as object, instead of A. But so far i didnt found a way to get this working.. Is there a possibilty so set the current query as object in the query script? So it should look like this, but the first line "Set objDocQuery = Query" does not work like this.. Sub Action(Query, QueryBrowser) Set objDocQuery = Query Set MyTopQuery = objDocQuery.XObj.TopQuery strFullFilePath = "C:/ your path including file name .xlsx" strTableName = "Query" 'can also be something else qeExportType=1 'qcExportTypeTxt = 0, qcExportTypeXls = 1, qcExportTypeXml = 2, qcExportTypeMdb = 3 MyTopQuery.Execute MyTopQuery.Query.ExportData qeExportType,strFullFilePath, strTableName End Sub Would be lovely if someone can support me with this. Best Regards
LucaSum Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

5/10/2022 9:42 AM	Rate (0)
anmoser Bronze Member Joined: 5/9/2018 Last visit: 9/17/2025 Posts: 8 Rating: (6)	Hello LucaSum, try this: Sub Action(Query, QueryBrowser) Set objDocQuery = Query Set MyTopQuery =objDocQuery.Owner strFullFilePath = "C:/ your path including file name .xlsx" strTableName = "Query" 'can also be something else qeExportType=1 'qcExportTypeTxt = 0, qcExportTypeXls = 1, qcExportTypeXml = 2, qcExportTypeMdb = 3 MyTopQuery.Execute MyTopQuery.Query.ExportData qeExportType,strFullFilePath, strTableName End Sub KR

Suggestion To thank Quote Answer

5/11/2022 7:33 AM	Rate (0)
LucaSum Posts: 10 Rating: (0)	Thanks a lot for your help. Works perfekt like this! Thanks and have a wonderful day..
LucaSum Posts: 10 Rating: (0)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Jen_Moderator

10/17/2024 8:43 AM	Rate (0)
Thorium Experienced Member Joined: 2/14/2012 Last visit: 11/28/2025 Posts: 98 Rating: (22)	Hello LucaSum This works very well indeed. Is there also a way to reimport by script? Thanks a lot Th.

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on