I have done alittle poking around on here and trying different resources that I know of and still end up with a scripting error when trying to save the open workbook.
Here is the code to call the Excel session:
Here is method one I tried that faild after trying to use information from a post on here:
Here is method two I tried that also failed after trying to immitate excel's macro recorder:
Can someone help shed some light on this?
Here is the code to call the Excel session:
Code:
Dim xlApp As Object, xlSheet As Object
Set xlApp = CreateObject("excel.application")
xlApp.Application.DisplayAlerts = False 'Turn off Warning Messages'
xlApp.Visible = True
xlApp.Workbooks.Open FileName:=" file location "
Set xlSheet = xlApp.activesheet
Here is method one I tried that faild after trying to use information from a post on here:
Code:
xlApp.displayalterts=false
xlApp.workbookobject.save
Here is method two I tried that also failed after trying to immitate excel's macro recorder:
Code:
xlApp.SaveAs Filename:= " file location ", FileFormat:=xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
Can someone help shed some light on this?