[AccessD] Creating New Spreadsheet with Automation

Jim:

.Add.  That's it  Thanks.

Do you know offhand how to set a column to a specific format?  Text? Number? 
Currency?  etc.

TIA

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334


----- Original Message ----- 
From: "Hale, Jim" <Jim.Hale at fleetpride.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, May 06, 2005 8:28 AM
Subject: RE: [AccessD] Creating New Spreadsheet with Automation


> Try objXLApp.Workbooks.Add
> Jim Hale
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Friday, May 06, 2005 10:05 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Creating New Spreadsheet with Automation
>
>
> Dear List:
>
> I have been manipulating existing spreadsheet from Access:
>
> ' Object variables for Automation stuff
> Dim objXLApp As Excel.Application
>
> Set objXLApp = New Excel.Application
> objXLApp.Workbooks.Open "C:\Clients\Placement22"
>
> Now I want to create a new spreadsheet instead of opening one that already
> exists.  But I can't seem to find the method.
>
> Does anyone know the right syntax?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> ***********************************************************************
> The information transmitted is intended solely for the individual or
> entity to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or
> other use of or taking action in reliance upon this information by
> persons or entities other than the intended recipient is prohibited.
> If you have received this email in error please contact the sender and
> delete the material from any computer. As a recipient of this email,
> you are responsible for screening its contents and the contents of any
> attachments for the presence of viruses. No liability is accepted for
> any damages caused by any virus transmitted by this email.


--------------------------------------------------------------------------------


> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>