Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel Macro: Create XLS from Cell

Comment:

Hello, I'am trying to create files from a table. All I'm able to do so far is create files by manually selecting the cell I want. How can I have it create them from an entire range of cells? This is the code I'm using: Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub

Name: Razor2.3
Date: April 15, 2009 at 06:09:11 Pacific

Reply:

Untested: Public Sub SaveAsA1() For Each c In ActiveSheet.Range("A1:A20") ActiveWorkbook.SaveAs Filename:=c.Value Next 'c End Sub

0

Find and Delete Folders u...

[C++] Smtp Console To Dae...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hello: Is it possible to execute an excel macro based on condition of a cell? ...

Summary: Hello all, long time since ive posted, need some help from you guys again please. i have made an excel macro, on the excel page you have a drop down menu which you can use to select an option from. Wh...

Summary: hello, i am writting a macro in Excel, i have a merged cell C43 and C44, now in my code i want to unlock this merged cell but i get an error, how do i reference a cell which has been merged? Thanks, ...