|
Ah, thanks for the note. That's worth remembering.
|
|
|
|
|
Using VB code I am looking for a way to save an Excel sheet without getting a prompt (in Excel asking if I want to overwrite the file) and close the Excel without user intervention.
I have created an Excel.application object (MyExcel), a book object (MyBook) and a sheet object
(MySheet)
Through code I dump my datagrid data to the Excel Sheet, and save the file to disk using
MyBook.SaveAs (save_Path & Save_Name)
MyExcel.activeworkbook.close true
This works great if the file does not exist, but prompts me to overwrite the file if it does.
Any Suggestions would be helpful
|
|
|
|
|
Two things you can do...
- delete file first, if it already exists
- set DisplayAlerts to False in MyExcel object
HTH
|
|
|
|
|
Thanks for the advice
"MyCxcel.DisplayAlerts = False" did the trick
|
|
|
|
|
New_Coder wrote: Thanks for the advice
"MyCxcel.DisplayAlerts = False" did the trick
Glad it worked out for you... you are welcome.
|
|
|
|
|
hai all,
i am using .net 2005.i do my project in vb.net windows application.i have 2 listbox named as connolistbox and lotnolistbox.
i displayed the lotnos datas automatically in lotnolistbox based on i selected conno in connolistbox.
i want to do like,
if i removed all lotnos from lotnolistbox means that selected conno from connolistbox must be automatically removed.
for example,
i click 'conno101' in connolistbox means the 4 datas are lotno1,lotno2,lotno3,lotno4 are automatically displayed in lotnolistbox.
then i remove 4 datas are lotno1,lotno2,lotno3,lotno4.
now lotnolistbox is clear.when lotnolistbox clear means the 'conno101' must be automatically removed from connolistbox.
if lotnolistbox not clear means the 'conno101' must be there in connolistbox.
|
|
|
|
|
he try this <connolistbox.selectedindices.clear()>
rmshah
Developer
|
|
|
|
|
Is there a way to determine how many rows exist in the statusstrip control when the layout style = flow?
Example: you have a status strip control at the bottom of the form which contains 10 or so status labels. When the form is maximized, the labels look fine. When the form is resized, the status strip adds a second row to push some of the labels down that no longer fit on the first row.
|
|
|
|
|
Hi,
If everything else fails, you could divide the status strip height by the smallest value
it ever had.
|
|
|
|
|
"That'll do pig, that'll do." (from Babe the movie).
Thanks for the idea!
|
|
|
|
|
We have an old VB6 App that displays an image using the image control. The client claims that they could previously right-click on the control and select "Print" (there's no code for that). It's not there anymore.
Does anybody know whether there was functionality built into the control that was maybe removed by a service pack ? Doesn't sound right to me.
Johan Lombaard
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein
|
|
|
|
|
They are probably confusing the app with a browser
|
|
|
|
|
to my knowledge that has never been possible (at least not without any code)
|
|
|
|
|
Hi gents
I am developing a report application in vb.net. Its working fine when i use data set having a single database. When i populating the dataset by populating data from multiple tables. Its not displaying any data.
Please help me...
Regards
Azeem
|
|
|
|
|
If you copy your SQL query and run it in a Query Window (such as SQL Server Query Analyser) does it return data? If your report works fine when you get data from a single table, I would suggest that there's something wrong with your query and/or table links when using multiple tables.
--------------------------------------------------------
Knowledge is knowing that the tomato is a fruit.
Wisdom is not putting it in fruit salad!!
|
|
|
|
|
hi,
Make a query/View(which contains record from multiple table) in database which is same to the query which is you supplied at run time.Now create a dataset from Data source configuration Wizard and select this Query/View and then design the crystal report according to this query/view(by setting the database expert to dataset which you created from Data source configuration Wizard)
hope this helps
|
|
|
|
|
Thank you for ur reply
Can u explain little bit more by providing steps to do?
Regards
Azeem
|
|
|
|
|
How do i use the thumb print as security in vb.net 2005 project in relation to database
|
|
|
|
|
Buy a fingerprint reader and an SDK, such as this[^].
|
|
|
|
|
How do i save images into a database if i don't want to use the path name of the image
|
|
|
|
|
convert the image into the byte array using memory stream and store in the database.
Regards
Azeem
|
|
|
|
|
Hi,
Here is the procedure for saving the image to the DataBase using SQL Server:
1. Get the content length of the image that is to be uploaded
2. Create a byte[] to store the image
3. Read the input stream of the posted file
4. Create a connection object
5. Open the connection object
6. Create a command object
7. Add parameters to the command object
8. Execute the sql command using the ExecuteNonQuery method of the command object
9. Close the connection object.
You may refer to this[^] article for more information on this.
Hope this helps.
Vinay
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
Hi,
I'm looking for Gantt chart Control/ActiveX in VB.NET for developing a software.
Thanks to all great programmer that help me to find a free control and also powerful control for TaskScheduling.
Iman,
<attarzadeh.std@gmail.com>
|
|
|
|
|
|
In XL, if you hide a sheet (or sheets) in a workbook, it means the USER cannot see them, but does it mean the macros and Forms can't see them as well?
I am running a purchase order system, and want the data tables to be unseen by other users, they access only the PO itself and the Index List, but as soon as I hide the sheets, BANG, lots of crashes!
I don't know what to do, except leave the sheets visible.
Any suggestions?
------------------------------------
"I want you to imagine I have a blaster in my hand" - Zaphod Beeblebrox.
"You DO have a blaster in your hand" - Freighter Pilot
"Yeah, so you don't have to tax your imagination too hard" - Zaphod Beeblebrox
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
