Re: [libreoffice-users] Vba code of saving a taxt file not working in libre office

Hi :)
There is a guide to writing macros
https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers

The usual language is another form of Basic so re-writing it is probably
not as huge a task as it might have sounded.  There are soemtimes people on
this mailing list who are happy to help with short snippets.

LibreOffice also makes it fairly easy to write Add-ons/Plug-ins/Extensions
(we call them Extensions) which has some advantages.
Regards from
Tom :)


On 24 September 2014 19:48, Florian Reisinger <florei@libreoffice.org>
wrote:

> Hi,
>
> VBA is not really supported in LibO. Try Basic/Python/etc.
> Others might help more on these topics is needed....
>
> Liebe Grüße, / Yours,
> Florian Reisinger
>
> > Am 24.09.2014 um 20:40 schrieb Rajbir Singh <rajbirsmann@gmail.com>:
> >
> > Sub Build()
> > Dim yaml as string
> >
> > yaml = "FieldMapping.Config:" & vbCrLf & yaml
> >
> >
> >    Dim vFile As Variant
> >
> >    vFile =
> > Application.GetSaveAsFilename(InitialFileName:=Sheets("SIMPLE").Cells(2,
> 2)
> > & "_config.yaml", _
> >    FileFilter:="YAML Config File (*.yaml), *.xlsb, All files (*.*),
> *.*", _
> >    Title:="Save Config File As:")
> >
> >    If vFile <> False Then
> >        Call saveFile(vFile, yaml)
> >        MsgBox ("File Saved")
> >
> >    End If
> >
> > End Sub
> >
> > Sub saveFile(fileName As Variant, content As String)
> >
> >    Dim fso As Object
> >
> >    Set fso = CreateObject("Scripting.FileSystemObject")
> >
> >    Dim oFile As Object
> >
> >    Set oFile = fso.CreateTextFile(fileName)
> >
> >    oFile.WriteLine content
> > $1.Close(False)
> >
> >    Set fso = Nothing
> >    Set oFile = Nothing
> >
> > End Sub
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> deleted
> >
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted