473,403 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

Open an Excel-file from Access 2003

Hi,

I have a program in Access 2003 and written in Visual Basic. At some
point I would like to open an
Excel file automatly from Access 2003. So that the user can do some
changes in this file and then
close it. I don't want any connection with the program, only that it
open the file on its own.

If you have an idea of how I can do that It would be great.

Thank you,

Laura

Oct 29 '07 #1
2 4974
Thank you. It has worked.

Oct 29 '07 #2
On Oct 29, 2:34 am, laurasesm...@gmail.com wrote:
Hi,

I have a program in Access 2003 and written in Visual Basic. At some
point I would like to open an
Excel file automatly from Access 2003. So that the user can do some
changes in this file and then
close it. I don't want any connection with the program, only that it
open the file on its own.

If you have an idea of how I can do that It would be great.

Thank you,

Laura
Hi Laura. Here's a good example of some code that opens up Excel from
Access. You can cater it to what you need, add a button and assign
this macro to it.

http://www.excelguru.ca/node/10

Good luck!

Oct 29 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet...
2
by: Belinda | last post by:
Hello All I want to place a Excel workbook on the web server and create a URL link to it and when the user clicks on it to the URL/vbscript behind it must launch Excel on the client and open the...
1
by: Robinho | last post by:
Hi...i'm working on VB and I want open just Cells from excel, make a few operations, and save it like "work.xls" I don't want open excel, just see and work on cells predeterminates by me... ...
20
by: Atchoum | last post by:
I have a DLL that opens an Excel workbook and add-in. If I close the app that calls the DLL before closing Excel, when I close Excel everything is fine. But if I close Excel while the app is still...
4
by: Leeor Chernov | last post by:
Hi , I Used the object Excell Application(COM INTEROP) and it is staying as an open process, And the owner(User Name) is ASPNET Altough I try to release it with :...
6
by: Michael Groeger | last post by:
Hi, I have an aspx page which generates an excel document and transfers it to the browser as attachment. Normally, once the document is transferred the open save dialog prompts to open or save...
2
by: mike | last post by:
Hi, I have surfed through several posting about exporting gridview to excel and it works great. using the following code... response.Clear() response.ContentType = "application/vnd.ms-excel"...
2
by: k-w | last post by:
Hi all In vb I do: Dim Ex As New Excel.Application Ex.Workbooks.Open "c:\tmp\Book1.xls" Similar code in VC doesn't work:
3
by: pleaseexplaintome_2 | last post by:
using the code below (some parts not included), I create a new excel workbook with spreadheets. I then want to delete a spreadsheet, but a reference remains open and excel stays in task manager...
1
by: StinkyDuck | last post by:
Is there a way to open up any version of Excel without having to explicitly add a reference? I know how to open up Excel 12 since its installed on my machine. I just have to add a reference to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.