Visual Basic

EliottA13-May-10 4:25

EliottA

13-May-10 4:25

I can't without knowing what the variables ThisWorkbook and ActiveSheet are.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

The Man from U.N.C.L.E.13-May-10 6:48

The Man from U.N.C.L.E.

13-May-10 6:48

Call is a deprecated code word and should never be used. It is only there to support migration of code from non-object orientated VB6 applications. Get rid of it and you code will probably work.

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
[My Articles] [My Website]

Trevortni13-May-10 8:46

Trevortni

13-May-10 8:46

I didn't realize Excel was so badly endangered, but if you think this code will somehow manage to save it, then by all means do what you can.

EDIT: Sorry, couldn't resist.

how to insert jpegs into powerpoint via vb.net

Johnny J.13-May-10 21:54

Johnny J.

13-May-10 21:54

DAMN, I would have answered exactly the same, but you beat me to it...

Laugh | :laugh:

b-rad31112-May-10 5:39

Re: how to insert jpegs into powerpoint via vb.net

12-May-10 5:39

Hi,

Does anyone have a link showing how to insert images into a powerpoint presentation using vb.net?

Thanks,

Kschuler12-May-10 10:25

Kschuler

12-May-10 10:25

Did you try a google search?[^]

I found this article[^] which looks like it could help you out.

Re: how to insert jpegs into powerpoint via vb.net

b-rad31112-May-10 10:27

how to save clipboard image as picture using vb.net

12-May-10 10:27

Thanks Kschuler!

b-rad31112-May-10 5:17

Re: how to save clipboard image as picture using vb.net

12-May-10 5:17

Hi everyone,

Does anyone know how to save an image from the clipboard as a picture (jpef, png, etc). using vb.net code?

Thanks!

Luc Pattyn12-May-10 5:32

Luc Pattyn

12-May-10 5:32

b-rad311 wrote:
Does anyone know how to save an image from the clipboard as a picture

That is almost perfect VB code, use the Clipboard class and the Image class, the GetImage() method and the Save() method. What could possibly be the problem?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

Re: how to save clipboard image as picture using vb.net

b-rad31112-May-10 5:34

Re: how to save clipboard image as picture using vb.net

12-May-10 5:34

Hi Luc,

Thanks for replying. I'm new to vb so I was looking for specific examples of how to do this. However, I just found a specific example online, so I've got it now.

Thanks

Luc Pattyn12-May-10 5:39

Luc Pattyn

12-May-10 5:39

b-rad311 wrote:
I'm new to vb

I hope you mean VB.NET (VB6 and earlier are stinkin' dead and should remain buried).

You should buy and study a book when you're new to a language; it is the fastest way to make real progress, and the only way to learn it properly. And then read up again on the classes you intend to use. We both have named them already.

If all that is not going to happen, the least you should do is search CodeProject for some articles that deal with your topic; there are some 20K articles here, lots of them are pretty good.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

Re: how to save clipboard image as picture using vb.net

b-rad31112-May-10 5:41

Wise InstallMaster to create setup file

12-May-10 5:41

Yes, vb.net is what I meant.

Andraw Tang12-May-10 5:03

Andraw Tang

12-May-10 5:03

Hi, dear all,

I know this is wrong place. but I really don't where I should post the question.

I am working on a VB6 project created years ago which use Wise InstallMaster to create installation file. I totally have no idea about it.

If you know anything about it, please tell me. If you can give me some tutorial link, that's best.

Re: Wise InstallMaster to create setup file

Dave Kreskowiak12-May-10 5:25

Dave Kreskowiak

12-May-10 5:25

You haven't asked an answerable question. You want someone to tell you how to use a dead piece of software? Symantec now owns the Wise suite of products. You're best bet is to peruse their site and see if you can find the documentation on it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: Wise InstallMaster to create setup file

Andraw Tang12-May-10 5:31

Andraw Tang

12-May-10 5:31

Dave,

Thanks for your instruction.

Excel open

MsmVc12-May-10 2:41

MsmVc

12-May-10 2:41

Hi All

How can i open excel file with password option?I have a excel file "Test.xls" which is password protected.I know password,i want to open "Test.xls" through code.Please help me

Re: Excel open

EliottA12-May-10 2:50

EliottA

12-May-10 2:50

'fileName = full location of your excel document

Public Sub OpenExcel(byval fileName as String)
    Dim ExcelInstance As New Microsoft.Office.Interop.Excel.Application()
    Dim File As New System.IO.FileInfo(fileName)
    ExcelInstance.Workbooks.Open(File.FullName, , , , "password", , , , , , , , , , )
End Sub

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Import the Data From Excel File

Anubhava Dimri12-May-10 1:33

Anubhava Dimri

12-May-10 1:33

Hello Everybody,

I have a listbox in which i want to get the data from Excel Data Sheet. So I am writing code for getting data from excel file to Listbox.I am Providing Range From (A1:A100000) to (XFD1:XFD100000). But it takes a lot of time.So Please help me.

I have a secondry question How to Check Excel Datasheet is Empty.

If you can think then I Can.

riced12-May-10 2:10

riced

12-May-10 2:10

eg_Anubhava wrote:
I am Providing Range From (A1:A100000) to (XFD1:XFD100000). But it takes a lot of time.

Calculate how many Excel cells that is. It would then probably come as no surprise that it takes a lot of time, epecially to fill a listbox.

Without seeing any code it's impossible to suggest how this might be improved.
As to the second question, IIRC correctly, Excel has a UsedRange function (or something similar) that might be helpful.

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.

Anubhava Dimri12-May-10 22:26

Anubhava Dimri

12-May-10 22:26

Thanks Sir

It works Fine but i have generate a second question regarding same topic.

While i am using the Import data from Excel to List there are Excel Applications will be open.

So please describe me how to close it.

If you can think then I Can.

riced13-May-10 0:01

riced

13-May-10 0:01

Assuming you've got something like this:

Dim objExcel As Excel.Application = Nothing
objExcel = New Excel.Application

Then something like this could do it:

If Not (objExcel Is Nothing) Then
   objExcel.Quit()
   objExcel = Nothing
End If

Anubhava Dimri13-May-10 0:37

Anubhava Dimri

13-May-10 0:37

Thanks Dear

Actually i was finding the close or exit method.

If you can think then I Can.

Dave Kreskowiak12-May-10 2:19

Dave Kreskowiak

12-May-10 2:19

eg_Anubhava wrote:
I am Providing Range From (A1:A100000) to (XFD1:XFD100000). But it takes a lot of time.

Seriously?? What user on this earth would want to look through a ListBox with BILLIONS of items in it?? Rethink what you're doing and how your user interface is going to work.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...