How to create a button in Forest & Trees that will prompt the user for a file name and export a view to Excel using that file name?
Create a view of type "Button" and Interface "Formula". Use the following as the formula:
Dim filePath, fullfilePath, first_path, last_path as Text filePath := Dialog('What would you like to name the file?') first_path:='C:\fts\' last_path:='.xls' fullfilePath := first_path||filePath||last_path View('Export', 'Expenses', 'Excel 4', fullfilePath)
This will export the view "Expenses" into an Excel filename of the users choosing and place the file in the C:\fts directory. To change the location of the file, change the variable first_path:=. To change the View that is being exported, change 'Expenses' on the last line of the formula.