AboutPricing

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.
< Go Back

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

    Need help with a VBA project - the workbok.open 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