<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[My Visual Database — Automatic Excel Backup without opening excel]]></title>
		<link>https://myvisualdatabase.com/forum/viewtopic.php?id=9347</link>
		<atom:link href="https://myvisualdatabase.com/forum/extern.php?action=feed&amp;tid=9347&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Automatic Excel Backup without opening excel.]]></description>
		<lastBuildDate>Mon, 13 Oct 2025 23:02:11 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Automatic Excel Backup without opening excel]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=53100#p53100</link>
			<description><![CDATA[<p>Thank you Jean, It works perfect!!!!!!!!&nbsp; </p><div class="quotebox"><cite>jean.brezhonek wrote:</cite><blockquote><p>Hello luisante<br />Something like this ?</p><p>procedure Form1_CheckBox4_OnClick (Sender: TObject);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Sauvegarde au format Html<br />var SaveDialog : TSaveDialog;<br />begin<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog.Filter := &#039;Fichier HTML |*.html&#039;;<br />&nbsp; &nbsp; &nbsp;SaveDialog.DefaultExt := &#039;txt&#039;;<br />&nbsp; &nbsp; &nbsp;If SaveDialog.Execute then<br />&nbsp; &nbsp; &nbsp;Begin<br />&nbsp; &nbsp; &nbsp; &nbsp;Form1.TableGrid1.SaveToTextFile(SaveDialog.FileName);<br />&nbsp; &nbsp; &nbsp;end;<br />end;</p><p>procedure Form1_CheckBox5_OnClick (Sender: TObject);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Sauvegarde au format csv<br />var SaveDialog : TSaveDialog;<br />begin<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog.Filter := &#039;Fichier CSV |*.csv&#039;;<br />&nbsp; &nbsp; &nbsp;SaveDialog.DefaultExt := &#039;txt&#039;;<br />&nbsp; &nbsp; &nbsp;If SaveDialog.Execute then<br />&nbsp; &nbsp; &nbsp;Begin<br />&nbsp; &nbsp; &nbsp; &nbsp;Form1.TableGrid1.SaveToTextFile(SaveDialog.FileName);<br />&nbsp; &nbsp; &nbsp;end;<br />end;</p><p>procedure Form1_CheckBox3_OnClick (Sender: TObject;var Cancel: boolean);&nbsp; &nbsp;// Sauvegarde au format txt<br />var SaveDialog : TSaveDialog;<br />begin<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog.Filter := &#039;Fichier TXT |*.txt&#039;;<br />&nbsp; &nbsp; &nbsp;SaveDialog.DefaultExt := &#039;txt&#039;;<br />&nbsp; &nbsp; &nbsp;If SaveDialog.Execute then<br />&nbsp; &nbsp; &nbsp;Begin<br />&nbsp; &nbsp; &nbsp; &nbsp;Form1.TableGrid1.SaveToTextFile(SaveDialog.FileName);<br />&nbsp; &nbsp; &nbsp;end;</p><p>JB</p></blockquote></div>]]></description>
			<author><![CDATA[null@example.com (luisantafe)]]></author>
			<pubDate>Mon, 13 Oct 2025 23:02:11 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=53100#p53100</guid>
		</item>
		<item>
			<title><![CDATA[Re: Automatic Excel Backup without opening excel]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=53094#p53094</link>
			<description><![CDATA[<p>Hello luisante<br />Something like this ?</p><p>procedure Form1_CheckBox4_OnClick (Sender: TObject);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Sauvegarde au format Html<br />var SaveDialog : TSaveDialog;<br />begin<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog.Filter := &#039;Fichier HTML |*.html&#039;;<br />&nbsp; &nbsp; &nbsp;SaveDialog.DefaultExt := &#039;txt&#039;;<br />&nbsp; &nbsp; &nbsp;If SaveDialog.Execute then<br />&nbsp; &nbsp; &nbsp;Begin<br />&nbsp; &nbsp; &nbsp; &nbsp;Form1.TableGrid1.SaveToTextFile(SaveDialog.FileName);<br />&nbsp; &nbsp; &nbsp;end;<br />end;</p><p>procedure Form1_CheckBox5_OnClick (Sender: TObject);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Sauvegarde au format csv<br />var SaveDialog : TSaveDialog;<br />begin<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog.Filter := &#039;Fichier CSV |*.csv&#039;;<br />&nbsp; &nbsp; &nbsp;SaveDialog.DefaultExt := &#039;txt&#039;;<br />&nbsp; &nbsp; &nbsp;If SaveDialog.Execute then<br />&nbsp; &nbsp; &nbsp;Begin<br />&nbsp; &nbsp; &nbsp; &nbsp;Form1.TableGrid1.SaveToTextFile(SaveDialog.FileName);<br />&nbsp; &nbsp; &nbsp;end;<br />end;</p><p>procedure Form1_CheckBox3_OnClick (Sender: TObject;var Cancel: boolean);&nbsp; &nbsp;// Sauvegarde au format txt<br />var SaveDialog : TSaveDialog;<br />begin<br />&nbsp; &nbsp; &nbsp;SaveDialog := TSaveDialog.Create(Form1);<br />&nbsp; &nbsp; &nbsp;SaveDialog.Filter := &#039;Fichier TXT |*.txt&#039;;<br />&nbsp; &nbsp; &nbsp;SaveDialog.DefaultExt := &#039;txt&#039;;<br />&nbsp; &nbsp; &nbsp;If SaveDialog.Execute then<br />&nbsp; &nbsp; &nbsp;Begin<br />&nbsp; &nbsp; &nbsp; &nbsp;Form1.TableGrid1.SaveToTextFile(SaveDialog.FileName);<br />&nbsp; &nbsp; &nbsp;end;</p><p>JB</p>]]></description>
			<author><![CDATA[null@example.com (jean.brezhonek)]]></author>
			<pubDate>Mon, 13 Oct 2025 06:10:11 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=53094#p53094</guid>
		</item>
		<item>
			<title><![CDATA[Re: Automatic Excel Backup without opening excel]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=53093#p53093</link>
			<description><![CDATA[<p>Hi there.&nbsp; I am still looking for some way to do a backup in a different format, such as excel, csv etc, without any interference (opening excel, notepad etc, saving manually and then close it).&nbsp; Any thoughts?</p><p>Thanks</p>]]></description>
			<author><![CDATA[null@example.com (luisantafe)]]></author>
			<pubDate>Mon, 13 Oct 2025 00:23:53 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=53093#p53093</guid>
		</item>
		<item>
			<title><![CDATA[Re: Automatic Excel Backup without opening excel]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=53070#p53070</link>
			<description><![CDATA[<div class="quotebox"><cite>derek wrote:</cite><blockquote><p>Hi Luis,<br />Before anyone offers to help, I think it&#039;s important to clarify <br />1.&nbsp; why you need to do this in the first place<br />2.&nbsp; why you want a FULL table back-up every time a SINGLE RECORD is created / amended / deleted?&nbsp; This has the potential to generate a large number of .xls files which will quickly become unmanageable.<br />3.&nbsp; how do you want the .xls files to be named.<br />4.&nbsp; do you want just the most recent copy to be kept (in which case how do you identify and delete old copies) etc etc.<br />And these are just questions without even thinking about it!<br />Derek.</p></blockquote></div><br /><p>Thanks @derek.</p><p>1.&nbsp; My boss needs a back up.&nbsp; She is kind of old school and only trust on excel.</p><p>2.&nbsp; She only needs one excel file.</p><p>3.&nbsp; It would be something like QualityInspection.xlsx</p><p>4.&nbsp; Only the most recent copy.&nbsp; This will replace the old one. </p><div class="quotebox"><cite>k245 wrote:</cite><blockquote><p>Excel supports loading data from a CSV file. Is this backup format acceptable?</p></blockquote></div><br /><p>@k245</p><p>Sure, csv is perfect.</p><br /><p>Thank you guys.</p>]]></description>
			<author><![CDATA[null@example.com (luisantafe)]]></author>
			<pubDate>Mon, 29 Sep 2025 20:31:09 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=53070#p53070</guid>
		</item>
		<item>
			<title><![CDATA[Re: Automatic Excel Backup without opening excel]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=53069#p53069</link>
			<description><![CDATA[<p>Excel supports loading data from a CSV file. Is this backup format acceptable?</p>]]></description>
			<author><![CDATA[null@example.com (k245)]]></author>
			<pubDate>Mon, 29 Sep 2025 20:22:57 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=53069#p53069</guid>
		</item>
		<item>
			<title><![CDATA[Re: Automatic Excel Backup without opening excel]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=53067#p53067</link>
			<description><![CDATA[<p>Hi Luis,<br />Before anyone offers to help, I think it&#039;s important to clarify <br />1.&nbsp; why you need to do this in the first place<br />2.&nbsp; why you want a FULL table back-up every time a SINGLE RECORD is created / amended / deleted?&nbsp; This has the potential to generate a large number of .xls files which will quickly become unmanageable.<br />3.&nbsp; how do you want the .xls files to be named.<br />4.&nbsp; do you want just the most recent copy to be kept (in which case how do you identify and delete old copies) etc etc.<br />And these are just questions without even thinking about it!<br />Derek.</p>]]></description>
			<author><![CDATA[null@example.com (derek)]]></author>
			<pubDate>Mon, 29 Sep 2025 19:46:43 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=53067#p53067</guid>
		</item>
		<item>
			<title><![CDATA[Automatic Excel Backup without opening excel]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=53066#p53066</link>
			<description><![CDATA[<p>Hello there <img src="https://myvisualdatabase.com/forum/img/smilies/smile.png" width="15" height="15" alt="smile" /> .&nbsp; I need to automatically create an excel backup every time a record is saved in a table. </p><p>Requirements <img src="https://myvisualdatabase.com/forum/img/smilies/sad.png" width="15" height="15" alt="sad" />&nbsp; :</p><p>The backup should include all records in the table.</p><p>Excel should not open; the file should save silently.</p><p>It should happen automatically when saving, with no extra clicks.</p><p>Is this possible using mvd built-in features or scripting?&nbsp; Any advice would be appreciated.</p><br /><p>L.</p>]]></description>
			<author><![CDATA[null@example.com (luisantafe)]]></author>
			<pubDate>Mon, 29 Sep 2025 19:03:20 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=53066#p53066</guid>
		</item>
	</channel>
</rss>
