DPChristman
Board Regular
- Joined
- Sep 4, 2012
- Messages
- 177
- Office Version
- 365
- Platform
- Windows
I am working with a successful macro in saving the document via clicking a macro control button.
However, I was wondering if there is a way to have the document save to another format.
The reason is that some of the people on distribution for this form are pulling it up on their cellphones, tablets, etc.
These devices don't all have the ability to open macro enabled spreadsheets.
Rather than have to have these people download new apps, it would be easier (for them anyway), if the form would automatically save to a non macro format.
I already have the macro required functions removed from the form by time the document has to be saved.
This is what I currently use.
Any thoughts?
Sub Saveform()
Dim FName As String
Dim FPath As String
FPath = "C:"
FName = Sheets("Form").Range("I4").Text
ThisWorkbook.SaveAs Filename:=FName
End Sub
However, I was wondering if there is a way to have the document save to another format.
The reason is that some of the people on distribution for this form are pulling it up on their cellphones, tablets, etc.
These devices don't all have the ability to open macro enabled spreadsheets.
Rather than have to have these people download new apps, it would be easier (for them anyway), if the form would automatically save to a non macro format.
I already have the macro required functions removed from the form by time the document has to be saved.
This is what I currently use.
Any thoughts?
Sub Saveform()
Dim FName As String
Dim FPath As String
FPath = "C:"
FName = Sheets("Form").Range("I4").Text
ThisWorkbook.SaveAs Filename:=FName
End Sub
