data merging using access or excel
19 November 2002, 07:27 PM
#1
Scooby Regular
Thread Starter
Join Date: May 2000
Posts: 794
Likes: 0
Received 0 Likes
on
0 Posts
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.
20 November 2002, 12:29 AM
#2
Scooby Regular
Join Date: May 2002
Posts: 633
Likes: 0
Received 0 Likes
on
0 Posts
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
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
Sam Witwicky
Engine Management and ECU Remapping
17
13 November 2015 10:49 AM