Sinjin
01-11-2005, 11:56 AM
First post here...
An Excel workbook (CAR) contains several sheets. Information from various cells on several of the sheets needs to be loaded into a SQL table. I have added a worksheet (called AdminOnly) to the base CAR template and linked the various cells so one row on AdminOnly contains data for SQL. The problem is that the Fiance Group will not let me add the AdminOnly worksheet to the CAR template.
My solution is to use the INDIRECT function on AdminOnly and insert this worksheet on the CAR files when sent in to corporate (all with different names and that can not be changed). I then have a macro to change the AdminOnly row to values and save the file to a folder for exporting into SQL. All of this works OK.
To my question - with the CAR files all have different names, how do I code the macro so that it looks at the other one or many files that I have open in Excel?
I hope this is clear! Thanks!!! Jani
An Excel workbook (CAR) contains several sheets. Information from various cells on several of the sheets needs to be loaded into a SQL table. I have added a worksheet (called AdminOnly) to the base CAR template and linked the various cells so one row on AdminOnly contains data for SQL. The problem is that the Fiance Group will not let me add the AdminOnly worksheet to the CAR template.
My solution is to use the INDIRECT function on AdminOnly and insert this worksheet on the CAR files when sent in to corporate (all with different names and that can not be changed). I then have a macro to change the AdminOnly row to values and save the file to a folder for exporting into SQL. All of this works OK.
To my question - with the CAR files all have different names, how do I code the macro so that it looks at the other one or many files that I have open in Excel?
I hope this is clear! Thanks!!! Jani