import texfile to specfic column in a worksheet via vba

**frankytheman** · 01-20-2020, 03:16 PM

Hi everyone,

I want to do a backup and restore function in a worksheet.
I have a code which exports the data in column (CW) or column number 101 into a textfile, see below.

Please Login or Register  to view this content.

Now I was wondering if you could help me to export it back to the same column.
How can I achieve that?

Thanks a lot in advance for any help you could provide.

**WideBoyDixon** · 01-21-2020, 06:28 AM

Give this a try:

Please Login or Register  to view this content.

WBD

**frankytheman** · 01-22-2020, 12:14 AM

Hi WBD, this works amazingly good. It even deletes the separator! Love it. Reps on the way to you.

import texfile to specfic column in a worksheet via vba

LinkBack

Thread Tools

Rate This Thread

Display

import texfile to specfic column in a worksheet via vba

Re: Need vba code: import texfile to specfic column in a worksheet via vba

Re: import texfile to specfic column in a worksheet via vba

Thread Information

Users Browsing this Thread

Similar Threads

Import specfic column from Sheet to Sheet

[SOLVED] VBA to protect specfic objects on a worksheet

Import data from specfic column in Sheet Sheet to List Box userform

VBA macro code needed to highlight rows in a table given a specfic text in one column

Count a number in one column only for specfic input in adjacent column

Code to copy specfic rows and also run a macro.

[SOLVED] Excel to Texfile Help needed

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions