Visual Basic

24-Jan-03 6:01

Hi all!
how can I convert the number ( 42 ) to A
I mean in ASCII code 42 is an "A" so If I have number 42 how can I convert it into "A" in VB.
I know that in C++ I can used IsAlpha().

Thanks

SimonS24-Jan-03 7:05

SimonS

24-Jan-03 7:05

Hi Win

Here's the VB.NET code (hope this is the VB ver. you wanted):

Imports System.Text.Encoding
Imports Microsoft.VisualBasic

Module Module1

    Sub Main()
        Dim i As Integer = AscW("A")
        Console.WriteLine(i.ToString())
        Dim c As Char = ChrW(i)
        Console.WriteLine(c.ToString())
        Console.ReadLine()
    End Sub

End Module

Cheers,
Simon

"The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.
animation mechanics in SVG

pnpfriend24-Jan-03 7:21

24-Jan-03 7:21

Thanks Simon. That's exactly what I want.
Thanks millions....

SimonS24-Jan-03 7:36

SimonS

24-Jan-03 7:36

Cool, glad it helped.
The wierd thing is that MS/other seem to recommend not using the Microsoft.VisualBasic namespace as (I think) it uses interop in the background.

Perhaps keep this code in a single function so it won't be too much of a sweat to change later, if necessary.

I'll keep a look out for an alternative.

Cheers,
Simon

"The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.
animation mechanics in SVG

Nick Seng24-Jan-03 8:01

24-Jan-03 8:01

Hmmm.....isn't easier to use the Chr function??

Chr(65) = "A"

Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain

Get your facts first, and then you can distort them as much as you please
Mark Twain

Ray Cassick24-Jan-03 8:10

Ray Cassick

24-Jan-03 8:10

Would have been the way I would go.

Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."

George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."

pnpfriend24-Jan-03 9:41

generating report based on values in 2textboxes

24-Jan-03 9:41

I used Chr(). Thanks

mcm24-Jan-03 4:19

mcm

24-Jan-03 4:19

i had generated a report from a query in access (ie using the query as a datasource), and that worked fine. However, now i want to run the report based on the query in the database and 2 values (ie between 2 dates) in textboxes so i have hardcoded the following SQL statement behind the command button to generate the report. However, i do not know what to do from here - the SQL statement will be a datasource and datamember for what - the data environment? the command? the report? Thanking you!

SELECT DISTINCT Client.Company, OrderGenerate.OrderNumber, Sum(OrderDetail.Price) AS SumOfPrice
FROM (Client INNER JOIN OrderGenerate ON Client.ClientCode=OrderGenerate.ClientCode) INNER JOIN OrderDetail ON OrderGenerate.OrderNumber=OrderDetail.OrderNo
WHERE Date Between ' " & txtDateFrom.Text & "' and ' " & txtDateTo.Text & "'
GROUP BY Client.Company, OrderGenerate.OrderNumber

add new IE button in registry - vbs

Florin Ochiana23-Jan-03 21:04

Florin Ochiana

23-Jan-03 21:04

Hi,

I found the following code in the MSDN Articles. The title of the article is "Customizing Microsoft Internet Explorer 5.0". I don't know why it isn't working. It asks if I want to create the button but then it does nothing. Could you help me please?

Thank you

' AddButtonIE.vbs
' Adds a custom button to the Internet Explorer 5.0 toolbar
' -----------------------------------------------------------------------
rc = MsgBox("Would you like to add a new button to the toolbar?", vbYesNo)
if rc=vbNo Then WScript.Quit' The registry path where you add your new entries.
' If your registry doesn't contain a Shell node, it'll be silently created
REG_HKLM_IE50_BASE = "HKLM\Software\Microsoft\Internet Explorer\Extensions"' Adds a new key (needs a newly created GUID)
REG_HKLM_IE50_GUID = REG_HKLM_IE50_BASE & "\{10954C80-4F0F-11d3-B17C-00C0DFE39736}\"' Creates the required values
Set shell = WScript.CreateObject("WScript.Shell")
shell.RegWrite REG_HKLM_IE50_GUID & "ButtonText", "Run Script", "REG_SZ"
shell.RegWrite REG_HKLM_IE50_GUID & "MenuText", "Run Script", "REG_SZ"
shell.RegWrite REG_HKLM_IE50_GUID & "MenuStatusBar", "Run Script", "REG_SZ"
shell.RegWrite REG_HKLM_IE50_GUID & "Clsid", "{1FBA04EE-3024-11d2-8F1F-0000F87ABD16}", "REG_SZ"
shell.RegWrite REG_HKLM_IE50_GUID & "Default Visible", "Yes", "REG_SZ"
shell.RegWrite REG_HKLM_IE50_GUID & "Icon", "C:\Program Files\Home.ro\icon1.ico", "REG_SZ"
shell.RegWrite REG_HKLM_IE50_GUID & "HotIcon", "C:\Program Files\Home.ro\icon2.ico", "REG_SZ"
shell.RegWrite REG_HKLM_IE50_GUID & "Exec", "C:\Program Files\Home.ro\myprg.vbs", "REG_SZ"

