variable folder save

  1. D

    Exporting data to Text (Tab Delimited)

    Hi All, I am Trying to export a particular sheet to Text (Tab Delimited) File. The path to save the file and the name of the text file should be selected by the user. I tried searching in internet and i am Fed up on this. I tried the below code but the whole workbook is getting saved in the...
  2. C

    VBA to Find CSV Files in Folder by Current Month

    Hi, I'm trying to get VBA to find the current month folder on a given file path then open all ".csv" items in that folder. I had code that die something similar with in a given folder. Now the folder is a variable. If I put "March" in the file path it finds it and opens it obviously. What...
  3. N

    User to select variable folder for saving files

    Hi I hope someone can help. I've searched through other posts but either can't find the same scenario as mine or I'm not looking properly. :confused: I would like my macro to prompt the user to select a folder for files to be either opened from or saved to during the running of my macro...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top