Anyone that follows this forum has figured out that I am doing a project utilizing Excel. I have a few question and figured that I would throw them in one post.

1. I've seen a few posts from RobDog that mentions using
Code:
moApp = DirectCast(CreateObject("Excel.Application"), Excel.Application)
Does this eliminate the need to use a reference? I'm afraid that if I specify a specific reference that I will encounter Excel version problems in the future.


2. I have a template that I'm opening like this
Code:
oApp.Workbooks.Open(Filename:=data.fileIn)
Now I want to fill this template with data from a CSV file. What is the best way to import this data? My initial plan was to create temp worksheet to place the data, copy and paste data to the worksheet with formating then delete the temp worksheet. It seems like there should be an easier way.


3. Is there an easy way to create a new chart and place it behind the other charts? I'm doing this but it seems a little cluncky
Code:
            With oCht
                .Move(, oWb.Worksheets(oWb.Worksheets.Count))
                .Move(, oWb.Charts(oWb.Charts.Count))
            End With