Visual Basic Discussion Boards

Re: How to create my own spammer with VBscript

Sander Rossel2-Oct-11 0:16

Sander Rossel

2-Oct-11 0:16

It's an OO world.

public class Naerling : Lazy<Person>{}

Re: How to create my own spammer with VBscript

Richard MacCutchan2-Oct-11 1:49

Richard MacCutchan

2-Oct-11 1:49

I do like the subtleties in your use of language.

Unrequited desire is character building. OriginalGriff

Re: How to create my own spammer with VBscript

Dave Kreskowiak2-Oct-11 1:57

Dave Kreskowiak

2-Oct-11 1:57

Your asking a bunch of people who HATE spam with a passion how to write something that send that stuff out?? And you call us "friends"??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: How to create my own spammer with VBscript

Bert Mitton3-Oct-11 3:10

Bert Mitton

3-Oct-11 3:10

Thanks for the laugh. It's a rough Monday morning, and I needed it.

Playing with services

DeDelva30-Sep-11 2:15

DeDelva

30-Sep-11 2:15

Hello All,

I'm playing with interactions between excel and vb.net...

Everytime i start an excel application it become's one of my processes in my taskbar.

I always put my vars from workbook,sheets,app to nothing at the end
i collect my garbage

But wath do i forget to dispose this from the services??

I'm kind a noob so can somebody provide me some help?

I just want to clean up after using...

oSheet = Nothing
           oBook = Nothing
           oExcel.Quit()
           oExcel = Nothing
           GC.Collect()

Thx in advance

Re: Playing with services

Dave Kreskowiak30-Sep-11 3:36

Dave Kreskowiak

30-Sep-11 3:36

Read this[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Playing with services

DeDelva2-Oct-11 2:12

DeDelva

2-Oct-11 2:12

Hey,

Thx Dave it was a really helpfull article.

Can you check if i forget something?(maybe in my catch blok or something?)

        Dim oApp As New Excel.Application()
        Dim oBook As Excel.Workbook = oApp.Workbooks.Add
        Dim oSheet As Excel.Worksheet = oApp.ActiveSheet
        Dim chartRange As Excel.Range

        'hoofding
        chartRange = oSheet.Range("A1", "I1")
        chartRange.Merge()
        chartRange.FormulaR1C1 = "WorkBook"
        chartRange.Font.Bold = True
        chartRange.Font.Size = 20
        chartRange.HorizontalAlignment = 3
        'chartRange.VerticalAlignment = 3

        'Save the Workbook
        oBook.SaveAs(sSampleFolder & "V.F." & idvoorexcel & "-" & Label6.Text & ".xlsx")

        oSheet = Nothing
        oBook.Close(False)
        oBook = Nothing
        oApp.Quit()
        oApp = Nothing
        System.Threading.Thread.Sleep(3000)

    End If
Catch ex As Exception
    MsgBox("location : catch blok")
    oSheet = Nothing
    oBook = Nothing
End Try

Greetings

Re: Playing with services

Dave Kreskowiak2-Oct-11 4:52

Dave Kreskowiak

2-Oct-11 4:52

Yeah, I see no mention of Marshal.ReleaseComObject().

You might want to go back and re-read the article.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Playing with services

DeDelva12-Oct-11 8:59

DeDelva

12-Oct-11 8:59

Hey i'm back from a student holiday

Thx for all the answers i will vote 4 them...
I posted the wrong code snippet

here is the code that i wanted to post :

Imports Microsoft.Office.Interop
Try

                Dim oApp As New Excel.Application()
                Dim oBook As Excel.Workbook = oApp.Workbooks.Add
                Dim oSheet As Excel.Worksheet = oApp.ActiveSheet
    
                chartRange = oSheet.range("A20", "G20")
                oSheet.Range("A20").Value = "blabla"
                chartRange.BorderAround(Excel.XlLineStyle.xlContinuous, _
                Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex. _
          xlColorIndexAutomatic, Excel.XlColorIndex.xlColorIndexAutomatic)

                'Save the Workbook and quit Excel.
                oBook.SaveAs(sSampleFolder & "V.F." & idvoorexcel & "-" & Label6.Text & "-" & DateTime.Now.ToString("ddMMyyHHmmss") & ".xlsx")
                oSheet = Nothing
                NAR(oSheet)
                oBook.Close(False)
                NAR(oBook)
                oBook = Nothing
                oApp.Quit()
                NAR(oApp)
                oApp = Nothing
                System.Threading.Thread.Sleep(1500)
            End If
        Catch ex As Exception
            NAR(oSheet)
            oBook.Close(False)
            NAR(oBook)
            oSheet = Nothing
            oBook.Close(False)
            oBook = Nothing
            System.Threading.Thread.Sleep(1500)
            GC.Collect()
        End Try
    Private Sub NAR(ByVal o As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(o)
        Catch
        Finally
            o = Nothing
        End Try
    End Sub

By the way nice link with the NAR

Still don't know if i oversaw something?

Thx D Thumbs Up | :thumbsup:

Reading pdf file

Anu_Bala29-Sep-11 20:52

Anu_Bala

29-Sep-11 20:52

Hi,

I want to make one application that reads the pdf file and write that data in to excel sheet and after i have to make a chart in excel sheet.

Here, my problem is ,i do not know how to read the pdf file in VB .Please kindly help me by giving some solution or is there any tutorial or article related to this concern.

Anu

Re: Reading pdf file

Richard MacCutchan29-Sep-11 22:23

Richard MacCutchan

29-Sep-11 22:23

Anu_Bala wrote:
any tutorial or article related to this concern.

Yes plenty[^].

Unrequited desire is character building. OriginalGriff

Re: Reading pdf file

Dave Kreskowiak30-Sep-11 3:31

Dave Kreskowiak

30-Sep-11 3:31

I don't know why you were down-voted, it was a perfectly legit answer.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Reading pdf file

Richard MacCutchan30-Sep-11 6:22

Richard MacCutchan

30-Sep-11 6:22

Dave Kreskowiak wrote:
I don't know why you were down-voted

The usual reason I expect! However, thanks for your high value vote.

Unrequited desire is character building. OriginalGriff

Re: Reading pdf file

Anu_Bala2-Oct-11 19:29

Anu_Bala

2-Oct-11 19:29

Actually what your are all talking about.I did not vote for anyhting.May be by mistake it get voted.where i can put vote for your answer??

Anu

Re: Reading pdf file

Richard MacCutchan2-Oct-11 21:23

Richard MacCutchan

2-Oct-11 21:23

Go to the answer message and click on one of the numbers on the right hand side; 1 for bad, 5 for good.

Unrequited desire is character building. OriginalGriff

Multilanguage support in VB6

MURALI RANGANATH29-Sep-11 20:25

MURALI RANGANATH

29-Sep-11 20:25

Hi,

I am trying to create a billing application. In this I need multilanguage support. I have to use Telugu, by which user will be entering the data to fill the form. How do I create an application with Telugu supporting.

Kindly let me know, are there any such samples, so that I can refer and build the application.

Thanks,
Ranga

Re: Multilanguage support in VB6

Dave Kreskowiak30-Sep-11 3:30

Dave Kreskowiak

30-Sep-11 3:30

Your bigger problem is why are you using VB6 in this day and age for new developement??

VB6 is dead and there won't be any support for it's runtime in Windows 8. Your app is already obsolete and you haven't even finished writing it! Pickup VB.NET and start there before you really screw yourself over having to rewrite this app soon after you release it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Multilanguage support in VB6

Eddy Vluggen30-Sep-11 6:36

Eddy Vluggen

30-Sep-11 6:36

As mentioned, VB6 isn't for sale anymore. Unlike languages as Pascal or C, VB6 is owned by Microsoft and they have decided to decapitate it. That's happened quite a few years ago, which explains why you're having a hard time finding examples.

Furthermore, VB6 comes from an era where we didn't use UTF8 everywhere. Your best bet would indeed be to move to VB.NET; you can still use most of the old syntax, and multi-language applications are very well supported.

VB.NET is available for free, just as the IDE is. VB6 isn't available. Not for free, not for money.

Bastard Programmer from Hell Suspicious | :suss:

Re: Multilanguage support in VB6

Dalek Dave1-Oct-11 22:46

Dalek Dave

1-Oct-11 22:46

Use VB.Net, VB6 went the way of the dinosaurs.

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

CCC Link[^]
Trolls[^]

Re: Multilanguage support in VB6

Paul Conrad2-Oct-11 19:46

Paul Conrad

2-Oct-11 19:46

VB6 been dead for a long time. You better off using something like VB.Net instead.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Combobox Problem

Lek Plepi29-Sep-11 2:15

Lek Plepi

29-Sep-11 2:15

Hello
I have a small problem with combobox.
So the form has a panel with optionbuttons and dependin on the click of user,the combobox will display various items.
the problem is that how often i click the optionbutton,in the combobox the items are being replaced.alfer a few clicks the combobox is full with duclicated names.
how can i avoid this?

i use this code for optionbutton

Private Sub Option1_Click()
Label7.Caption = "Përdoruesi"
Call DB
ar.Open "Select *From tblPerdoruesit", strConek, adOpenStatic, adLockOptimistic
If ar.RecordCount = 0 Then
Exit Sub
Else
ar.MoveFirst
Do While Not ar.EOF
cboSubjekti.AddItem ar!EmriUser
ar.MoveNext
Loop
ar.Close
End If
End Sub

Re: Combobox Problem

JR21229-Sep-11 7:14

JR212

29-Sep-11 7:14

Where do you 'clear the combobox

combobox.items.clear???

Jan

Re: Combobox Problem

Lek Plepi29-Sep-11 21:35

Lek Plepi

29-Sep-11 21:35

Thank you for the help.
i used this code : cboSubjekti.Clear

edit web.config at runtime

C#Coudou26-Sep-11 22:50

C#Coudou

26-Sep-11 22:50

hi,

i can change the web.config at run-time because its just like a text file.
is my approach is good thing to change at run-time?

the goal is to change database when the user clicks
a radiobutton, let say, rdoDB1 and rdoDB2.

the problem is grid are not reflecting to the new database but when i close the page then start again,
grid shows data with new database which set in web.config.

thanks in advance for your time.

C# コードMicrosoft End User
2000-2008

「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Re: edit web.config at runtime

C#Coudou27-Sep-11 0:13

C#Coudou

27-Sep-11 0:13

sorry, i figure out already, i just create two connection string.

thanks

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.