Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gopal5879
Creator
Creator

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

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.  

Labels (2)
1 Solution

Accepted Solutions
gopal5879
Creator
Creator
Author

Thanks a lot Fabian

View solution in original post

3 Replies
QFabian
Specialist III
Specialist III

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
QFabian
Specialist III
Specialist III

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

QFabian
gopal5879
Creator
Creator
Author

Thanks a lot Fabian