Why don't you make a copy instead? Or do you just want to copy sheet1 from Excel1 to Excel2?

Hi vb5prgrmr

No you cannot do that :)

Seems like you missed my previous post....

Check post 10

No. You can only redim the last element of an array...

Before you do that, you need to dim it as follows

Dim arrNames() as string
and then
ReDim arrNames(0 To u) as string

For example

Private Sub Command1_Click()
Dim arrNames() As String

Did you go thru my post?

@KSS: That thread is 5 years old :)

The original poster must have already got the answer by now...

Also I will never recommend DAO. ADO is much faster ;)

Hi Russel

Since the thread is already solved, I feel you need to also know why this happens... This is just for your FYI...

When using Preserve keyword, you can resize only the last array...

First things first

Change this line
List1.AddItem "FOUND: " + v
to
List1.AddItem "FOUND: " & v

and then add one more line after that

Exit For

You missed out on one of the most important suggestion what your other friend gave ;)

use a flexgrid instead of listview.........

http://www.vbforums.com/showpost.php?p=3481380&postcount=3

Oh Ok I understand :D

Is this what you want?

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
If UnloadMode = vbFormControlMenu Then
Ret = MsgBox("Do You...

It not only disable's the close button but also removes the 'close' option from the form's shortcut menu ;)

The API is very simple... All you need to do is copy and paste the code in the general...

I have always loved the power of API's :D

This will help you...

Private Declare Function SHFileOperation Lib "shell32.dll" _
Alias "SHFileOperationA" (lpFileOp As SHFILEOPSTRUCT) As Long
...

Text1.Text = Format(DateAdd("m", Val(Text2.Text), Text1.Text), "dd-mm-yyyy")

Glad to have helped :)

Do remember to Mark your Thread "Solved", if the query is solved... ;)

Give me a moment...

Edit:

Ok I have checked the code again, it works fine... Can I see your project?

The problem starts here

toclear = toclear + "1"

and then continues to

toclear = toclear + "0"

and finally to

I have replied to your other post... It will give you a start... Incase you get stuck let me know.... :)

Hi Blocker

This works for me...

I have made few changes in the code to show it as an example. Please make relevant amendments for your original code...

Private Sub Command1_Click()
Dim...

Hi rabbithaveit

I would suggest the API way as it gives you more flexibility... See picture attached...

Please place a Command Button on the form so that you can exit.

Paste this code in the...

Hi hkdani, you don't need to "Microsoft Shell Controls and Automation reference" to just tackle the "date time window" in control panel. The code that I gave above is good enough :)

what do you mean by the above?

BTW your above code is correct for "differences"

You are welcome :)

try with "Set"

Set Me.Sections("Section2").Controls("imgEmployee").Picture = frmMain.imgPic.Picture

To capture the image of the form, try this, Create two forms.. Form1 and Form2. Place a commandbutton in form1 and picturebox control in form2.

Code for Form1
Option Explicit

Private Declare...

If you are looking to interact with it then my suggestion is that you use the inbuilt calendar of vb6....

else here is the code

Private Sub Command1_Click()
'~~> launces the date time...

Reading the contents of text file is not a problem. i couldn't understand your rest of the query... Do you mean that if there is a word "True" in your text document which if found, you want to...

You are right that it runs only applications. Even if you mention the filename with the path and the corresponding exe ("c:\program files\adobe\adobe.exe aa.pdf") or as a matter of fact...

Sure, I'll give the code in the evening when i come back from office.... Leaving for office now :-)

Try using commondialog controls with FSO (file system objects....)

Call statement Transfers control to a Sub procedure, Function procedure, or dynamic-link library (DLL)procedure.

I believe that you cannot use "CALL" to call a file which is not executable.
same...

ADO is supposed to be quick...

is your table indexed??? (I am assuming that you are aware of how to set a relationship with the database using ADO so i am not checking that....)

will be back...

Have you checked your nearest software dealer??

In case you want it to buy online then simply click the link below or copy and paste the link in your browser...

you'll find plenty of choices......

hmmm

there goes my idea of playing with strings.... ;) is it still insecure if we define those constants in activex controlls??? can they be reverse engineered?

anyways anxiously waiting for...

Simply because, data stored in a access database can be hacked easily... I have a software which can decode the password protected access database...

Would really appreciate if you can send me the...

yes i want to save the username and password in a text file and not in a database.

i want the username and password both to be encrypted. when anyone opens the file in a note pad it should somehow...

I didn't find creating login screens and saving the data in access database difficult...

However, I was wondering if there is any other way we could do that, i mean saving the username and...