Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 4787 | Replies: 5
 |
•
•
Join Date: Mar 2007
Posts: 22
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
hello,
i have to open excel file from vb application. i want to update excel file from vb if i modify some value from vb application. but i dont want msg from excel that "Do you want to save changes in this file?"
please guide me
Thnaks n Regards
from
Pranav Varma
i have to open excel file from vb application. i want to update excel file from vb if i modify some value from vb application. but i dont want msg from excel that "Do you want to save changes in this file?"
please guide me
Thnaks n Regards
from
Pranav Varma
•
•
Join Date: Mar 2007
Posts: 16
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Public xlApp As New Excel.Application
Public xlBook As Excel.Workbook
Public xlSheet As Excel.Worksheet
xlApp.Workbooks.OpenText FileName:= "Text.xls"
cells(1,1)= "Test2"
ActiveWorkbook.Close savechanges:=True xlApp.Quit
Public xlBook As Excel.Workbook
Public xlSheet As Excel.Worksheet
xlApp.Workbooks.OpenText FileName:= "Text.xls"
cells(1,1)= "Test2"
ActiveWorkbook.Close savechanges:=True xlApp.Quit
•
•
Join Date: Mar 2007
Posts: 16
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Re: update excel file from vb •
•
•
•
Originally Posted by pranavdv 
hello,
i have to open excel file from vb application. i want to update excel file from vb if i modify some value from vb application. but i dont want msg from excel that "Do you want to save changes in this file?"
please guide me
Thnaks n Regards
from
Pranav Varma
[quote=Kees Baltus;333963]Public xlApp As New Excel.Application
Public xlBook As Excel.Workbook
Public xlSheet As Excel.Worksheet
xlApp.Workbooks.OpenText FileName:= "Text.xls"
cells(1,1)= "Test2"
ActiveWorkbook.Close savechanges:=True xlApp.Quit
•
•
Join Date: Mar 2007
Posts: 22
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Re: update excel file from vb [quote=Kees Baltus;333965]
Thnx for this code. This one is really upto the mark.
but still i face one problem in the last line
i.e.
ActiveWorkbook.Close savechanges = true
when i m trying above line, then no changes made in that file
but
ActiveWorkbook.Close savechanges
whn i m trying above line, then changes made, but the msg display that do u want to save changes to this file??
i dont want msg. directly it has to save the file.
if possible, please guid me.
again thanks for this help.
•
•
•
•
Originally Posted by Kees Baltus
Public xlApp As New Excel.Application
Public xlBook As Excel.Workbook
Public xlSheet As Excel.Worksheet
xlApp.Workbooks.OpenText FileName:= "Text.xls"
cells(1,1)= "Test2"
ActiveWorkbook.Close savechanges:=True xlApp.Quit
Thnx for this code. This one is really upto the mark.
but still i face one problem in the last line
i.e.
ActiveWorkbook.Close savechanges = true
when i m trying above line, then no changes made in that file
but
ActiveWorkbook.Close savechanges
whn i m trying above line, then changes made, but the msg display that do u want to save changes to this file??
i dont want msg. directly it has to save the file.
if possible, please guid me.
again thanks for this help.
•
•
Join Date: Mar 2007
Posts: 16
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
[quote=pranavdv;334543]
•
•
•
•
Originally Posted by Kees Baltus
Thnx for this code. This one is really upto the mark.
but still i face one problem in the last line
i.e.
ActiveWorkbook.Close savechanges = true
when i m trying above line, then no changes made in that file
but
ActiveWorkbook.Close savechanges
whn i m trying above line, then changes made, but the msg display that do u want to save changes to this file??
i dont want msg. directly it has to save the file.
if possible, please guid me.
again thanks for this help.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
