Create new excel from data
Hi I was trying to create an XL using some data in script but failed following are my coding please help me correcting it Sub Main Dim fileName, sheetName fileName ="C:...
Forum Discussion
you are creating a new excel by using 'save as' method....but u r opening non existent sheet ....... by default excel will create a sheet name as 'sheet1'. so try
sheetName ="sheet1"
function
Set sste = book.Sheets(sname)
End function
sheetName ="sheet1"
function
Set sste = book.Sheets(sname)
End function
