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

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,216,075
Messages
6,128,668
Members
449,463
Latest member
Jojomen56

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