Saving Excel File with Name and Date Details

July 20, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips 

Excel Tips Saving Excel File with Name and Date Details [Q]
I need excel tips to save Microsoft excel file I am working on (template) with the name of
the file and the date?

ex. “filename - 2008-10-29.xlsR..... Read The Solution..

Resize Range for Column in Workbook

June 23, 2009 by vba excel · 1 Comment
Filed under: Excel Spreadsheet, Excel Tips, Excel Worksheet 

Resize Range for Column in Workbook [Q]

I dont know how to resize range for column in excel workbook, i have four named ranges that relate to a column of data starting on row 1 going
to the end of the column data on my e..... Read The Solution..

Execute Excel Code When a Group of Buttons are Used

June 12, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips, Excel Worksheet 

Execute Excel Code When a Group of Buttons are Used [Q]

Im confuse when trying to execute excel code in multi buttons i used, i was hoping to find an excel Worksheet command that could identify when a row grouping was expanded..... Read The Solution..

Problem When Inserting Image or Picture Box

May 5, 2009 by vba excel · 1 Comment
Filed under: Excel Spreadsheet, Excel Tips 

Problem When Inserting Image or Picture Box [Q]

Ive a problem when i try to insert/add image or picture box on my excel spreadsheet, I use the following code for a image or picture box to load an image file:

Private..... Read The Solution..

Transfer Data Between Workbooks

March 17, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips 

Excel Tips Question:

Ive problem related to excel workbook transfer, for your info, I am using Microsoft Excel 2007 with Vista as operating system. My reason for wanting this system is to provide pre-prepared excel workbooks f..... Read The Solution..

« Previous PageNext Page »