strtext

  1. M

    Import CSV (UTF-8) to Excel without formatting

    I have code for pasting data from CSV file to Worksheet. Everyhting works fine but I am facing some problems with current solution. Is there a way to paste data as it is without formatting? Now Excel is formatting for example -Name to =-Name so there #Name ? errors instead of Values. Also it...
  2. S

    Test when value of an array is filled

    Hello guys, now I would need some helping hands with following UDF. Function ReNrAendern(ByVal strText As String) As String Dim strOld(0 To 11) As Variant Dim strNew As String Dim i As Integer strOld(0) = "RE " strOld(1) = "RE. " strOld(2) = "RE: "...
  3. S

    Update Query with custom function DataType Problem

    Hi guys, I am stuck with an update query which gives me an error datatype issue. I have created a custom function to update phonenumbers Function TelefonUpdate(ByVal strText As String) As String Select Case True Case strText Like "0*#" If strText Like "0####/#*#"...
  4. S

    Problem with LCase and UCase

    Hi again, hope you guys are kind to help me with this I can not work out.. Function TestGMBH(ByVal strText As String) As String Dim strSearch As String strText = LCase(strText) Select Case True Case strText Like "*myword*" If strText Like "myword...
  5. J

    How to open html file from a folder and get the area tags

    Hi, I am not very familiar with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>, and still on the learning...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top