|
hi guys,
The code below works fine except when i open the windows task manager, i can still see EXCEL.EXE Running.
how do i close or exit it, should not objFso.Quit() Close Excel?
thanks
Dim objFSO, ObjWb, ObjWs As New Object
objFSO = CreateObject("Excel.Application")
ObjWb = objFSO.Workbooks.Open("c:\myapp.xls")
For Each ObjWs In ObjWb.Worksheets
MsgBox(ObjWs.Name)
Application.DoEvents()
Next
objFso.Quit()
|
|
|
|
|
Since you have work books open, it would probably prevent Excel from closing.
|
|
|
|
|
well this seems to work....
i have added this after the worksheets loop...
ObjWb.close()
releaseObject(ObjWs)
ObjWs = Nothing
releaseObject(ObjWb)
ObjWb = Nothing
releaseObject(objFSO)
objFSO = Nothing
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical)
End Try
End Sub
Private Sub releaseObject(ByVal obj As Object)
Try
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
obj = Nothing
Catch ex As Exception
obj = Nothing
Finally
GC.Collect()
End Try
End Sub
|
|
|
|
|
You also have to dispose the object
|
|
|
|
|
close the workbook also,
excel.workbook.close
|
|
|
|
|
mates,
i don't know where to post this, its about crystal report in visual basic.net.
I have a problem of the line size on report footer.
It will not follow the size(10) when page is more than 1.
heres the image: page 1 should the same line with page 2.
http://i40.tinypic.com/6enlmq.jpg
thanks in advance.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
Hi,
if i am not mistaken, i would say that you have a drop shadow on your grid.
the last line is the bottom of the grid.
that bottom line will only display once .i.e at the end of the report/data.
so when you have data for only one sheet, you actually see the bottom of the grid on the same page.
when there is more data than one page then the bottom line will be on the last page.
notice on your grid that when 2 pages then the last line on first page is same size as all the other lines.
thanks
|
|
|
|
|
exactly. i have a line at the end of the report. that is why i put a line in a report footer. the page 2 is correct but page 1 the line doesnt show.
any suggestion, how will i add a line in every end of a report?
thanks mate.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
Print the report and check if its still there
I'v noticed that sometimes it will do this in preview but when printed it is the actual size.
|
|
|
|
|
Tom Deketelaere wrote: Print the report and check if its still there
yes i print that report but the same problem because i thought its only in preview. anyway, the problem is how will i add a line in every end of a report, any suggestion?
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
Do you want a line on the end of every page or just at the end off the report.
At the end of every page: add a line to the section 'page footer'
At the end of the report: add a line to the section 'report footer'
|
|
|
|
|
thank you for immediate reply.
Tom Deketelaere wrote: At the end of every page: add a line to the section 'page footer'
I used this one but the problem is how can I show a line at the bottom of my detail section after the last record of the page? Depending on how many records, the line will need to appear at the end on each page to form a box around the detail output.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
You could try adding a new section
Or add the line to the page footer (on top)
I'm not that used to CR so can't really be specific.
|
|
|
|
|
hello every one
i am having problem of combobox my code is..
this code works in VB6 but in Vb.net how can i pass itemdata to particular text
cmbmonth.add("January")
cmbmonth.itemdata(0)=1
i m beginner..
so please help...
|
|
|
|
|
I can see nothing particularly wrong with that, so long as you are using the correct capitals.
cmbmonth.ItemData (0) = 1
However we need to see more code, are you setting it up correctly? If nothing is set it will default the ItemData to -1.
------------------------------------
"I am always serious about what I do, not necessarily about how I do it."
Tom Baker
|
|
|
|
|
I tried the same code u wrote it shows the error message like
'ItemData' is not member of 'System.windows.forms.combobox'
please suggest what to do with this error....
thank u in advance...
|
|
|
|
|
ComboBoxes are handled differently in .Net than in VB6, so much so that it is beyond the scope of a forum post to explain. If you Google for VB.Net combo box tutorials I'm sure you'll find something.
But saying that, it seems like you want to populate the combo box with the months of the year, right? What I would do is create a user defined structure called Month with 2 properties, MonthName and MonthNumber and then bind the combo box to a collection of Month structures, setting the ValueMember and DisplayMember properties of the combo box.
Hope this helps.
(you could also do it by populating the ComboBox with strings and by using ComboBox.SelectedIndex - 1 to get the month number but I think this may be regarded as bad practice.)
|
|
|
|
|
For your purpose you could use the DateTimePicker control, and set the CustomFormat property to MMMM
The DatTimePicker looks like a combobox, and with the CustomFormat property set to four M's, it will show you the name of the month. When opened it shows the user a calendar.
In your code you can access the chosen month's number (an integer) like so:
DateTimePicker1.Value.Month
If you need to do more with dates, the DateTimePicker value is of type Date, so you can access a lot of other values from a chosen DateTime. Like DateTimePicker1.Value.Day, DateTimePicker1.Value.Hour, DateTimePicker1.Value.Year, etc.
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi,
May i know how can i invoke msi thru a batch file....
|
|
|
|
|
Edit the bat file with following command
msiexec /i "FileName.bat"
|
|
|
|
|
The general command line is for an unattended install with a minimum GUI:
msiexec /i installername.msi /qb
If you need to add a Transform file:
msiexec /i installername.msi TRANSFORMS=transformname.mst /qb
All the available options for MSIEXEC can be found by just typing MSIEXEC into a Start/Run box.
|
|
|
|
|
You can run any windows.exe from dos by putting the word 'Start' infront of it.
start myfile.msi
or
start notepad.exe
or
start http://www.yahoo.com
etc
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
Hi Friends,
I am using Microsoft Visual Interdev 6.0 in my system. It was working fine. But for the last 2 days i am facing problem, that when I click Visual Interdev 6.0 to open its giving error:
"Development Environment has Encountered Problem and needs to Close. We are sorry for the inconvenience."
I tried uninstall and install again. Still I am facing the same problem. I have Visual Studio 2003 installed in my system and with that interdev was working fine for the past 1 year. Please Please help me. Because formating system and installing again is a rock work. Please friends help me..give me ur suggestions...
Thanks in Advance.
|
|
|
|
|
Visual InterDev isn't supported anymore, and hasn't been for quite some time now. This[^] Google result is about the best you're going to find for such an old app.
|
|
|
|
|
it sounds like your solution file is corrupt. have you tried to recreate?
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|