How would I go about doing something like this in VBA?
Let's say we have an active worksheet containing the following:
A B 1 foo1 Hello1 2 foo2 Hi2
Given that, I want to be able to create a folder in my desktop called "test" and within that folder create two excel workbooks. The first workbook will be named "foo1" and contains "Hello1" in cell A1, and the second workbook will be named "foo2" and contains "Hi2" in cell A1?
Thanks!
Bookmarks