Are user subs and functions in the microsoft office object model hierarchy?
I’m an experienced Excel VBA programmer, who is trying to write a macro in Excel that uses functions and subs in Outlook.  I’ve done some searching and found that the standard answer looks something like: <code>     objApp = CreateObject(“Outlook.Application”)     call objApp.UserSubName(argument1, argument2) </code> where UserSubName is the name of the sub in Outlook.  [...]

Answer Question   |  June 19, 2012  7:50 PM
Excel 2007, Microsoft Office 2007, object model, Outlook 2007

Excel Error message
I am unable to oen excel files in documents because the message ‘there was an problem sending the command to the program’ appears. A blank eecel page appears and I am able to open files via the recent documents link. Is there any explanation and solution to the problem

Answer Question   |  May 28, 2012  8:36 AM
Error Messages, Excel 2007

Vlookup repeated dates
I have a spreadsheet (A) with various data, where one column contains variuos dates, and one column with values. I want to be able to distinguish all values for each year, so I have another spreadsheet (B) with a long list of all dates for 2010, 2011 and 2012.  I use vlookup (VLOOKUP(F3;$B$3:$C$7;2;FALSE) to search [...]

Answer Question   |  February 27, 2012  11:41 AM
Excel 2007, VLOOKUP function

Sending HTML file with record length of 5000 char
I need to send an email with an HTML file attached from the mainframe via SMTP. Even with adding a DCP (LRECL) parameter, the spreadsheet is truncated to the 1st 1024 characters. How do I fix?

Answer Question   |  February 28, 2012  8:27 PM
Excel 2007, JCL, SMTP

Excel 2007 saves the file when I close it without prompting me even though no changes were done
I’m using Excel 2007 and often when I open an excel file and then close it (without touching anything or changing anything) the “Date Modified” is changed to the current date. Meaning the file was saved again without prompting me if I would like to save it and changes its date. Is this situation known [...]

Answer Question   |  February 28, 2012  12:11 PM
Auto Save, Excel 2007

export to ms excel
I get extra columns when exporting to MS excel. It appears there is an extra column every time there is a sub report

Answer Question   |  February 28, 2012  8:39 PM
Crystal Report, Crystal XI, Excel 2007, Export, Export SSRS Report to Excel

use Data connection wizard / Microsoft query to get data from as400 to excel 2007
Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don’t know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database, [...]

Answer Question   |  May 12, 2011  6:33 AM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC

Keep Text to Column format in Excel 2007
We’re wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format (General). Every thing works great and [...]

Answer Question   |  May 2, 2011  9:00 PM
Excel 2007, Excel 2007 functions, Excel functions

How to call Microsoft Excel from Oracle Forms 6i
I have a form that has to put data to excel. The excel file is being created but my problem is the data is failing to insert from oracle to excel. I am using forms 6i. My machine is running Windows 7 Enterprise and office 2010. I have tried it on one with Excel 2007 [...]

Answer Question   |  March 2, 2011  8:46 AM
Excel 2007, Oracle Forms, Oracle Forms 6i

Create a macro in Excel 2007 to disable save
I need to create a macro in Excel 2007 to disable save

Answer Question   |  March 11, 2011  6:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Macros

How to connect to quick 3270 secure screen through vba macro?
hi, i use the following code to connect to quick 3270 macro and it also connect to the screen.But when i run the macro for the first time it works ,but does not work when i run the same macro for second time.If i restart the mainframe then the macro runs. Below is the code. [...]

Answer Question   |  February 2, 2011  5:44 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, VB script, VBA macro

How to accept user input and display the value in Excel 2007 macros
I Created an Excel macro that prompts the user to enter two cell numbers. I want to then display a msgbox back showing the cells that were entered. Problem. My msgbox shows the text in my message and instead of showing the values the user entered, it shows ‘TRUE’. Any ideas?

Answer Question   |  January 28, 2011  4:37 PM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excell 2007, Macros

Excel macro – create a chart
I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and [...]

Answer Question   |  January 26, 2011  5:05 PM
Excel 2007, Excel Charts, Excel macros, Macros

Excel 2007 – creating a graph from CSV data with a macro
I want to create a macro that will take a CSV file and remove the same columns each time. BUT the number of rows can vary.  Can I create a macro that will create a grapgh ? The problem is, like i said before, the number of rows can vary each time but the number [...]

Answer Question   |  January 26, 2011  4:31 PM
CSV, Excel 2007, Excel 2007 macros, Windows XP

Deleting successive rows on Excel 2007
Using VBA in a large timeline excel worksheet of 50000 rows. How can I automatically delete every 3 rows and leave the 4th row so I can reduce the number of rows to about 12,000.

Answer Question   |  January 12, 2011  10:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel worksheets

In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups
How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved?  How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?

Answer Question   |  March 11, 2011  12:00 PM
Access 2007, Backup and restore, Backup server hardware, Excel 2007, Windows XP Professional

Excel 2007 ‘Edit Links’ Command deleting information
I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit Links highlighted the file I [...]

Answer Question   |  March 11, 2011  5:58 PM
excel, Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Outlook 2007

VBA to separate overlapping times
I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here is [...]

Answer Question   |  December 1, 2010  5:46 PM
Excel 2007, Timestamp, VB codes, VBA

Problem creating during hyperlink recall with Excel 2007
if am copying a folder in desk top that folder contains xl2007 sheets, in one of the sheet i was inserted some hyperlink for supporting folder.if am pasting this folder in desk top it may creating some problem means after opened the xls file am clicking the link that time file could not be found [...]

Answer Question   |  November 23, 2010  7:00 AM
Excel 2007, Excel 2007 functions, Excel error messages, Hyperlinks

Search for column header in Excel 2007
I use a macro for a weekly report. In the macro i use “Column (“C:C”).Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: “90_day_Late”. How do i search for “90_day_Late” (say it [...]

Answer Question   |  November 25, 2010  3:42 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel functions, Excel macros