Filter excel files...only files with connection (Linked to power query)

[gazmoz17]

Hi,

Is the above possible? I use Search everything with autohotkey, as I find it easier using with autohotkey shortcuts than filter/bookmark shortcuts in program itself.

So shift x (for eXcel etc, shift w for word docs) will send the below:

everything excel.PNG (7.59 KiB) Viewed 3421 times

Now most of the time my workbooks with connections (power query) will be macro enabled xlsm files (as habitually I'll use macros with power query). Yet not always the case....is there any identifier to only show excel workbooks with connections. So can filter.

Currently my work around is a naming convention, just a "Q" for query at end of each filename with a connection ...even more sophistcated work around would be welcome.

Many Thanks
Gareth

[void]

Currently, no, sorry.

[gazmoz17]

No prob thanks for reply.

Only just discovered the below when saving files .

Add category.PNG (3.73 KiB) Viewed 3405 times

If I save via category and put a Q marker,...whats the syntax for searching via category?....so I can bookmark.

Thanks

[gazmoz17]

Is there any other 3rd party that can detect an excel connection and filter based on this?

Would keep Search Everything as my default and use alternative if avail just for excel files.

Thanks

[void]

It's possible.

Please try the following:

Search for an xlsx file with connection (Linked to power query)

For example:

"decant Record .xlsx"

Right click the result list column header and click Add columns....
On the left, click Windows Property System
Right click the property list column header and check Preview.
Examine each available property and value.

Third party property handlers can be installed.

[gazmoz17]

Hi, thanks for the reply. Wow didnt realise how many options there were.

I think I've looked in correct area but nothing is jumping out at me to show its an excel with connection/query?

Windows Poperty System.PNG (108.91 KiB) Viewed 3348 times

If can't be done then maybe look at vba/autohotkey method of establishing theres a connection/query and autosaving wth a "Q" tag or some other identifier.

Many Thanks

[void]

There doesn't appear to be any stock properties that shows the connection/query.

There might be third party property handlers that can show this information?

[gazmoz17]

No prob thanks for your time void...just wanted to make sure I wasnt missing anything.

Leant that add column and preview section so wasnt a waste of time.