Search:

Type: Posts; User: jaryszek

Search: Search took 1.90 seconds.

  1. Re: [FAQ's: OD] How do I set a UserForm to be the TopMost form throughout Windows?

    Hi RobDog888,

    awesome idea!!!
    I have a question because i want to do userform as TOP on everything, even if i am opening browser, it is possible ?

    Now when i am opening userform as top, net i...
  2. Re: Change regional settings from polish to US windows 10

    Yes, it is true.

    so use code above and not use ReadFromExcel method.

    Best,
    Jacek
  3. Re: Change regional settings from polish to US windows 10

    Hi Elroy,

    thank you. Yes it can be harmful for system but you have to first run your code to change decimals, later you have to run your csv with US settings, do your work, closed it and run once...
  4. Re: Change regional settings from polish to US windows 10

    Thank you wqweto , very nice!

    and thank you ChrisE.

    i think that ADO something like this code:


    Sub UpdateSKU()
    Dim ws As Worksheet
    Dim fPath As String: fPath = "C:\Test\" 'Change as...
  5. Re: Change regional settings from polish to US windows 10

    Ok thank you,

    and to read this i should use adodb object and sql?

    Best,
    Jacek
  6. Re: Change regional settings from polish to US windows 10

    o wow what a great idea wqweto,

    Why to generete schema.ini from VBA?
    The better option would be creating the file manually and import somehow to Excel?

    edit: i could have only schema.ini...
  7. Re: Change regional settings from polish to US windows 10

    o wow what a great idea wqweto,

    Why to generete schema.ini from VBA?
    The better option would be creating the file manually and import somehow to Excel?

    Best,
    Jacek
  8. Re: Change regional settings from polish to US windows 10

    Hi Arnoutdv,

    thank you for getting involved.
    Yes, exactly. When opening csvs based on US style i have to use text to column all the time. I can have macro to do it but i wnat to try also wiyh...
  9. Change regional settings from polish to US windows 10

    hi Guys,

    i am looking for solution to change regional settings using VB in windows 10.

    I am trying to use code below:


    #If VBA7 Then
    Private Declare PtrSafe Function SetThreadLocale...
Results 1 to 9 of 9



Click Here to Expand Forum to Full Width