saveas filename

I'm using VBA to take the contents of a certain range an output it as a text file. The file is actually XML data for upload to another system, so the text file has to have a specific extension, "filename.nrc". I originally designed it to always save to the Documents folders in the users local...

Hi all, I have a template with four sheets with name "main", "part 1", "part 2", "part 3" After i put in info in sheet part 1, part 2 , part3, i would like to save the sheets into a new workbook (all sheets in the same workbook) i came up with a VBA code but it only manage to save sheet part 3...

Hit type mismatch error at the saveas filename row , and i believe its because there is a mixture of string and integer for the variable in the filename. Can anyone advice on this? Dim prd as string, dept as string, yrs as integer prd=ThisWorkbook.Sheets("Main").Range("I10").value...

Hi there. I've been googling all morning trying to figure this out, and I've looked at the MS help among other forums but no luck. I want to save a workbook to a specific network path and also save it under a filename with the variable ID and " - Account Overview" (e.g. "012345678 - Account...

Hi All, I am having a problem with save filename. I am attempting to export two worksheets (Assignment Template & Exported Sheet) from a workbook to a new workbook, printout the sheets then save the workbook to a specific location. The issue is that I encounter an error on this line of code...