Saving file

[agyna]

Hello,

I need some quick help. I am having trouble saving this file after I grab the data from the test. I need to use it tomorrow. Can someone really help me. I am havin error with the "save report" vi.

[Bob_Schor]

Your code was close (but I might have already "repaired the incompatibility with Office 2016".  When I ran your code, the main problem was that there was no Report File Path wired into Save Report to File.  There was also no "Dispose Report", and the Error Wire wasn't connected (making it harder to tell where/if there was an error).  I'm attaching a Snippet showing my (trivial) modifications to your VI that make it run without error, putting data in a "strange place", i.e. a column starting at Cell D27 (row 26, column 3, "as you ordered").

Microsoft did pull a fast one, and added an extra property in a deep function called by "Save Report to File".  The fix has been published many times here in the Forums, and as I said before, I might have already fixed my own copy.  If you still get an error, search here in the Forum and you'll find the fix (or post updated code that you updated after reading this reply).Save Report to Excel

Bob Schor

You'll notice I deleted "default" constants to keep the code a little neater.