[AccessD] Access To Excel via a CSV File

LOL, you want it ALL eh?

John W. Colby
www.ColbyConsulting.com


Max Wanadoo 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
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>