i want to use Excel.Workbook library as a saveAs but i couldn’t locate the where it should save just giving the name of the excel and saving in te documents.
My Code :
NOT : xlsWB as an Excel.Workbook
setFileName as a String = “myExcel”
What a want is => setFileName = “C:\myExcel” when i do like this it gets me an error.
=> “exception has been thrown by the target of an invocation”
How can i set the location?
Have you try with full path and file name.
It creates files in your project location.
As per my understanding if you just provide the file path it may get saved to the folder path.
Its better to give the full path of the file to save it to the required folder.
You need to provide an Extension to your file in the path.
Hi @Rahul_Unnikrishnan @raja.arslankhan @Gokul_Jayakumar
thx for responses.
What i did is putting the .xls after the naming the document, i’had never done that because i though this code => XlFileFormat.xlWorkbookNormal should had do that. so…
Thanks for help.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.