Hi,

Users on this forum are very helpful and would help you any way they can. You will get a better response by creating a new post in the forum.

Anyways, have you started the app yet? Is...

I worked out one solution - its a bit slow but works.


myCell = "A3"
OneChar = 0
With objWorksheet.Range(myCell)
For i = 1...

Hi,

I am wanting to get some data from an Excel spreadsheet. My problem is the data in the cell has been formatted.

i.e. This is sample text.

I want to be able to know which bits are made...

Thanks for your reply.

This is what I have gone with:

Option Explicit

Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As...

Hi,
Probably a noob question but How would I find out the length of a file in bytes. within VB there is a LOF() command I can use once the file is opened. Is there an equivilant in C.

Thanks for...

Hi,

I have an array that contains 5 elements:

i.e.
a(0) = "A"
a(1) = "B"
a(2) = "C"
a(3) = "D"
a(4) = "E"

Hi,
I don't get an error but found out what the problem is.

It is the hosting company. I had to use an email address for the 'From' that included my domain.
i.e domain: www.purplegerbil.co.uk...

Hi,

I have the following code:

<%
Dim myMail
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Information from website"
myMail.From="mymail@hotmail.com"...

Hi,

The problem is the End If you have added.

see below:


Private Sub RandomNumbers()
Dim intTemp As Integer
Randomize 'generate random numbers

Thanks for your reply. I will give it a go on Monday (work). I'm new to VB.NEt. In the process of moving from VB6.

The link you added looks great as well.

Cheers,
PG

Hi,

I have a class that runs an external ap using shell then waits till the app is quit before carrying on.

Does anybody know if it is possible to start an app say by clicking a button then be...

I'm sure someone will do your project for you. Do they get your grade as well?

I think not.

Have a go yourself. If you get stuck on some code, post it here and some one will be glad to help you...

Hi,

You could also check to see if the file exists:

isFile = Dir(FILENAME)

isFile will be blank if the file is missing or contain the filename if it is there.


pG

Hi,

Heres a small example for you

pG

Hi,

I have used the following code to add a new field to a database. Is there a way to stop this field having a Null value but still keep it empty?


strSQL = "SELECT * FROM cells ORDER BY...

The EndIf it the wrong side of the close statement.

How does MzTools know which order you want the tabs to be in?

Not sure if this is what you are looking for:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/shell/reference/functions/shbrowseforfolder.asp

Hi,
I am wanting to break my app up in to modules so when someone comes to buy it they can select which 'modules' they want as part of the package. If any new modules are created these can be put in...

Hi,
As for VB6 I use:
Visual basic 6 - Programmer Reference
by Dan Rahmel
Osborne Books - ISBN 0-07-882576-8

Pg

Hi,
I have written an application using a MDI. This is working well. Within the toolbar it has over 10 buttons each opening a different window within the MDI. In the future I will be adding more to...

I am using the following code to load a string of text from a file.

cCnt = 0
fFree = FreeFile
Open txtDatafile.Text For Input As #fFree
Do
...

Once you have created a temp folder, double click setup1.exe.
Click on to browse and locate the temp folder you created.
Do the same with setup2.exe

Have a look in the temp folder for setup.exe...

Hi,

Have a look at this tutorial.

http://www.timesheetsmts.com/adotutorial.htm (http://www.timesheetsmts.com/adotutorial.htm)

Hope it helps

pG

Hi,

Download setup1.exe and setup2.exe into the same folder.

Create a temp folder.

Run setup1.exe and point to the temp folder
Run setup2.exe and point to the temp folder

Now go to the...

I have started to use this instead of the Package & Deployment wizard supplied with VB6.

Here is a link to the Visual Studio Installer:...

Its a strange one this. I cannot recreate the error on my pc.

what about
lenBigString = len(BigString)-1
BigString = Left(BigString, lenBigString)



have you got BigString defined?

Hi,

You havent done a check to see if BigString contains anything in it.

lenBigString = len(BigString)
if lenBigString <=1 then
msgbox "Invalid String"
end if

pG

no pun intended :)

This is a bit basic but might help.


pG

Have a look at this


pG

Hi,

A couple of ways you could dop this:

1. From Form2, you could

label1.caption = Form1.Text1.Text

Thisill copy the text from Text1 on Form 1 to the Label on Form2

Hi,

A program I am writing has the user entering values into textboxes then clicking an 'Add' button. Once clicked one of the textbox values appears in a list box.

e.g Job Number, Data...

Hi,

Here is an example of what you are looking for. This can be easily changed so other controls can be used.



pG

Hi Ann,

To create an install program for your project, run the Package & Deployment Wizard. This can be found in the tools folder. (Start bar... All Programs... Microsoft Visual Studio......

Hi,

If I am reading it right, you want to be able to open another form when a user clicks onto a line of the FlexGrid.

Option Explicit

Dim myRecord As Long

Private Sub...

Hi,

Thats the route I have gone down, open the word doc and save it as an RTF. The user isnt actually going to be able to edit the document. The app I have written opens the file and added control...

Hi,

Is it possible to open a M$ Word doc in a RTF box?

I thought of opening the doc in word and saving it as temp.rtf then opening that file in my rtf box, this would be a poor way of doing...

Hi,

Had a quick look at the code, endingbal = tempbb+tempda.
This figure will always be the same because tempbb and tempda are set out of the for...next loop.

You may need to add something...

Dim i As Integer
Dim myDate As String

List1.Clear
List1.AddItem Text1.Text
For i = 1 To Val(Text2.Text)

myDate = DateAdd("d", 7 * i, Text1.Text)

...