filetype

  1. R

    VBA to hardcode directory and import text file

    I need a way to have VBA handle two things. - Hardcode a file directory (e.g.,C:\Users\Public\abc123) for the user to select only text files. - One the file is selected, import it into Excel. The file would be a comma delimited text file. The code will only allow imports for the text file and...
  2. M

    Vba - remove filetype (.xlsm) when using 'activeworkbook.saveas'

    Good Morning, I have a macro which takes an existing workbook, makes changes to said workbook and saves a copy of the workbook adding to the existing filename. The code I currently have takes the existing workbook name including the filetype and then adds the following on the end " -...
  3. RobbieC

    VBA Vlookup to return value LEFT of table

    I posted this up a few minutes ago, but for some reason the post fails when you click on it...I didn't put anything spurious in there...very strange I'm basically able to do a VLOOKUP in VBA using: filetype = Application.WorksheetFunction.VLookup(filename...
  4. B

    VBA - Transpose and xlPasteValues from multiple excel files to master

    Hi All, Basically I am trying to copy hundreds of new files weekly into one Master. Each file (see https://ufile.io/bh1z1) has a "GPI" sheet with data in D4:D300, which I need to transpose and paste as values into a Master. I have hit some roadblocks with my current code. It is running but...
  5. P

    Modify to Change Paste to Rows Verses Columns

    I found this excellent code on this site and it works great. What do I need to do when copying from the source documents to paste the information into rows rather than columns? The first row would be Row 4 and then go down by 1 row each time until completed. Sub FolderCrawler() FileType =...
    • Papi
    • Thread
    • curr_file file filetype outputcol row
    • Replies: 7
    • Forum: Excel Questions
  6. V

    Recover renamed files

    My 8 year old has ruined my day. He denies it, but someone renamed all the files and folders on my data drive with a utility. I think he was trying to rename mp3's. Now, I know there must be a way to recover the filetypes. The files I am after are mostly excel files and excel addons, the rest...

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