Type: Posts; User: luca90
Search took 0.03 seconds; generated 18 minute(s) ago.
my actual var PERC=88 ICO return 4?????
should ICO be 1 .... from >=90 and <=100
i need to set this step of value is correct?
note: the var MYarray is dimensioned As Long
MYarray >0 and <=50 then ICO=4
MYarray >=50 and <=75 then ICO=3
MYarray >=75 and <=90 then ICO=2...
Me.LDAL.Caption = Format(mystring, "DD/MM/YYYY")
but dont work!
i have mystring="31102014"
how to convert in mydate=31/10/2014
mystring as String
mydate as Date
not all users have the same path where the winzip32.exe is stored....
i have see in Google is possible to set automaticlly the Zip path with "namespace" but wath is this?
Shell "C:\Program Files\WinZip\winzip32 -e -o \\DIR1\FS\GO\DATABASE\FILE\sportl.exe \\DIR58\FS\GO\DATABASE\CAB_DBF\", vbHide
resolved my self.... tks to the all!
yes, is a self extracting archive file then yes you just need to shell it.
can you post an example to extract in c:\mydir\
with vb6 classic in with vb6, are you satisfied:-)
it contain a simple compressed files.
Similar: cdd.dbf, Intsall.bat, myico.ico...
I need to extract all files from c:\mydir\Myexe.exe in c:\mydir1\...
possible with vb6?
Based this link:ftp://ftp.bper.it/aggiorna/arksport/archivio.zip
i need to save the .zip file in C:\MYDIR\archivio.zip
How to in vb6 classic?
I have 3 Workbooks in the same directory.
for example in c:\mydir\:
each workbook in Workbook_Open have a macro.
i need to open...
tks Dilettante & jmsrickland i canot test now, but tomorrow
in box "Codice ABI" of this page insert the value 01000
press button "ricerca"
I need, in this case to get the value of line: ABI: 01000 BANCA...
PIAZZA LEVI, 11 - 15011 ACQUI TERME (AL)
PIAZZA DELLA LIBERTA', 6 - 15100 ALESSANDRIA (AL)
VIALE INDIPENDENZA, 63 - 63100 ASCOLI PICENO (AP)
thi sis a lines in a txt file.
i need to devide...
Dim objIE As InternetExplorer
Set objIE = obj
how to set instead Internet Explorer object, Chrome or Firefox ?
exactlly this combination of valueS
AAA BBB 100
AAA BBB -100
No summ with algebraic... similar
AAA BBB 100
AAA BBB -75
I use ado and vb6 classic and access database...
in table have:
Field1 Field2 Field3
AAA BBB -100
AAA CCC ...
based this url...
i have in a field of access table a dates similar:
I loop all line of txt file with the tipical:
File = FreeFile
Open "C:\TAB\TATI.txt" For Input As #File
in txt have:
sorry i have just modified my first post, sse now.
I need to loop all lines in of email, possible?
HI Mark, the part of regex of your code, dont match the CB with numerical suffix....!!!!
i can send in pvt a part of m txt file?
know you a free tool for tath?
My usb hd not recognized !
Peraphs i have disconnected with the standard procedure: from try bar, disconnect the ysb hd ecc...
In other case i see it but when i double click: do you want go...
ok... in case i use the regex, wath is the correct pattern?
tks as usual.
in other case with this code, work only the like statement(?).
Dim File As Integer...
if i have understand to the end of discussion, the correct pattern is:
or i need to use simply the code :
If sCurrentLine & " " Like...
ok tks for code. but the number after CB not is fixed i can after CB, 123456, or 789456, or 548851 ...
see in my note.
I loop a txt to read line by line, with the tipical:
Open Path For Input As File
do While Not EOF(File)
i need to find (with REGUALR EXPRESSION) the line in txt where is...
How to compare the last modified date of two file in different dir of c:\mydir\.... and \\mylandir\
if effect i need to compare if the file in \\mylandir is newest respect the file in c:\
I need to insert in Private Sub Workbook_Open() a VBA code to copy a file from a lan dir similar :\\mylandir\database\my.mdb in local c:\mydatabase\my.mdb.
I know the vba code for this way.
Dim CONN As ADODB.Connection, RS As ADODB.Recordset
If CONN Is Nothing Then
Set CONN = New ADODB.Connection
I need to get and write in a specified cell of shee, from a closed workbook?
I use Vb6 Classic
I have in Workbook open event a code to show a userform.
Is possible to maintain active the userform and hide the Excel instance?
Where is the rs filled? i dont see in any part of your code, or not?
But, only to understand, why i need to remove, this oprtion?
Click Here to Expand Forum to Full Width
Survey posted by VBForums.