Get instant live expert help on I need help with excel vba filename

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Need help with a VBA project - the Filename keeps coming up as an error
Solved by F. D. in 13 mins
My vba program is stopping after I give it the following command. ThisWorkbook.Sheets(s).OLEObjects.Add(Filename:=try, Link:=False, DisplayAsIcon:=False) try is set to be a string of text that link to and external pdf. It add the pdf in then the program stops.
Solved by V. B. in 23 mins
i want to set hyperlink in that i want to set filename pickup automaticaly from cell
Solved by E. W. in 20 mins
trying to increment a file name but do not want to put a number on the first filename.
Solved by E. C. in 21 mins
Hi, I am getting a compile error: Syntax error with the below excel macro on the line of "Filename". Can you please assist? Sub Splitbook() MyPath = ThisWorkbook.Sheets For Each sht In ThisWorkbook.Sheets sht.Copy ActiveSheet.Cells.Copy ActiveSheet.Cells.PasteSpecial Paste:=xlPasteValues ActiveSheet.Cells.PasteSpecial Paste:=xlPasteFormats AvticeWorkbook.SaveAs Filename := "C:\Users\matt\Desktop\LTI's" & "\" & sht.Name & ".pdf" ActiveWorkbook.Close savechanges:=False Next sht End Sub
Solved by I. S. in 15 mins