GREP software for EXCEL integration

renovator

New Member
Joined
May 6, 2016
Messages
9
[h=1]i am using a GREP application to search for data in files that match a criteria and I want to get the results into EXCEL
Can i drag and drop or can i pass a selection back from a file to EXCEL?

Also does it matter if the file is already open (Highlight a file on an already open Windows Explorer window
AND
Can i get the the file attributes at the same time (Need VBA Help regarding windows explorer) or do i have to a seperate procedure[/h][h=1]I had a look and found these
Options for file explorer
Open Explorer and add file name in cell
Select file from VBA using Windows File Explorer
Paste file name and extension using file explorer

Outlook
Userform TreeView - Drag and Drop files from Explorer and Outlook attachements

Ancient suggestions
Drag and Drop file to userform
Drag and Drop from Windows Explorer into Userform or Listbox[/h]
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,896
Messages
6,175,259
Members
452,626
Latest member
huntinghunter

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top