How do I allow the user to open and view an Excel file

  • Thread starter Thread starter ThriftyFinanceGirl
  • Start date Start date
T

ThriftyFinanceGirl

How do I allow the user to open an view an Excel file that I just created via
VBA? I created a copy of a template and exported data into it. When I am
done, I want the user to be able to answer basically a vbYesNo type msgbox
"Do you want to open the file now?" type thing... any suggestions?
 
It's generally like this:

If MsgBox("Do you want to open the file now?") = vbYes Then
Excel.Application.Workbooks.Open fileName ' fileName being the name
of the workbook
' Excel.Application.Visible = True
End If

But the particulars will depend on the code you've written.

--JP
 
Back
Top