Help with Visual Basic (.net) code for saving a calc file

oonewb · General User Joined: 24 May 2007 Posts: 6

Does anyone know the code to get a 'save as' dialogue to come up when automating 'Calc', using visual basic (.net) ? I've searched around and haven't found anything that works.

thanks!

SergeM · Posted: Mon Jun 04, 2007 10:49 am Post subject:

See :
how to launch 'save as ' dialog in OOo Macro ? http://www.oooforum.org/forum/viewtopic.phtml?t=12079&highlight=
for a start.
_________________
Linux & Windows OOo3.0
UNO & C++ : WIKI
http://wiki.services.openoffice.org/wiki/Using_Cpp_with_the_OOo_SDK
In French
http://wiki.services.openoffice.org/wiki/Documentation/FR/Cpp_Guide

oonewb · General User Joined: 24 May 2007 Posts: 6

Well... I figured it out for myself again...This will bring up the 'save as' prompt. Here is the code: (again, this is written in VB .net with visual studio 2005)

document = oDoc.CurrentController.Frame
dispatcher = oSM.createInstance("com.sun.star.frame.DispatchHelper")
dispatcher.executeDispatch(document, ".uno:SaveAs", "", 0, aNoArgs)

This assumes that you 'dim'ed everything properly in vb .net. You can then use the following to save the file whenever you want: (ie. after you've updated cells)

oDoc.store()