Search:

Type: Posts; User: PcMax

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds; generated 45 minute(s) ago.

  1. Hi Other suggestions......

    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
  2. Replies
    3
    Views
    11,663

    Hello Thanks for the suggestions, here is an...

    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
  3. Replies
    3
    Views
    11,663

    apply NumberFormat

    Tips Ok:



    Cells(Num, 1).NumberFormat = "#,##0_-;-#,##0_-;; @* _- ""23"" "
  4. Thread: Selection range

    by PcMax
    Replies
    3
    Views
    1,416

    Hi Thanks to the suggestion, I thought the...

    Hi

    Thanks to the suggestion, I thought the undocumented format I used: .Cells(.Rows.Count, 5).End(3)).Address
    could create areas selection problems
  5. Thread: Selection range

    by PcMax
    Replies
    3
    Views
    1,416

    Selection range

    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?
  6. Replies
    4
    Views
    1,454

    Hi, snb Thanks for the suggestion. When...

    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
  7. Replies
    4
    Views
    1,454

    Ciao I've always imported txt files using vba...

    Ciao

    I've always imported txt files using vba code, two examples:
    http://excelexperts.com/VBA-Tips-Import-A-Text-File...
  8. Replies
    4
    Views
    1,454

    Import TXT files without VBA

    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
  9. Replies
    7
    Views
    32,561

    Excel version 2016 64 Bit, the code has been...

    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...
  10. Replies
    2
    Views
    1,368

    thank you snb I used the formula ...

    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
  11. Replies
    2
    Views
    1,368

    Alternatives SUMPRODUCT ISO

    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...
  12. Replies
    17
    Views
    4,383

    Hi, I confirm that I had to adapt the code...

    Hi,



    I confirm that I had to adapt the code to work Vb6

    Thank you very much
  13. Replies
    17
    Views
    4,383

    Hi, I used XL2013 and the Vba code you have...

    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
  14. Replies
    17
    Views
    4,383

    Hi, snb, I tested the code in the loop Vb6 and...

    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
  15. Replies
    17
    Views
    4,383

    Hi, The combinations of the items requiring...

    Hi,


    The combinations of the items requiring correction, unfortunately I have not managed to solve all situations
    I attach the file with new entries
  16. Replies
    17
    Views
    4,383

    Hi, Modified code, already tested with Vb6 :)...

    Hi,

    Modified code, already tested with Vb6 :)
    All required steps have been included


    Version to be tested in Excel

    Sub Gian()
    sn = [B3:B12]
  17. Replies
    17
    Views
    4,383

    Hi, I tried them all really, but do not...

    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...
  18. Replies
    17
    Views
    4,383

    Hi, Unfortunately I could not use the...

    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
  19. Replies
    17
    Views
    4,383

    Hi, With the data that I had attached they...

    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()
  20. Replies
    17
    Views
    4,383

    Hi, I modified the code now work correctly...

    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
  21. Replies
    17
    Views
    4,383

    Initial capital customized

    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.
    ...
  22. Replies
    2
    Views
    6,427

    Ok, here's what I was looking for Preserving the...

    Ok, here's what I was looking for
    Preserving the Undo List (Microsoft Excel)

    the command

    Application.OnUndo "", ""
  23. Replies
    2
    Views
    6,427

    How To Clear Undo List Stack In Excel

    Hi,

    I need to clear the undo list
    Some alternative to the following:


    Cells(1, 1) = Cells(1, 1)

    thank you
  24. Replies
    3
    Views
    1,417

    Hi, Through a program in Vb6 create a daily...

    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...
  25. Replies
    3
    Views
    1,417

    Hi, I enclose an example to browse images in a...

    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...
Results 1 to 25 of 135
Page 1 of 6 1 2 3 4