• How To Name A File In Vba

How To Name A File In Vba

I am looking for VBA to add to my macro that will increment the file name if the file name already exists.Current Code: Dim filepath As StringDim filename As StringDim filepatharch As StringDim filedate As StringDim filelist As String'Grab FROM list numberSheets('TD File').SelectRange('G4').Selectfilelist = ActiveCell.Value'Grab today's datefiledate = Format(Now, 'MMDD01.'

Hi guys, totally new to Open Office as I have changed jobs and my new employer uses it. I am having a bit of trouble with Calc as there was a Macro that I had in VBA for Excel that allowed you to double click on any cell to increase the value of the cell by 1. I got an error saying BASIC syntax error. Expected SubThis is what the code looked like after I installed it.