تبلیغات
Computer Book - مطالب ابر VBA

Excel 2007 – Macros in Depth

نوشته شده در تاریخ : جمعه 13 آبان 1390   07:50 ق.ظ

نوع مطلب :فیلم های آموزشی ،

 Excel 2007   Macros in Depth

QuickTime (.mov) | AVC | 960×540 | 100Kbps | 02:30:00 | 186 Mb
Audio: English | AAC , 2ch , 96Kbps

In Excel 2007: Macros in Depth, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can’t be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario.

Exercise files accompany the course.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: Depth، Excel 2007، VBA،

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, 2nd Edition

نوشته شده در تاریخ : دوشنبه 31 مرداد 1390   06:57 ب.ظ

نوع مطلب :NET. ،

26511389653 Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, 2nd Edition

Book Description

“As Excel applications become more complex and the Windows platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication. Professional Excel Development is a book for developers who want to build powerful, state-of-the-art Excel applications using the latest  technologies.”
–Gabhan Berry, Program Manager, Excel Programmability, Microsoft

“The first edition of Professional Excel Development is my most-consulted and most-recommended book on Office development. The second edition expands both the depth and range. It shines because it takes every issue one step further than you expect. The book relies on the authors’ current, real-world experience to cover not only how a feature works, but also the practical implications of using it in professional work.”
–Shauna Kelly, Director, Thendara Green


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: .Net، development، Microsoft Excel، VB.NET، VBA،

Microsoft Access 2010 VBA Programming Inside Out

نوشته شده در تاریخ : یکشنبه 9 مرداد 1390   02:46 ب.ظ

نوع مطلب :پایگاه داده ،

645682167133 Microsoft Access 2010 VBA Programming Inside Out

Book Description

You’re beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic® for Applications (). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts use  to exploit the power of Access—and challenge yourself to new levels of mastery!

  • Enhance your application with VBA built-in functions and  code
  • Use the Access Object Model to work with data in forms and reports
  • Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
  • Create classes for handling form and control events
  • Connect your Access  to different sources of data
  • Effectively plan how to upsize an existing Access database to  ®
  • Dynamically update Microsoft Excel® spreadsheets from the database
  • Migrate your Access database directly to the cloud using SQL Azure™

ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: Microsoft Access، programming، sql، sql server، VBA،

Mastering VBA for Office 2010

نوشته شده در تاریخ : شنبه 1 مرداد 1390   12:57 ب.ظ

نوع مطلب :NET. ،

645682167100 Mastering VBA for Office 2010

Book Description

A comprehensive guide to the language used to customize

Visual Basic for Applications () is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master  in order to customize the entire Office suite for specific business needs.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: VBA، Microsoft Office،

RibbonX: Customizing the Office 2007 Ribbon

نوشته شده در تاریخ : شنبه 1 مرداد 1390   12:55 ب.ظ

نوع مطلب :NET. ،

645682167102 RibbonX: Customizing the Office 2007 Ribbon

Book Description

  • As the most radical change to the Office interface in its history, theRibbon replaces the traditional menu bar and toolbars and requires a new set of skills for customizing
  • Instructions and examples demonstrate how to customize the Ribbon using VBA, XML, Access, Excel, and Word
  • Covers the relevant aspects of security, such as trust centers and digital certificates
  • Packed with real-world code examples that readers can immediately apply
  • Features helpful references

ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: XML، VBA، Ribbon، MVP، Microsoft Office،