[AccessD] Access To Excel via a CSV File

[vba]
     ActiveWindow.WindowState = xlMaximized
[/vba]

MF



______________________________
At 09:34 AM 06/06/2008, you wrote:
>Well,
>Thanks to all those who responded.
>I have had quite some success, but not fully.
>Thanks to Jennifer's and Rocky's examples and all the other tips I was able
>to create the xls exactly as I wanted.  This is great.
>I am able to give it a filename and save it to disk.  From there I can email
>it out.
>All this from the click of a button without the user seeing or doing
>anything - Brilliant!
>
>However, the one small glitch I have is that when it is subsequently opened
>up, the worksheet "floats" within the Excel App.  It has its own title bar
>which can be grabbed and moved around.  Any ideas?
>
>Max
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
>Salakhetdinov
>Sent: Thursday, June 05, 2008 7:21 PM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] Access To Excel via a CSV File
>
>Hello Max,
>
>If your output .csv will have predefined format then the following tricks
>could work:
>
>- prepare formatted .xls template worksheet (let's call it myTemplate.xls);
>- generate/export .csv from MS Access and assign to the output filename an
>.xls extension (let's call it my.csv.xls);
>- open generated my.csv.xls in XL using Automation (and all the following
>actions will be performed using Automation also);
>- open myTemplate.xls in XL;
>- select all cells of myTemplate.xls's template worksheet;
>- execute copy of selected range to clipboard;
>- switch to previously opened my.csn.xls;
>- select all its cells and use Paste Special->Formats...
>...
>
>That could be it...
>
>--
>Shamil
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
>Sent: Thursday, June 05, 2008 6:34 PM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Access To Excel via a CSV File
>
>
>Can any of you Access/Excel gurus help here please.
>I need to create a csv spreadsheet by code.  When it is complete, I need to
>put formatting on it. Ie,make columns into Currency Types. Bold some Rows,
>set some bacground colours, etc.
>I have got as far as creating the CSV ok but then I am stumped.
>Any advice most welcome.
>Ta
>Max