Its all your selection to replace the file or not.
But you avoid this message box from excel.
After you create an instance of excel ie,
Set xln = CreateObject("Excel.Application")

Add the...

This link will be helpful to you
http://support.microsoft.com/kb/213798

Instead of
Me.CommonDialog1.ShowOpen

you can use
Me.CommonDialog1.ShowSave

This will open the save dialog box.

If you post the complete code then I can check why it is taking long time

These two errors can be fixed by the following condition
FilNam = Me.CommonDialog1.Filename
If FilNam =False Then
Exit Sub
End If



Use the Filter Property to ".xls"

WAN is a wide area network such as Internet.

so you may want to make your application, a web application.

But if you want a stand alone application that connects to database over the internet,...

you can do
r_date = 0

If the user can select more than one email address, its better to use a list box. You can use <SELECT multiple> <OPTION></OPTION></SELECT> tags to achieve this.

In Visual Basic Tools, there is a tool for creating setup files.

In VB by default all variables will be passed by reference unless you explicitly pass it by value (using 'ByVal' keyword). I think you better use a public variable defined in a common module.

I can two problems with your code.

1. There is no End Sub for the sub routine ' Private Sub cmdRectangle_Click()'

2. In the function ' Public Function NewPointOnRectangle' you have defined a...

You are right hopalongcassidy (http://www.daniweb.com/forums/member212423.html). I was just telling this to macy2323 (http://www.daniweb.com/forums/member217592.html)

In Excel, you cannot change the value of A, B, C, .... which appear on top of each column.

Yes you will get an error. To prevent this check the value in the textbox with IsNumeric() function.

If IsNumeric(Text1.Text) Then
'continue with the code
Else
msgbox "Invalid Number"
...

If you are talking about a client server kind of application, you can run the vbprogram on your machine and keep the database on the server.

If you really want to run the application from the...

Exactly what do you want to know? :confused:

You want help on how to do something in vbcode? or you want somebody to implement all your business logic in vbcode?

How about trying the following way???


Dim Value As Double
Dim IntMaxValue As Integer
Dim LongMaxValue As Long

IntMaxValue = 32767
LongMaxValue = 2147483647

Yomet, you are most welcome

I can suggest two methods that may work for you.

1. do some vbscripting to extract the required columns from both text files and save it as two files say file1.txt and file2.txt
Now run the...

rs.open "SELECT C2 FROM Table_Name"

C2R1 = rs("C2")

rs.MoveNext

C2R2 = rs("C2")

compare C2R1 and C2R2

Using the following API function you can get it!!

Private Const ABM_GETTASKBARPOS = &H5

Private Type RECT
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type

Use the macro recording feature of Excel; you can find it yourself :-)

CSV file is a text file. So you don't need to use a spreadsheet for opening the file.

You can open the CSV file with the following code

Dim ObjFso
Dim ObjInputFile
Dim StrOneLine
Dim...

If you have same column name in two tables you must refer the column by [Table Name].[Column Name]

Try this query.

adobau.RecordSource = "SELECT Liegenschaften.name,Liegenschaften.address,tblbau.date FROM Liegenschaften INNER JOIN tblbau ON Liegenschaften.Rimo_Liegnr = tblbau.Liegenschaft"

Where do you import the data from? Is it from a database? What database?

Also you are mentioning that the volume is huge. Give an approximate number of records, you are trying to import or export.

Since the variable 'ID' is a string variable you need to wrap the value with single quotes like the following.

sql = "SELECT * FROM QnE WHERE Question='" & ID &"'"

Final Data is one of the best recovery software

http://databases.aspfaq.com/database/how-do-i-retrieve-a-random-record.html

Change this to
Me.lstPrijs.AddItem (xlSheet.range("h5").Value)

If you are writing vbcode in the MSAccess module (access macro), then you can access the variable from vb.

Also one more thing to be noted here is the data type of 'fac_type'. If it is an integer...