Hey everybody,
I've been using Excel for awhile now, and recently starting using vba. I think I'm getting in over my head, but I wanted to give it a shot.
What I want to do with this macro is copy a file to the same directory using the same file name, but adding the text from an input box to the end of it with an underscore. Here it is...
Sub Macro3()
Dim strOrder As String
Dim varGetPath As Variant
strOrder = InputBox("Enter the Order number.")
varGetPath = ThisWorkbook.FullName
ThisWorkbook.SaveAs FileName:= _
("varGetpath" & "_strOrder"), FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End Sub
A couple of unexpected things are happening here. 1. The file is being saved as "varGetpath_strOrder.xlsm" and not as the file name with the inputbox text and 2. It's saving in my C:/Users/Libraries/Documents folder instead of the desktop folder it originated from. I thought it would be pretty simple to do this, but I'm sure I'm missing a good chunk of code. I'm using the new office 365.
Bookmarks