VBA question

[STIRRELL]

Hi all,
I know a very little VBA and I am stuck on this bit of code.
I have a workbook called NTCT_EXPENSE_PAYROLL.xlsm
the spreadsheet name is CSV_FILE

I am trying to automate exporting this spreadsheet to a folder on the C: drive as a CSV file. The folder name is EXPORT
but excel does not like:


wbkExport.SaveAs Filename:="C:\EXPORT.7J1", FileFormat:=xlCSV


Can you help with the correct code to export the spreadsheet named CSV_File to a folder on my C drive named EXPORT? I was also trying to name the file 7J1 ( the payroll batch name)


Please help,
Sharon

I found the code below
Dim NTCT_EXPENSE_PAYROLL As Workbook
Dim CSV_FILE As Worksheet

Set shtToExport = ThisWorkbook.Worksheets("CSV_FILE") 'Sheet to export as CSV
Set wbkExport = Application.Workbooks.Add
shtToExport.Copy Before:=wbkExport.Worksheets(wbkExport.Worksheets.Count)
Application.DisplayAlerts = False 'Possibly overwrite without asking
wbkExport.SaveAs Filename:="C:\EXPORT.7J1", FileFormat:=xlCSV
Application.DisplayAlerts = True
wbkExport.Close SaveChanges:=False

 

[kevin9999]

I'll assume that you want to call your saved sheet "7J1" and not "EXPORT.7J1"

ThisWorkbook.Sheets("CSV_File").Copy
ActiveWorkbook.SaveAs "C:\EXPORT\7J1.csv", FileFormat:=6

 

[STIRRELL]

Thank you so much. I had used a period when I needed a \. it worked perfectly. thank you so much. it worked perfectly

 

[kevin9999]

Thank you so much. I had used a period when I needed a \. it worked perfectly. thank you so much. it worked perfectly

You're welcome, and thanks for the feedback