new 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...

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...

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...

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...

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...