Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forgot to save a workbook after adding additional info | Excel Discussion (Misc queries) | |||
after adding data, grafics not calculated until save and reload | Charts and Charting in Excel | |||
Adding a worksheet from a date named workbook and save as current | Excel Programming | |||
adding before save so it works every time excel opens and with any workbook | Excel Programming | |||
Save As - Multiple Sheets fails to save as text file | Excel Programming |