data merging using access or excel
Thread Starter
Scooby Regular
Joined: May 2000
Posts: 794
Likes: 0
Morning all :-)
Can I use a simple office type package to do the following...
transform the following table
content filename
123 file1.txt
blah name2.txt
into a collection of files, named according to filename field, containing the content in the content field?
Cheers
Lee.
Can I use a simple office type package to do the following...
transform the following table
content filename
123 file1.txt
blah name2.txt
into a collection of files, named according to filename field, containing the content in the content field?
Cheers
Lee.
Scooby Regular
Joined: May 2002
Posts: 633
Likes: 0
The following three lines will write to a file from a VBA macro in excel.
Open "TESTFILE" For Output As #1 ' Open file for output.
Write #1, "Hello World", 234 ' Write comma-delimited data.
Close #1 ' Close file.
I could probably knock you up a solution if you want, but not this late, I'll check this thread tommorow evening.
Open "TESTFILE" For Output As #1 ' Open file for output.
Write #1, "Hello World", 234 ' Write comma-delimited data.
Close #1 ' Close file.
I could probably knock you up a solution if you want, but not this late, I'll check this thread tommorow evening.
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
Dec 28, 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
Nov 18, 2015 07:03 AM