Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Name: DerbyDad03 Date: February 21, 2009 at 21:39:28 Pacific
Reply:
Something like this might work...
Sub SavetoCSV()
Range("A1:E4").Copy Destination:=Sheets(3).Range("A1")
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\User1\My Documents\JustMyRange.csv", FileFormat:= _
xlCSV, CreateBackup:=False
End Sub
Summary: Well see, the CSV is from the university database. It's the info on all the classes for the semester. Currently the university has no was to make postable schedules for each room. Thus, this excel mac...
Summary: I am new to Excel macro and I need your help. I have the following input data in Sheet 1: a1 b1 (a1 in cell A1, b1 in B2) a2 b2 (a2 in cell A2, b2 in cell B2) I need a macro to create the following ...
Summary: Yes, i have another problem... the data i use is read from a text file and since its always different i have coded the Macro to search for the start and end of a certain pattern of data... ie a range ...