Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating excel files using VBA
Hi, I am working on a VB application which will export the results to a Excel file. The Excel file generated should also have graphs in it. To do this I am planning to have a excel file already existing on th hard drive path which will be having the graphs with reference t certain rows and columns. The application should make a copy of th file, rename it and put the file at the same path as the original one Later on the application should change the results obtained dynamicall in the workbook, so that the graphs are changed accordingly. Can anyone tell me how can I make copy of a existing excel file, renam and save it. Thanks in advance, Samee -- sameerc ----------------------------------------------------------------------- sameerce's Profile: http://www.excelforum.com/member.php...nfo&userid=807 View this thread: http://www.excelforum.com/showthread.php?threadid=26912 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating excel files using VBA
Hi,
application.savecopyas "machinename\shareddrive\path\filename.xls" But what you really need is called a template. filesave as select "template" as the file type in the drop down box. Turn on the macro recorder and do... filenew select the template file. And you have the code. -- John johnf202 at hotmail dot com "sameerce" wrote in message ... Hi, I am working on a VB application which will export the results to an Excel file. The Excel file generated should also have graphs in it. To do this I am planning to have a excel file already existing on the hard drive path which will be having the graphs with reference to certain rows and columns. The application should make a copy of the file, rename it and put the file at the same path as the original one. Later on the application should change the results obtained dynamically in the workbook, so that the graphs are changed accordingly. Can anyone tell me how can I make copy of a existing excel file, rename and save it. Thanks in advance, Sameer -- sameerce ------------------------------------------------------------------------ sameerce's Profile: http://www.excelforum.com/member.php...fo&userid=8071 View this thread: http://www.excelforum.com/showthread...hreadid=269124 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CREATING PDF FILES FROM EXCEL FILES | Excel Discussion (Misc queries) | |||
Excel Creating strange files | Setting up and Configuration of Excel | |||
Creating a databse from several Excel files | Excel Discussion (Misc queries) | |||
Creating PDF files from Excel. | Excel Discussion (Misc queries) | |||
Creating excel backup files | Excel Programming |