Type: Posts; User: Zvoni
Search took 0.04 seconds.
Second reply --> http://objectmix.com/basic-visual/155084-mshflexgrid-error-13-a.html
excerpt from his code
For J = 0 To UBound(strArray)
Found = Found Or Not (rngCells.Find(strArray(J)) Is Nothing)
Loop backwards through sheet1 (For i=123456 to 2 step-1)
Keep a counting variable J (or x or whatever) you increase +1 for everytime you find your criteria in sheet1 and use this variable as the...
I assume that the OP scans directly into a cell, so he can still do it manually if the scanner/barcode itself doesn't support CR
Private Sub Worksheet_Change(ByVal Target As Range)
Don't forget that a Date can be represented by a Long-Type, a DateTime by a Double-Type (the Time being represented by the part after the decimal-separator), so i agree with Phill: Never compare...
If the Values to be assigned (depending on the Index) are constant, an approach might be to use an INI-File and/or database (db could even be a small textfile with UDT's)
Errr... nevermind, that i still have to see how you can delete a file from a CD/DVD (and don't start arguing with "rewritable" CD/DVD), i highly, highly recommend against doing anything with...
You do realize, that you use the variable "Data" to build your Save-FileName, and that Data gets its value from range("F2")?
What's the Value in F2?
For the headers: No Idea. Probably to do with systemcolors and/or color-themes
For the selected line: if i remember correctly, there are several color-properties for the ListView. I'd check out some...
This should work
Dim MyArray() As String
ReDim MyArray(1 To lvF.ListItems.Count)
For i = 1 To lvF.ListItems.Count
Well, since Target is a Range-object, i would have expected a Is-Nothing-Expression, since IsEmpty refers to numeric or string-values
EDIT: Or did i just fell for the Trap with the...
Don't forget if you have code running which crossreferences another workbook like
That's a pre-programmed timebomb
errr..... am i supposed to understand this line?
If IsEmpty(Target) Then Exit Sub
What's wrong with Max's suggestion in Post #7?
If everything else doesn't work, i'd rather do the subclassing-approach than starting some weird magic with hidden picture-boxes
EDIT: You'd have...
Why not use an OERN right before the loop, with an On Error Goto 0 after the loop?
He could even check inside the loop for the error and count the failed extraction attempts, like
I think your problem's in the datatype, since you're using MAX on a Textfield (think sorting by string)
But i'm not sure about it. It's been over 10 years I've done anything serious with Access
Sounds like a chess game.
Turning a chessboard around you get the same board (Background) again (White square in upper left corner), but now the black pieces are at the bottom instead on the top.
I'd rather subclass the windows-procedure on the receiving end with a unique message-header sent by the sender (e.g. WM_Custom or something) with the pertinent data sent in lparam or wparam.
I don't have any access to other FTP-sites.
Could someone of you, who has an FTP-Server, make me an account, and PM me the Login-data?
EDIT: I tried to upload the file via a Web-FTP-Provider...
Getting the file back is an empty file
I just called the FTP-operator.
They had an update last week on monday (the day my code started to misbehave!), but according to him, the update...
I just tried to upload the file using the ftp.exe commandline-program
after entering put c:\temp\myfile.xml (which is 6KB)
200 PORT command successful
I tried pete's suggestion with the Shell-Object, and i got the following phenomenon:
I have a Windows-Explorer open connected to the Folder on the FTP-Server (for watching in...
didn't think on that. Will try on monday. In germany is holiday tomorrow, and i took off friday, so next i'll be able to test it will be coming monday.
will report on monday if it...
First off: thx for taking time to think about my problem.
No updates on my machine for the last 2-3 months, so nothing there.
Yes, the bat is an idea, but i would have to figure...
Good idea with trying an old file, but has the same result.
Empty file with zero bytes.
My xml starts like this
<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>
I'm using the Internet-Functions of wininet.dll (InternetOpen, FtpPutFile etc.)
Until last week it worked without problems.
Now i got the following Problem:
My Code creates a...
without seeing the code it's just guesswork
That's the complete Function:
Sub GenerateXML(Directory As String, File As String)
Dim XML_str As String
Recommending Chapter 4 of "Hardcore Visual Basic"
issue: User uses an Excel-Sheet filling out pertinent data for a freight-carrier order
There is data only to be filled once (Sender, receiver etc.)
and repeating data (Positions 1 to 20,...
Looks like some Backup-thingy
Drive D --> January
Drive E --> February
Drive O --> December
Meaning: Right now is Mid-March. His Drive for March is Drive F.
So, on the last Sunday in...
Maybe something like this?
Shell the ping to a textfile and read the textfile
So if i understood you correctly you're looking for a 4-character long partial string, which is in the format e.g. a4b2 or any combination of it within the limits you said (a-h, 1-8)
Shot in the dark: He's searching for files without providing the full path to the file, meaning he only looks for the filename without the path.
First rule for file-processing: The path to a file...
You don't have to do any Do-Loop with INI-files.
Use GetPrivateProfileString with the section you're looking for, but with the second argument empty.
the returnvalue has all keys assigned to this...
The same with GetPrivateProfileString
Read the description for the GetPrivateProfileString-API again......
.... or wait until Doogle finds this thread :D
Click Here to Expand Forum to Full Width
Survey posted by VBForums.