Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it [tag:excel-vba]. If it is about an Excel formula or worksheet function, then also tag it ...
0
votes
0answers
5 views
Code to check if cell names are the same in excel
I have 16 different datasets and 112 different variables in each dataset but I would like to know if there is any function to check if the variables match in each dataset.
I have the variables copied ...
0
votes
0answers
5 views
subtotaling on live data macro
I have created a data table through Sharperlight reporting thats generates its results into excel as shown below:-
What I want to do is develop a macro that will subtotal all categories for the ...
1
vote
2answers
13 views
How to Convert Excel Numeric Cell Value into Words
I am working with Microsoft Excel 2007 and I have one Numeric Column in my Sheet.
is there any solution that I can convert its Words equvalent?
I am attaching Excel Sheet's Screen Shot.
0
votes
0answers
6 views
Accessing Outlook email info into excel worksheet (VBA): body, HTMLbody, RTFbody is <> empty
Thank in advance for the help... my Googleness has failed me today.
I have found quite a few sources on accessing email info with excel VBA, and for the most part I can get them to work. But for ...
-2
votes
0answers
7 views
How to write data to Excel with multithread in by vc++
An unhandled exception disappears when the ceate Excel applitation in thread. who can help me?
0
votes
0answers
8 views
Insert a value from Excel cell to Word document
I have two documents, one Word and other Excel document(word.docx and excel.xlsx). In a Word document, I have something like " My salary for this month is (empty), and I worked (empty1) days." So ...
0
votes
0answers
12 views
Get the value based on another value that is present in seperate sheet
I have an excel containing two sheets SHEET1 and SHEET2
SHEET2
A 1
B 2
c 3
SHEET1
xyz A
now what i want is, whenever i type A in Sheet1 the corresponding value which is ...
0
votes
0answers
7 views
Excel VBA adding lines to a word document table
I'm trying to find a way to add lines and information to a prebuilt table in a word document. The table is right now only two lines. The headers and a blank line (2 Columns). How would I go about ...
0
votes
2answers
16 views
WSH VBScript switch workSHEET in already open Excel workBOOK
Is it possible to switch worksheets within a workbook in a WSH VBScript (referenced by name) and if so, how would I do it?
This will be used in a script that already opens an Excel file. I want to ...
0
votes
0answers
9 views
can't use application.worksheetfunction.linest in a loop
i'm trying to make a function that calculates the LINEST for a different ranges of data within a big two dimensional array, everything works fine except for when i need to use the function LINEST ...
0
votes
1answer
10 views
Issues with VB and Aspose
I have the following lines of code:
Dim ms As New MemoryStream(my_memory_stream)
workbook As New Workbook(ms)
workbook.Save("C:\book1.xlsx")
My purpose is to save the stream contained in ...
0
votes
0answers
13 views
Finding Cell Location in Excel with Apache POI
I have cell objects that I am writing to from an array of information. What I am trying to do is have it that the program will handle any size of array so the cells are being filled in dynamically i ...
1
vote
0answers
10 views
Microsoft Office interop perfomence issue
I am try to exporting datagridview data to excel file in my C# 4.0 WIndows application.
we used Microsoft.Office.Interop.Excel dll version 12.0.0.0. It's works well and everything
is fine. But i ...
0
votes
1answer
18 views
Calling an excel macro with paramters from SAP ABAP
How can I call an excel macro with parameters from ABAP? I've found plenty of references for calling a macro without parameters online using the following method:
CALL METHOD OF obj_ex_APP 'Run'
...
0
votes
0answers
9 views
Batch Command for copying filename from folder to excel and removing duplicacy for same
I want to copy filename from folder to excel file. Also want to remove duplicacy of files. As when I shoot raw photos and rename them it makes filename like: abc (1), abc (2), abc (3), abc (4)....
I ...
