Afternoon everyone,
wonder if someone could help quickly. i am trying to set a command button up to save as, and use the value of I6 as the file name. ive tried to set it up but debugger pops up. i think im only missing something small. here what i have at the moment.
Many thanks for your time
Sub Button1_Click() ThisWorkbook.SaveAs (Range(I6).Value) End Sub
Sean
Will save it in your default directory (My documents)ThisWorkbook.SaveAs Filename:=Range("I6").Value, FileFormat:=52
To pick a different folder:Dim strPath As String strPath = "C:\Path To the Folder you want\" ThisWorkbook.SaveAs Filename:=strPath & Range("I6").Value, FileFormat:=52
Last edited by Solus Rankin; 08-29-2013 at 12:23 PM. Reason: additional info
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks