MS Access, Automation Does Not Close Microsoft Excel

Automation Does Not Close Microsoft Excel

Author	Message
Renato B. Laper #1 / 4	Automation Does Not Close Microsoft Excel How can I prevent the MS Access '97 to stop prompting "Do you want to save the changes you made to 'excel apps' even though I'm just reading the the excel apps? During saving the excel apps, its also prompt "Replace the existing excel file" Thanks in Advance, Renato B. Lapera
Sun, 13 Oct 2002 03:00:00 GMT

Eric Haas #2 / 4	Automation Does Not Close Microsoft Excel Quote: > How can I prevent the MS Access '97 to stop prompting "Do you want to > save the changes you made to 'excel apps' even though I'm just reading > the the excel apps? > During saving the excel apps, its also prompt "Replace the existing > excel file" Hi Renato, use savechanges:=false when you close the Excel-Workbook. Like Dim xlapp As Excel.Application Dim xlbook As Workbook Set xlapp = CreateObject("Excel.Application") Set xlbook = xlapp.Workbooks.Open("YourWorkbook") xlapp.Visible = True xlbook.Close savechanges:=False xlapp.Quit Set xlapp = Nothing HTH Eric Sent via Deja.com http://www.deja.com/ Before you buy.
Sun, 13 Oct 2002 03:00:00 GMT

Renato B. Laper #3 / 4	Automation Does Not Close Microsoft Excel Hi! Eric, Thanks. It's solved my problem after I included the xlbook.close statement. I would like to aks again if you're familiar with how to make a formula entry in coding of ms access '97 or kindly refer me to some articles with this kind of information. Quote: > > How can I prevent the MS Access '97 to stop prompting "Do you want to > > save the changes you made to 'excel apps' even though I'm just reading > > the the excel apps? > > During saving the excel apps, its also prompt "Replace the existing > > excel file" > Hi Renato, > use savechanges:=false when you close the Excel-Workbook. > Like > Dim xlapp As Excel.Application > Dim xlbook As Workbook > Set xlapp = CreateObject("Excel.Application") > Set xlbook = xlapp.Workbooks.Open("YourWorkbook") > xlapp.Visible = True > xlbook.Close savechanges:=False > xlapp.Quit > Set xlapp = Nothing > HTH > Eric > Sent via Deja.com http://www.deja.com/ > Before you buy.
Mon, 14 Oct 2002 03:00:00 GMT

Eric Haas #4 / 4	Automation Does Not Close Microsoft Excel Quote: > Hi! Eric, Thanks. > It's solved my problem after I included the xlbook.close statement. > I would like to aks again if you're familiar with how to make a formula > entry in coding of ms access '97 or kindly refer me to some articles with > this kind of information. Hi Renato, if I understand you correctly you want to enter a formula in an excel- workbook using Access. You can use all the VBA-Objects Excel has in Access. Maybe the easiest way to learn how to do this is to make the changes in Excel by hand and let the Macro-Editor record this. You can then use the procedures the Macro-Editor writes in Access by creating an Excel or an Excel-Workbook- Object. What you should do is set a Reference to the MS Excel 8.0 Object Library. If this doesn't get you any further feel free to ask again. HTH Eric Sent via Deja.com http://www.deja.com/ Before you buy.
Tue, 15 Oct 2002 03:00:00 GMT

Page 1 of 1

[ 4 post ]