use command button in access to open excel file

ronnie.222.a67 ronnie.222.a67 is offline

New Member

Join Date: Mar 2012

Location: Boracay Island, Philippines

Posts: 1

21st Mar 2012

hi steve!
I been using microsoft excel for my sales record, i want to create a program that, if I click the command button it will transfer for a new sheet and i want my new sheet will same as my previous work sheet using command button... can you give me an example of syntax for my problem??? thank you

Page 2 of 2

« Access 2007 Macros - SendObject action, Message Text action argume | Macro Conditions »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: How to Open Excel to a specific file via Access Command Button?	fredg	Microsoft Access Form Coding	0	26th Oct 2009 04:47 PM
Deselect Command Button by Selecting another Command Button	gmcnaugh	Microsoft Excel Programming	3	2nd Sep 2008 05:59 PM
Command Button Pictures Taken from Command Bar Button Icons	acx@centrum.cz	Microsoft Access Forms	0	2nd Dec 2007 01:23 PM
VB's Command Button vs Form's Command Button	Ronald Dodge	Microsoft Excel Programming	3	24th May 2006 02:23 PM
How do I use a command button to open an excel file?	=?Utf-8?B?SnVzdGlu?=	Microsoft Access Getting Started	2	14th Feb 2006 07:23 PM