| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating macro to use on different workbooks
I would like to create a macro that I can use on different workbooks - I
have to create a new spreadsheet every day (exporting data as *csv and converting to .xls but the information is similar - I have read other answers and I don't really understand the replys (and have tried saving my last workbook with the macro in as Addin*,xls file to save the macro for further use but that didn't work) Thank you in advance for any replies |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating macro to use on different workbooks
You should not be saving this as .xls. Please refer the below link
http://www.ozgrid.com/VBA/excel-add-in-create.htm If this post helps click Yes --------------- Jacob Skaria "Dottled" wrote: I would like to create a macro that I can use on different workbooks - I have to create a new spreadsheet every day (exporting data as *csv and converting to .xls but the information is similar - I have read other answers and I don't really understand the replys (and have tried saving my last workbook with the macro in as Addin*,xls file to save the macro for further use but that didn't work) Thank you in advance for any replies |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating multiple workbooks | Excel Worksheet Functions | |||
| Need Help Creating a Macro Multiple Workbooks to One | Excel Worksheet Functions | |||
| Creating a default for all new workbooks | Excel Discussion (Misc queries) | |||
| Creating New Macro Workbooks | Excel Discussion (Misc queries) | |||
| creating spreadsheets and workbooks | New Users to Excel | |||
Linear Mode
