Hi
Other suggestions...
https://answers.microsoft.com/it-it/office/forum/office_2010-excel/problemi-combobox-e-ultimo-aggiornamento-di/140044c5-0a79-41a5-9a4e-bd65d2a3f813
Type: Posts; User: PcMax
Hi
Other suggestions...
https://answers.microsoft.com/it-it/office/forum/office_2010-excel/problemi-combobox-e-ultimo-aggiornamento-di/140044c5-0a79-41a5-9a4e-bd65d2a3f813
Hello
Thanks for the suggestions, here is an example code.
The formatting used automatically adapts to the width of the column
Option Explicit
Sub Test()
Dim K As Long
Tips Ok:
Cells(Num, 1).NumberFormat = "#,##0_-;-#,##0_-;; @* _- ""23"" "
Hi
Thanks to the suggestion, I thought the undocumented format I used: .Cells(.Rows.Count, 5).End(3)).Address
could create areas selection problems
Hi
Here is the code OK, are there any critical issues?
Range(Cells(4, 5), Cells(Rows.Count, 5).End(3)).Select
What do you recommend?
Hi, snb
Thanks for the suggestion.
When opening the Excel spreadsheet, you can set up the automatic txt file update
Confirm that There is no indirect formula for a txt file
Thank you
Ciao
I've always imported txt files using vba code, two examples:
http://excelexperts.com/VBA-Tips-Import-A-Text-File...
Hi
My curiosity, with excel 2016 managing a "Formula / Query" to import the string of a *.txt file.
Is this possible?
Thank you all for the suggestions
Excel version 2016 64 Bit, the code has been adapted to operate in both versions
As Userform1
'**** Start of API Calls To Remove The UserForm's Title Bar ****
Option Explicit
#If VBA7 Then...
thank you snb
I used the formula
=weeknum(today();21) Test Ok
Otherwise the function:
Function F_ISOweeknumber(d_01)
F_ISOweeknumber=Format("ww",d_01-WeekDay(d_01,2)+4,2,2)
End Function
I created a formula for a search of the current week, I ask if there are alternatives
=SUMPRODUCT((YEAR($C$3:$AAC$3)=YEAR($B$14))*(ISOWEEKNUM($B$14)=$B$15)*(C4:AAC4="K"))
Thank you for your...
Hi,
I confirm that I had to adapt the code to work Vb6
Thank you very much
Hi,
I used XL2013 and the Vba code you have proposed is correct.
I can not use the sequence in the Old program Vb6.
In previous responses I had reported the problem
Hi,
snb, I tested the code in the loop Vb6 and work perfectly
Rick Rothstein
I tried the code with Excel, perfect
note: Not available in Vb6 code: Application.Proper
Hi,
The combinations of the items requiring correction, unfortunately I have not managed to solve all situations
I attach the file with new entries
Hi,
Modified code, already tested with Vb6 :)
All required steps have been included
Version to be tested in Excel
Sub Gian()
sn = [B3:B12]
Hi,
I tried them all really, but do not show the expected result.
Method strconv It is not sufficient
Check Excel for the meaning of [ ]
Ok, evaluates a formula, I had tried to enter a...
Hi,
Unfortunately I could not use the statement: proper Not available in Vb6
So I retrieved the function here
VB Helper: HowTo: Convert text into proper case, version 2
Now everything is OK
Hi,
With the data that I had attached they were not highlighted all combinations.
Thanks to the suggestions of snb I completed the code
Option Explicit
Option Compare Text
Sub M_snb()
Hi,
I modified the code now work correctly
Now it is full of all my requests
I hope both index
We accept tips
Option Explicit
Option Compare Text
Hi,
I have the need to normalize the text to display a homogeneous
I enclose a possible conversion code that solves the needs.
I apply to use only instructions in Vb6 therefore no formulas.
...
Ok, here's what I was looking for
Preserving the Undo List (Microsoft Excel)
the command
Application.OnUndo "", ""
Hi,
I need to clear the undo list
Some alternative to the following:
Cells(1, 1) = Cells(1, 1)
thank you
Hi,
Through a program in Vb6 create a daily report and save it in a binary file, with the date of the day.
I need to be able to view the data of the previous working day.
To avoid displaying...
Hi,
I enclose an example to browse images in a folder
From unzip and save it to C: \
My actual requirement is to open some text file, without any reference to the dates of the file.
I...