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...
I want to use VBA in Excel to have a dialog box to open. Ideally, a windows file explorer would open and the user would find the path and file to select. I want Excel to only take the file name and path and store it in variables. From there I would like to be able to extract cells from that...
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.