UPDATE 1: This is what I am trying to do. B1, B2, and B3 represent 3 containers Period could be anything, days, weeks, months years, so Period 1, can mean day 1, or week 1, or month 1 or year one.
I am working on macro for my proffesion in the army - I make graphs of air force saftey. I want to make my job easy so I want that the macro will change somethings - which it does right now and it wil
I have two different workbooks with approx 15 columns and 50k rows in one work开发者_JAVA技巧book and 10columns and 1000 rows in another workbook and only 2 columns(partnumber, changelevel)are in comm
I created Excel 2003 pivot table which uses External source and SQL 200开发者_开发知识库8. I wrote in the query:
I defined开发者_JAVA百科 a macro in one worksheet(internal.xls) as Public Sub sheet2test() Workbooks.Open Filename:=\"external.xls\"
I have create Excel 2003 addin and installer according with manual http://blogs.msdn.com/b/cristib/archive/2010/11/01/deploying-a-vsto-word-2007-add-in-to-all-users-visual-studio-2008-sp1.aspx
I\'ve 开发者_开发知识库created a VB6 application from which I wish to send an SMTP email. The email is sent and received fine but when attaching an Excel 2003 file, whilst this is received okay, when
It seems that when VBA code is called from a cell formula (ie. a \"User Defined Function\" or UDF), the usual VBA Break On Error doesn\'t work.
I have four pivots I\'m pulling data from that look like this: tracked_work_by_users_by_operation_pivot:
YearMthRegionEmployeeItemUnitsUnit CostTotal --------------------------------------------------------------------
加载中,请稍侯......