View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick K[_2_] Rick K[_2_] is offline
external usenet poster
 
Posts: 8
Default Adding text after save

I have a spreadsheet that is saved as a .csv and then sent to a customer
(info contains their product in storage). [Saving the workbook via vba is no
problem]. My trouble lies in the fiirst line of the .csv file which must
contain specific ICC data (with specific spacing/positioning) information.
The data is as below:

Dim myStr As String
myStr = "{ICC}DATBOOK" & Space(1) & "ZZ:CJKUSA" & Space(9) &
"ZZ:MGHDATA" & Space(9) & Date & Time

My problem is how to insert this information into line 1 after the file is
saved to csv (in vba)
I want this to occur automaticly for my user.

Any thought??
Rick