The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft. The version independent Tag is "excel". If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.
0
votes
1answer
30 views
Why doesn't isError( ) work with a vlookup statment in excel VBA
I'm using excel 2007 and have created a UDF that includes three vlookup() statements. The function is supposed to return the sum of all three vlookup statments. In the majority of cases, only two ...
1
vote
1answer
26 views
Close/Release Word object in VBA?
I have the following code to open the manual for an Excel Workbook application I have developed:
Sub OpenManual()
'Word.Application.Documents.Open "\\filePath\FormFlow To ...
0
votes
0answers
7 views
Troubleshoot open xlsx files
//IMPORT LIST
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.openxml4j.opc.OPCPackage;
import ...
0
votes
0answers
7 views
How to connect to AS400 & update worksheet with data from 400 Table in Excel?
I have an Excel workbook with several worksheets. I need to connect to AS400 and make it to where when users click refresh, 2 worksheets are updated with data from 2 tables on the 400.
Anyone know ...
0
votes
1answer
23 views
How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date.
I keep trying the the following
ActiveWorkbook.SaveAs ...
0
votes
1answer
26 views
How to modify my VLOOKUP() to search for only 1 character?
I have several cells in an Excel Workbook with dropdown lists. Other cells use VLOOKUP() to search reference worksheets for the description of the dropdown value code.
I had to modify my dropdown ...
0
votes
1answer
16 views
'problems' with sumifs returning 0
sumifs return 0 in some fields
forumla look like this : =SUMIFS($H$3:$H$12,$B$3:$B$12,J$15,$C$3:$C$12,$I16)
1
vote
0answers
14 views
changing axis labels in excel 2007 charts using python win32com
I have an excel sheet with some data in first two columns. I created a simple chart with this data. I am facing problem in adding axis labels to the chart.
here is my script
from win32com.client ...
-1
votes
0answers
42 views
Best way to import data in excel from SQL Server db
What is more secure way of importing data to excel from SQL server? By Importing it From SQL Server(Which creates connection to SQL Server table) or From Analysis Services(Which creates connection to ...
0
votes
3answers
28 views
How to Loop Through 5 Cells in a Row Using Excel VBA
I want to loop through 5 cells, Q5 - U5.
With each cell I want to check if the value is equal to "Y", and if yes, highlight the cell to make it green.
How may I do so? Can't seem to figure it out.
...
0
votes
1answer
13 views
Excel: how to seperate a column into 2 columns [closed]
I am using Excel 2007.
I have a column in my Excel spreadsheet. It contains data that should be seperated into 2 columns.
In this column, some rows are dates. Some are email addresses. Some are ...
-2
votes
1answer
9 views
How to modify font of multiple cells at a time in excel document using Perl/ Tool(any)? [closed]
I have to Create/edit lot many excel documents for in my projects. Meanwhile I faced lot many problems; One among those problems is changing font of word in cells. My exact problem is I have to change ...
0
votes
1answer
17 views
Clear cells that are dependents and have validation lists
I need some help. I'm setting up a spread sheet that has multiple validation lists. Each validation list has multiple validation lists linked to them (dependents). When I change the first ...
1
vote
1answer
68 views
I need helping writing an excel vba Splat function
I'm using Excel 2007 and need some assistance / guidance on how to write a Splat user defined function function. The Splat function enables you to input data into a cell that contains a vlookup ...
4
votes
2answers
43 views
SUMIFS Formula that would check multiple columns
I have an excel sheet and am attempting to incorporate a SUMIFS formula which would check one column for an condition then check another group of columns to see in the match a condition in order to ...
