Need help about a macro to write to custom template excel file

[gopal5879]

Can some one help or guide me  about a macro to write to an existing custom excel file with cell having default values.

Excel cell can have list of default values TRUE/FALSE.  

[QFabian]

Hi, try this as a start :

sub edit
set appExcel = CreateObject("Excel.Application")
appExcel.Visible = true
appExcel.WorkBooks.open ("C:\Users\Fabian\Desktop\excel to edit.xlsx")
appExcel.ActiveSheet.Cells(1,1).Activate
appExcel.ActiveCell.FormulaR1C1 = "TRUE"
appExcel.ActiveWorkbook.SaveAs "C:\Users\Fabian\Desktop\edited excel.xlsx"
appExcel.Quit
end sub

[QFabian]

Hi, again, the attached files are from Qlik, old ones, but very usefull about macros.

[gopal5879 · Accepted solution]

Thanks a lot Fabian