Visual Studio Error Code -2146827284 SaveAs to Excel

[PWD]

Good afternoon, I'm not sure if this is the correct place or not to pose this question.
I have inherited a Visual Studio project from a colleague who has left the company. Part of it involves saving a file. When I get to here:-

.ActiveWorkbook.SaveAs(Filename:=strGPath & strBook(j) & "\" & strLogin & "_" & strRename(j) & ".xls", FileFormat:=Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Password _
:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:= _
False)

I get

COMException was unhandled
Exception from HRESULT: 0x800A03EC

I've not changed anything on the script; the only thing that may be different is that I had to choose a scripting language when I ran Visual Studio for the first time & I chose 'General'.

The 'Call Stack' is this:-

> j246809_excel.exe!j246809_excel.Form1.Form1_Load(Object sender = {j246809_excel.Form1}, System.EventArgs e = {System.EventArgs}) Line 195 Basic

I am running MS Office Professional Plus 2010.

Many thanks,
D€$

 

[SkipVought]

hi,

Whay are you saving as an .xls (Excel 97-2003 format)????

Is this VB.net code? forum796.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PWD]

Hi Skip, this is just how it was. I'm more than happy to save as xlsx or any other format, I just need to get the code working to create these output files.

This is in Visual Studio - hence my uncertainty where to post.

Many thanks,
D€$

 

[PWD]

Doofus me!!!!

 strBook(j)

were sub-folders that didn't exist. Nice error messaging though - NOT.

Many thanks,
D€$

 

[SkipVought]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}