Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks a lot Fabian
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
Hi, again, the attached files are from Qlik, old ones, but very usefull about macros.
Thanks a lot Fabian