Accessing excel

[John]

Hi

How can I open a excel from disk from within access and fill a few cells in
it?

Thanks

Regards

 

[KARL DEWEY]

Click on menu FILE - Get External Data - Link Tables.
At the bottom of the window that opens select Excel as type of file.
Select your file and worksheet.

 

[John]

Hi

Thanks for that. I need to open a separate copy every time. Actually it is
an invoice template that I need to fill in for different jobs.

Thanks

Regards

 

[Arvin Meyer [MVP]]

Use ShellExecute from the Access Web:

http://www.mvps.org/access/api/api0018.htm

Once you've compile the code a simple line like this will open your template
to a new spreadsheet:

fHandleFile("C:\FolderName\TemplateName.xlt",WIN_NORMAL)

 

[John]

Would I be able to transfer data from access into excel cells this way?

Thanks

Regards

 

[Arvin Meyer [MVP]]

You may want to look at this:

http://www.mvps.org/access/modules/mdl0006.htm

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com