saving PowerPoint in excel vb using cell values

J

Jeff

This is the way I save a workbook
How can I save my Powerpoint file using excel VB

Sub SAVE()

Sheets("FORM").Visible = False

FileName = Sheets("form").Range("A8").Value
SubDir = Sheets("form").Range("A7").Value
fileSaveName = SubDir & "\" & FileName
Activeworkbook.SaveAs FileName:=fileSaveName
 

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

Similar Threads

Run Time Error on trying to save workbook 14
save as cell A1 to to a specific drive 3
Word macro that can call cells out of Excel for a find and replace 0
vba to copy data from sale receipt to next available column in an inventory worksheet 0
vba to copy data from sale receipt to next available column in aninventory worksheet 0
command button to save 1
Button looses Macro setting when running Macro 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top