-----
We are what we repeatedly do. Excellence, then, is not an act, but a habit.

Re: add new IE button in registry - vbs

Florin Ochiana23-Jan-03 23:08

Florin Ochiana

23-Jan-03 23:08

Sorry! My bad. It works fine.

-----
We are what we repeatedly do. Excellence, then, is not an act, but a habit.

get single cell name..

pnpfriend23-Jan-03 10:39

Re: get single cell name..

23-Jan-03 10:39

how to get the singel cell name in the sheet.
i = 1, j=2
Dim str As String
str = Cells(i, j).Name

I excepted str = "B1" but I got run time error...
Can anyone tell me why?
thanks

Nick Seng23-Jan-03 14:43

Re: get single cell name..

23-Jan-03 14:43

"B1" is not a cells name, that's it's position. You can give names to cells or a range of cells in Excel for the purpose of easing calculation. For example, if a cell has a value of 2.142.... and you name it PI, then in your formulas,you can refer to it as PI like so:
=B2 + PI which would make more sense.

So, the cell.name propert returns the name of the cell, not the position. If it doesn't have a name, you get a run-time error

Notorious SMC

pnpfriend24-Jan-03 4:28

24-Jan-03 4:28

Thank you SMC,
Can you please tell me how to get the position of the particular cell. and can you also check my following incorrect code please. I'm trying to wait for the user to close the excel application after they done with whatever they have to do to the excel file. where am i getting wrong and how to fix it.

<br />
    Dim idProc As Long<br />
    Dim hProc As Long<br />
    idProc = VBA.Shell("Excel", vbMaximizedFocus)<br />
    hProc = OpenProcess(PROCESS_ALL_ACCESS, False, idProc)<br />
    If hProc Then<br />
        Do While WaitForSingleObject(hProc, 100) = WAIT_TIMEOUT<br />
            <br />
            DoEvents<br />
        Loop<br />
        CloseHandle hProc<br />
    End If<br />

Thank you.

excel.sheet.setprintArea

pnpfriend23-Jan-03 4:49

23-Jan-03 4:49

Hello Gurus...

I want the exiting excel file to open it, format it and print it.

opening and formating part I have ( mostly) done ... but to printing giving me problems.. when the file get print, there are lots of empty pages because of the last cell.

let's say, the sheet contain only two cells that has some data. the first cell is A1 and the last cell is z130 and there are no data in the cells between first and last cells.

So when I call PrintOut method it prints all the empty pages.

I'm trying to set the print area for the excel sheet because I don't want to print empty pages. But how can i set the print area only to print that two cells???

I tried look every cells whether if it is empty or not, if empty don't do anything but if not empty, set the range and set the printarea... the following is my code..I know it is wrong but don't know how to fix it

<br />
<br />
Function SetPrintArea(sheet As Worksheet) As Worksheet<br />
    Dim r As Range<br />
    Set r = sheet.UsedRange<br />
    <br />
    Dim newRange As Range<br />
    Dim i As Integer<br />
    Dim j As Integer<br />
    <br />
    For i = 1 To r.Rows.Count<br />
        For j = 1 To r.Columns.Count<br />
            If Not Cells(i, j).Value = "" Then<br />
                newRange = newRange(Cells(1, i), Cells(i, j))<br />
            End If<br />
        Next j<br />
    Next i<br />
    newRange.Cells.Select<br />
    sheet.PageSetup.PrintArea = Selection.Address<br />
    Set SetPrintArea = sheet<br />
End Function<br />

Thanks

Nick Seng23-Jan-03 14:35

23-Jan-03 14:35

okay, I'm gonna ask the obvious question.... why are the only two cells in the sheet with the data so frikkin' far ????. That's gotta say something bout the design!

the Range object also accepts parameters in the form of a string, like so :
"A1:C5"
The above parameter would include everything from cells A1 to cells C5
But if you wanna do composite ranges, then the following string:
"A1:C5,D12:G7"
would include everything from the first string as well as everything from cell D12 to G7 and nothing in between.
I assume you could solve your problem by constructing the composite range string before hand, then pass it into the Range object

Hope that helps

Notorious SMC

pnpfriend24-Jan-03 3:30

24-Jan-03 3:30

You're damn right.. why do they do so?? Can't they just insert the information into the closer cells?? I, myself, want to know why they do that.. my job is to print that excel file..minimizing the number of pages that will print as possible.

Thank you for answer SMC, So how can i get the position of the cell?

Thank you

Nick Seng24-Jan-03 7:51

24-Jan-03 7:51

you're looping method seem to work fine.... just don't assign the cells into the range yet. Convert into the string version first, then after evrything has finished looping, assign the string into the range

Notorious SMC

pnpfriend24-Jan-03 9:39

24-Jan-03 9:39

thanks. I did the samething..
Is there anyway that I can find out whether the sheet(s) has any protection?? what if I don't know the password??

Thanks

Nick Seng26-Jan-03 14:31