stext

  1. J

    Trouble Copying from txt file to Excel - pastes into one cell only

    Hello. I'm trying to paste from a txt file into Excel. I can successfully paste into ONE cell, but I need it to paste into multiple cells. E.g. the txt file looks like this: 1 2 3 4 5 6 With my code below (admittedly pilfered from someone else!), it pastes into A1, but it pastes ALL data into...
  2. S

    File System Object

    Good Morning, I'm working on an error handler and stumbled upon this wonderful section of code, available from https://bettersolutions.com/vba/error-handling/log-file.htm Anyway, I don't want to enable File System Object in my reference library so I tried modifying some script to this Dim...
  3. W

    HTML Format Question

    Is it possible to specify a font and size and maybe color for only one line? 'sig ssig = vbLf _ & vbLf _ & vbLf _ & sname _ ' would like to specify font and size and color here only & vbLf _ & ttl _ & vbLf _ & " Division" _ & vbLf _ & "8120 Way" _ &...
  4. B

    Copy data from .txt file to an Excel worksheet in a workbook that is not open

    I need to copy all of the data in a text file and then paste it into a specific worksheet in an excel workbook that is not open. Most of the info I have found is for the active worksheet, not what I am looking for. Been working on this longer than I should have. It keeps quitting when it gets...

Watch MrExcel Video

This Week's Hot Topics

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
Top