Auto Naming Saved Files

[gingram536]

Hello World ...

So I am trying to save an XL file and am having some issues ... I have a populated array from a multimeter and need to save the data ... 

Here's the question, in my front panel I have the user enter a Lot # & a Batch # [strings], then run the test, then there is a Boolean to trigger an event to Save the data. I have a constant file i will be saving to and will never change. What I want is to just click the Save Data  and it automatically save the data with the Lot #_Batch #.xls. Do not want a dialog box to appear and ask for file path. ... Any help would be highly appreciatedA

Similar to VBA with:

outWorkBook.SaveAs strPathDir & "Test Data_" & [LotNo].Value & "_" & [BatchNo].Value & ".xlsx"

[RavensFan]

Use string functions to build the filename such as concatenate or Format into String.

[gingram536]

Thanks I see that now ... now how about the AutoSave part, the part where I just want to click the SAVE DATA button and it skips the dialog box and autosaves

[RavensFan]

When you build your filename and also give it a path (there are some Build Path functions as well) that you feed into the file write functions, you don't get a file dialog.