![]() UserOK: '<~~ this code is run if user proceeds with saving the file (clicks the OK button) UserCancel: '<~~ this code is run if the user cancels out the file save dialog ![]() If FlSv = False Then GoTo UserCancel Else GoTo UserOK ![]() csv but it copies it into a new workbook for a second before saving im wondering if there is a way just to copy data from the sheet as is without opening a new workbook ? the code i have is: Sub CopyToCSV()ĭateString = Format(Now(), "dd-mm-yyyy_hh-mm-ss-AM/PM") '<~~ uses current time from computer clock down to the secondįlSv = Application.GetSaveAsFilename(MyFileName, fileFilter:="CSV (Comma delimited) (*.csv), *.csv", Title:="Where should we save this?") I have a workbook that can export the working sheet to a. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |