How to Recover Deleted or Corrupted Excel Files?

Excel files could possibly get corrupt at any moment. Just images that you are seriously working on a critical MS Excel document and your computer turn off by itself unexpectedly. And when you reboot it, you cannot open this important excel document ...

Message posted on the March 6th, 2012 - 2:13 AM ET

RTD server : Updatenotify does not return and Excel not calling refreshData method

Hi, I have implemented an RTD server in c# Its working fine in 2003 but when I use excel 2007 the cell values sto updating after while. Here is my logic for refreshdata and update notify I have used alreadyNotified flag to make sure that there are ...

Message posted on the July 10th, 2012 - 07:07 am ET

Debug.Print statement causes Excel crash

After some search effort I found the cause for an Excel crash. Just in case you experience the same this is what I discovered: In Excel 2003, 2007 (and later?) the statement Debug.Print , "test" causes Excel to crash. There is an ...

Message posted on the June 15th, 2013 - 07:06 am ET

Load data from Word into Excel

My Excel VBA program uses the msoFileDialogFilePicker form that lets the user choose a Word document. The available Word documents to choose from are formatted as follows: There is one line of text at the top of the document. Next, right below ...

Message posted on the May 01st, 2013 - 06:18 am ET

Excel VBA Macro Training

VBA MACRO Training Visual Basic For Applications (VBA) & Macro Traning Microsoft Visual Basic for Applications (VBA, Macros) when use with Microsoft Excel can build powerful automated business tools quickl and minimum cost. If you sit in front ...

Message posted on the September 21st, 2012 - 03:35 am ET

excel 2003 vs 2007 menu and sheet issues

I need some help with the following 2 situations: 1) In Excel 2003/Windows XP, I created a pulldown on the menu bar that launches a number of routines. When the same code is run on Excel 2007/ Windows 7, the menu is nowhere to be found. The only ...

Message posted on the January 30th, 2012 - 06:43 pm ET

How to split an excel workbook in code and data

Subject: How to split an excel workbook in code and data I have a complex excel file (.xlsm). It has several complex sheets and complex macros. This workbook (excel file) will be used by many different users who will enter data in the excel file ...

Message posted on the September 19th, 2012 - 09:07 pm ET

Tranfer data from Excel to word (Docx) via VBA in Excel

Hi, I need to create VBA in Excel to tranfer data into word template. Here the example In Microsoft Excel I have Data in Cell: A1 = Date B1 = Name C1 = Address 1 D1 = Address 2 E1 = Address 3 I have Microsoft Word template as Below: Date : Get ...

Message posted on the April 23rd, 2013 - 11:23 am ET

How to make web image on Excel worksheet permanent

Using Excel 10 and Windows 7 Hello all, I have a macro that uses the code Worksheets("List").Pictures.Insert (URL) to grab an image from the web and paste it into the selected cell. The image is then saved within the excel file. So far ...

Message posted on the April 16th, 2013 - 11:30 pm ET

Opening excel 2010 spreadsheet from Access

Hi: We have an application (operarting on Windows 7, originally developed for Access 2000 and now running under Access 2007 in compatability mode), which was originally programed to open an Excel file (TASCSpreadGen.xls) in Excel 2007, using the ...

Message posted on the February 25th, 2013 - 04:04 pm ET

'.Copy Destination:=' temporarily freezes multiple instances in Excel 2010

Dear all, I'm running vba code in multiple instances of Excel and I recently migrated from 2003 to 2010. Something odd happens: processor load of _all_ processors occasionally falls well below 15% if any of the running instances uses the copy code ...

Message posted on the January 15th, 2012 - 06:55 am ET

Excel file compare (each sheet). Is there something already available?.

Hello, I'm asking myself if there is something already available to compare two excel files. (cell by cell, each sheet in the two excel). I know a little bit of VBA but if there is something done already (maybe I can change the code little bit by ...

Message posted on the June 11th, 2013 - 04:42 pm ET

Exceltastic brings back the classic Excel menus

Exceltastic is an Excel worksheet that enhances the program usage by adding new menus and functions. This tool allows you to use the classic Excel menu in order to quickly access the functions that you are used to from previous versions. You can ...

Message posted on the June 11th, 2013 - 01:10 pm ET

Excel File need to unprotect

Hi All, I have a excel file, and password is forgot. Now i have to open that excel file. Regards, Asrar ayb Asrar Ayub

Message posted on the June 11th, 2013 - 08:51 am ET

		Advanced search
In