|
SFTP upload with VBA - Stack Overflow[^] presents a solution using putty's stfp client. There does not seem to be an excel-integrated solution as of today.
"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."
|
|
|
|
|
Thanx, but that's not a solution.
The problem is that we receive files from a client covering a weeklong window of daily files. Unfortunately, whatever automation routine they use saves each daily file with the same name, so each successive file has '_X' where 'X' is an incremental values for each new file past the first appended to the name. That means, I have to manually rename the files, substituting the file's creation date in place of the '_X', download them and then move the originals to an archive folder on the SFTP site.
At the moment, I'm doing it manually with FileZilla, but I'm wanting to automate my end to cut down on manual manipulation. I want to expand on a current Excel macro that is already part of the process to take on this task.
For me, the putty solution might work - looking at the link, I don't see where I define the port address, unless it's just by appending ':22' to pHost. But, I have to make this code accessible to everyone, in case I am out and my backup has to do my task. I don't always know who that would be and they may not have the rights to add putty to their system.
But, thanx again for the response.
|
|
|
|
|
I make A project for help Desk and i need to retrieve user data from active directory by username from text box
thanks
|
|
|
|
|
Check for System.DirectoryServices.ActiveDirectory Namespace[^] which contains all objects / structs / enums you need to handle Active Directory operations in .NET.
"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."
|
|
|
|
|
i want to know whether it is possible to program calculation of marks in a a quiz show where 6 teams
participate. once the score button is clicked the core of each team should be shown in descending order of marks. If so how the coding should be. I am a student cum teacher. Now studying VB. Got a project to do so. But there is no way I could find a solution after going through the different sites.
|
|
|
|
|
Yes, it's possible. It's not even particularly difficult.
But ... Please don't repost if your question does not appear immediately: all of these went to moderation and required a human being to review them for publication. In order to prevent you being kicked off as a spammer, both had to be accepted, and then I have to clean up the spares. Have a little patience, please!
I've deleted the spare ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
As long as it use logical rules and mathematics, it is possible and with about any programming language.
But for this, you need to learn programming, but we can't teach you in the scope of this forum.
Advice: solve the problem by hand, the procedure you followed is basically your algorithm.
Patrice
“Everything should be made as simple as possible, but no simpler.” Albert Einstein
|
|
|
|
|
how to search record in gridview in vb 6.0
|
|
|
|
|
|
You normally would never search the gridview itself. You search the data source the grid is bound to.
|
|
|
|
|
When exporting data from SQL Server to Excel, when a field size is large e.g. varchar() might cause the error below:
String or binary data would be truncated.
The statement has been terminated.
|
|
|
|
|
Is that supposed to be a question or a statement?
|
|
|
|
|
Please google: "excel maximum cell text length"
My advice is free, and you may get what you paid for.
|
|
|
|
|
hi there.
im creating a label sequencer for 3 produts and i'm trying this but with no success
sql_query.CommandText = "insert into tablelabel02 with (tablockx) (nome_posto, ordemfabrico, serialnumber, referencia,dataetiqueta,qrgerado,data,operador,posx,posy,impressora,controlo)output inserted.qrgerado
values (@posto, @ordemfabrico, next value for '" & sequenceID & "' , @refcode, replace(cast(convert(varchar,getdate(),5) as varchar(10)),'-','/'),
@refcode+replace(cast(convert(varchar,getdate(),5)as varchar(10)),'-','')+right('000'+cast((next value for '" & sequenceID & "' )as varchar (4)),4), getdate(), @operador,@labelx,@labely, @impressora, 'xx' );"
for each product i have created a sequence in ms sql, so when i inserted the production order number, i can sort what sequencer to use but i cant use it as sequenceID variable.
i tried
next value for seq_a and it works.
with
next value for '" & sequenceID & "' not working
in resume:
i want to use next value for @variable if possible
|
|
|
|
|
Can you define not working? It will be helpful if you can share the error message.
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
I wanted to use next value for X where x is a variable and not have to put the name of the sequence table
|
|
|
|
|
Currently I have this:
Private Sub btnCount_Click(sender As Object, e As EventArgs) Handles btnCount.Click
Dim arrsize = rtbDHCP_lease.Lines.Length - 1
Dim MyNum(arrsize)
For I = 1 To arrsize
MyNum(I) = rtbDHCP_lease.Lines(I).Substring(41, (rtbDHCP_lease.Lines(I).IndexOf(".", 41) - 41))
ProgressBar1.Value = (I / arrsize) * 100
Next
Dim query = From item In MyNum
Order By item
Group By vlans = item
Into vlans_count = Group, Count()
For Each result In query
dgvDHCPcount.Rows.Add(New Integer() {result.vlans, result.Count})
Next
End Sub
It takes a long time to go through the richtextbox especially if it has a large amount of lines. Is there a process the can speed it up?
Thanks in advance.
|
|
|
|
|
First question.
Why are you using a RTB as a data storage structure? That text should be parsed to grab the data out of the text file itself and not from the RTB.
The mistake most people new to writing code in a GUI environment is treating visual controls as workable containers for data structures and data storage. That's not what they are for and will only make parsing and working with the data much, much slower.
So where did the data you put in the RTB come from?
|
|
|
|
|
I am a vb6 developper and when I install my apps they look different, sometimes with larger windows some other times smaller windows. So, how can I work with form properties so that they look the same?
Kind regards,
Alexis
|
|
|
|
|
You have to resize controls and forms relative to the screen size. It's a pain.
Alternatively, see my comment below about using VB.Net instead - then a lot of the pain is taken away with standard properties.
|
|
|
|
|
Quote: I am a vb6 developper
I hate to tell you this, but your skill set is just about completely worthless. VB6 has been dead for quite a long time.
If you're asking this question, it suggests you haven't been writing VB6 code for that long. I would suggest dropping it in favor of at least VB.NET. The Community edition of VIsual Studio is free from here[^].
If you continue down the VB6 road, you'll end up with a skill set that's not being used at all and VB6 will teach you very bad habits you're going to have to unlearn to do things correctly in the modern world.
|
|
|
|
|
UWP apps (windows 10) looks good on all screens; with no tweaking.
Using the control panel's "Ease of Access", you can change the text size, if necessary. That's about all that's ever needed.
The "simulator" lets you run at various screen resolutions to see.
Apps can be "side-loaded" without using the MS Store for distribution.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Hey guys,
I ve been having a problem with components while installing any app that I ve developped in vb6. Now, I want to include my downloded .ocx and .dll in the folder with other when I make my setup but I still have a problem of components registration. I am still forced to register the components manually. Is there any way the setup can register automatically the components like other apps?
Thanks
|
|
|
|
|
You do know that VB6 has been out of support for decades now?
And that it needs to be registered using the 32-bit version of regsvr32.exe?
You will need to explicitly give the full path to SysWOW64\regsvr32.exe.
You will need to make sure all of the associated dll's etc for VB6 Runtime are also installed - if your version of Windows still supports them.
Better option - get a more recent copy of Visual Studio and rewrite your application in VB.net - it's free, unlike VB6
|
|
|
|