SaveAs Filename:=strFileName, FileFormat:=xlCSVMSDOS, CreateBackup:=False WshT.Move '<- Here we have a temporary workbook copy of the modified csv ' Now we will export back the modified csv but my feeling is you dont want toĭim wbkS As Workbook, wshS As Worksheet, wshT As Worksheet ' Do the following only if you want the macro-enabled WB to keep However you can do it the traditional way, before and after saving, if you feel more comfortable with it. I have come to the conclusion that what you want is to use the macro-enabled wb just as a utility for calculation, and you care only for updating the CSV workbook.įor simplicity, we will disable the alerts for the whole session, because the macro-enabled WB is used as a utility and we dont want the batch job to stop for any reason. In the latter you dont disable the alerts, but anyway there's no need to save again. Where, as a result, the current workbook becomes the saved workbook, and then again in the Workbook_BeforeClose.
#KUTOOLS REGISTRATION BYPASS UPDATE#
Moreover, you're doing the update to the csv twice: once in the When you call SaveAs on the macro-enabled workbook, you had already appended a worksheet to it:Īnd then you're trying to save it as csv, which is a text file with only one worksheet, so Excel complains that you will loose information.
#KUTOOLS REGISTRATION BYPASS CODE#
The problems in your code are due to the following. Private Sub Workbook_BeforeClose(Cancel As Boolean) "W:\Webshare\Documents Acquired in 2017\Jim Excel\snr-room-schedule.csv", FileFormat _Īpplication.DisplayAlerts = True 'RESETS DISPLAY ALERTS 'This is the area of work that we doing to the dataĪpplication.DisplayAlerts = False 'IT WORKS TO DISABLE ALERT PROMPT Set wbkS = Workbooks.Open(Filename:=strFileName) Set wshT = Worksheets.Add(After:=Worksheets(Worksheets.Count)) This code is in the TheWorkbook of the file and not a module.Ĭonst strFileName = "W:\Webshare\Documents Acquired in 2017\Jim Excel\snr-room-schedule.csv" Here is the code I am using in VBA to do the work, as well as the other subs I found that were suppose to help me suppress the prompt.
I am opening a CSV file into EXCEL make some changes and then want to save the results back to the same file name and the CSV format.
I looked this topic up and found some help but the suggestions do not seem to be working.
0 kommentar(er)
