Type: Posts; User: luca90
Search took 0.04 seconds.
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?
Set RS1 = New ADODB.Recordset
RS1.CursorLocation = adUseClient
RS1.Open SQL, CONN, adOpenStatic, adLockReadOnly, adCmdText
is this correct to open a recorset if my MDB reside over Lan...
AG DATA DIFF MASTRO POSIZ DCI
100 26/08/2014 10 20 10 111
100 26/08/2014 20 10 20 111/8
200 26/08/2014 10 20 10 111
table CASSA (result before query)
Hi West! tks! the code work perfect!
hi West the code work perfect! tks for tath.
But i need to get also the value with the arrow-
for test use the value circled in image attached.
but i dont know the way to put in the three box the related value of:
Codice ABI (es.: 03002)
Codice CAB (es.: 05085)
and press: calcola cin e iban
Based this url i need to get all value from the second page when i click, on:calcola cin e iban
to test use:
Codice ABI (es.: 03002)
Codice CAB (es.:...
TKS, but but i need to lop all files in dir1 and copy one to one in dir2...
I have 2 dir in c:\
i need to copy all files, "one to one", from c:\dir1\ to c:\dir2\, and overwrite if in c:\dir2\ just exists the files from dir1.
is possible, plese simple code.
i'm in Access Database:-)
SELECT DISTINCT TOP 3 cassa.[DATA CONT]
FROM cassa group by cassa.[DATA CONT]
ORDER BY cassa.[DATA CONT] DESC
i dont see the reference to table name.
I need to get the top three newest date in filed... hot to with sql?
or just expand any affected rows, but check before if one or more column have an active filter...
Ho to check if one or more columns have a filter active and if condition is true expand all rows?
in vba for excel please.
i need to loop 8.458 lines, and insert in the existing value of cells the icon on the right.!
i have posted a number range but i rially use a string not number....
But is really possible to insert to right of string in the same cell a icon from path?
I have a icon (gif) in c:\mydir\icons\ico1.gif
i need to insert this icon to the right of this value similar:
ws.Range("AG" & RIGA1).Value = Format(SDO, "#,##0.00")& " "&...
Simple, have a blank cell in range D2:H2 (E2 and G2 are blank) and D1;H1 (E1 and G1 are blank) this is the formula in J2;=trend($D2:$H2;$D$1:$H$1;$J$1).
The result in J2 is #VALORE!
Attached a simple sheet.
I need to calculate the trend pojection value in column I2 for the Agust 2014 based the month in D1,E1,G1 and values in D2,E2,G2?
If is possible in vba code, tks.
But peraphs stupid question....
i have a .mdb in c:\mydir\test.mbd
possible to execute sql query via batch or shell command?
I open a workbook from a click button in a vb6 form with:
Sub OpenWb(strWorkbook As String)
On Error Resume Next
Set WSH = WBK.Worksheets(1)
On Error GoTo 0
But possoble to show a MSGBOX with a message, to inform the user of limitation?
Ho to vba code to no permit from the user to save or save as workbook?
Click Here to Expand Forum to Full Width
Survey posted by VBForums.