new file

  1. A

    VBA to copy autoflitered data to another file

    Hi All, Can someone please help me with the following issue: VBA will open file Kenneth.xlsx. In this file the filtered data has to be copied into. This file has several sheets (all sheets have a unique name). Based on the filtered data from “working”file “In Macro V 1.xlsm”, data has to copy...
  2. H

    How to create a word document from excel

    Hi, everybody! (and thanks in advance...) I have a spreadsheet and I want to, by running a macro, create a new word file named after the active cell and based on a specific template. I am trying the code bellow, withouth success. Can someone please help me? I also have a question, after...
  3. M

    Excel VBA to Export individual cells to *.txt file

    Hi all! This is my first post so bare with me ;) I need some help with a VBA to export the value in all the cells from Column G into individual .txt files. The name of the text should be "Answer" Value in Column A. It all needs to be saved in the same directory as the Excel file itself. What I...
  4. R

    VBA separate rows with the same style into different workbooks

    What I want to do is to take a list of styles on a worksheet and separate the styles (denoted by the number in the "style #" column into multiple workbooks with the same header row. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> So I would...

    unwanted book1 file keeps opening

    hello, haven't posted in a while. In excel 2007, whenever I open a file; I get a book1.xlsx file opened up for no particular reason. This has become very annoying and I don't that I did this with any settings that I might have unknowingly changed. is there anyway to solve this? hope I was...

Some videos you may like

This Week's Hot Topics