|
Hi
I am using the following command
Sheets("SHEETS").Delete
this works however it requires the user to confirm deletion, is there another way of deleting a sheet without the user confirming
Thanks
|
|
|
|
|
Execute the Excel VBA code listed below before your delete statement in order to prevent the confirmation message box.
Application.DisplayAlerts = False
|
|
|
|
|
|
Hai guys,
I need to send email though vb using gmail smtp.
But i really dont want to use any 3rd party components.
Pls give me a pure vb6 solution.
* Previously i have not used emailing though vb.
|
|
|
|
|
You can just connect to the SMTP server directly and send the necessary commands. However, GMail requires a connection over SSL.
|
|
|
|
|
yah, just found that cdo stuff supports gmail.
so that is what i really wanted it look like 
|
|
|
|
|
Hi
I have developed my web services project successfully and tested on localserver too, it is working perfectly.
Now, I want to deploy it on web server online but facing some serious trouble, which says "Could not create type".
Please help me.
Regards,
MAP Tiger
Tiger Softwares
Software Designer and Developer
VB.NET, ASP.NET, VFP
|
|
|
|
|
What type of exception?
Sounds like either you are missing a dependancy, or that you are trying to use reflection, and the hosting provider doesn't allow it?
|
|
|
|
|
Hi
Thanks for the reply. It is Parser Error. Details are below:
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not create type 'WebService1.Service1'
Line 1: <%@ WebService Language="VB" CodeBehind="Service1.asmx.vb" Class="Webservice1.Service1" %>
This is the error I am getting when I tried to access the service from web.
Regards,
MAP Tiger
Tiger Softwares
Software Designer and Developer
VB.NET, ASP.NET, VFP
|
|
|
|
|
hi all,
i have to use crystal reports in my application but i havent experience before (did not use before)
can any body guide me where i have to start what are the steps ?
i tried to search on google and find many articles but i want to know from where i have to get start.
what are the steps and how to design crystal report
please guide me
Best Regards
Thanks in advance
Rameez
|
|
|
|
|
|
Thanks for reply ,
plz write the few steps what i have to do for using crystal report in my application.
where i have to start. Is that true that i have to install crystal report 9 or 10 for designing reports then how i call that designed report into vb.net 2.0 application
Any suggestion or guidance is highly appericated
Best Regards
Rameez
|
|
|
|
|
I tend to collate the data for the report into a Typed DataSet from within my VB.NET program then pass the DataSet to Crystal Reports, which means that you are only using CR to present and sort the data as required.
Visual Studio comes with a version of CR as standard, but if you what the full blown product you will need CR XI Developers Edtion Service Pack 0 or CR 2008 Developers Edtion Service Pack 0, depending on whether you are using Visual Studio 2005 or 2008 (not sure if CR 2008 integrates with VS 2005), but the Crystal Reports Support people should be able to answer that question.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Steven J Jowett wrote: not sure if CR 2008 integrates with VS 2005
Yes it does 
(we use it at my work so...)
|
|
|
|
|
I can not figure out how load the file into my bitmap without getting an error with Option Strict set to ON (It works fine with Option Strict OFF .. )
<br />
Public BitmapImage As Bitmap<br />
<br />
BitmapImage = Bitmap.FromFile(filename) <br />
<br />
' where file name is soemthing like<br />
' "C:\Project\Prolasspecial.bmp"
What's the "correct" way of coding this, so that Option Strict On will not complain  ??
Georg
|
|
|
|
|
Option Strict OFF is the same as 'I am not a programmer'.
The problem is simple. Bitmap.FromFile returns an image, not a bitmap. Yes, this is stupid.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
I understand that .fromFile returns an Image = question remains what's the correct function to use to load my Bitmap file into my bitmap ??
How do I Convert it?
I goggled it - but it seems everybody else has figured this one out or the offered solutions seem rather "complicated" to me
Im I using the wrong Load function ?
Is there a direct conversion from Image to Bitmap?
Whats the "proper" way of doing this?
Do I need to load it into an Image first and then use a conversion ???
Georg
|
|
|
|
|
Christian Graus wrote: The problem is simple. Bitmap.FromFile returns an image, not a bitmap. Yes, this is stupid.
Well...not entirely since FromFile is actually inherited from the Image class.
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines]
Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
The Bitmap class has a constructor that takes a path to a file and a constructor which takes an image. The best option would be something like this:
Public BitmapImage As Bitmap
BitmapImage = New Bitmap(filename)
' or
BitmapImage = New Bitmap(Bitmap.FromFile(filename)) I think the first option is simpler.
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines]
Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
Thanks - you guys are great!
I knew there had to be a simple solution .... 
georg
|
|
|
|
|
Georg Kohler wrote: Thanks - you guys are great!
I knew there had to be a simple solution ....
You're welcome. Best place to look first is always the documentation. 
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines]
Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
Hi
I want to catch the IHTMLElement2.onscroll even and using the following code:
AddHandler aBody2.onscroll, New mshtml.HTMLElementEvents2_onscrollEventHandler(AddressOf Me.aBodyEvents_onscroll)
but VS2008 is saying that onscroll is not an event of IHTMLElement2, please tell me how to attach to this event.
Another approach I used is as following:
This event is appearing as an object to IHTMLelement2 object and when I declare an instance of HTMLElementEvents2 using following:
Dim WithEvents aBodyEvents As HTMLElementEvents2_Event
aBodyEvents = DirectCast(document.body, HTMLElementEvents2_Event)
then VS2008 is showing that it has the onscroll event but it doesnt fire at all.
Please help me.
Thanks and Regards,
MAP Tiger
Tiger Softwares
Software Designer and Developer
VB.NET, ASP.NET, VFP
|
|
|
|
|
Hi
It is solved now, Thanks.
Thanks,
MAP Tiger
Tiger Softwares
Software Designer and Developer
VB.NET, ASP.NET, VFP
|
|
|
|
|
In VB.NET or C# can I pass a routine or a function to another routine or function? If yes, how?
|
|
|
|
|
Yes, it is called a delegate. It in essence allows you to create a variable that is an actual function pointer and pass that to a routine or function.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
