Saving a Workbook

D

Dennis

With VBA I would like to save a workbook named whatever the text is in A3. If
A3 contains 'Your IP is 68.254.161.106" I would like the Workbook to be SAVED
AS(not SAVED) as C:\temp\Your IP is 68.254.161.106.xls.

TIA....Dennis
===============
 
D

Dennis

Better yet, just have it create a null(empty) file named with the contents of
A3, ex: C:\temp\Your IP is 68.254.161.106
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top