excel-2010 Questions
7
Solved
I am converting a table into Pivot and then to a CSV file. I want to remove the subtotals of the pivot table. So far: this is my progress.
MACRO CreatePivot:
Sub CreatePivot()
' Creates a PivotT...
Citizen asked 11/6, 2014 at 19:18
2
Solved
How can I reference a cell in the same column in the previous visible row from a filtered range?
Commodus asked 12/3, 2015 at 18:2
4
I am new to python.
I have a simple dictionary for which the key and values are as follows
dict1 = {"number of storage arrays": 45, "number of ports":2390,......}
i need to get them in a excel s...
Reparation asked 17/2, 2015 at 5:15
9
Solved
I have an Excel 2010 spreadsheet with links to external data sources including Bloomberg, 65 worksheets with VBA modules and references to other VBA add-ins.
The VBA project has acquired multiple W...
Sesqui asked 16/8, 2013 at 12:11
6
Solved
I need to compare two csv files in windows7.
How can I proceed to achieve this. I want to see the differences in both the files , like we can use tkdiff in Linux.
Transverse asked 4/11, 2015 at 13:38
9
Solved
I am writing a VBA code that goes through a range of cells checking if each cell has data validation (drop down menu) and if not assign one to it from a list on another sheet.
I currently have tro...
Paraphrast asked 5/9, 2013 at 17:55
5
Solved
In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?"
Application.DisplayAlerts = False
Set xls = CreateObject("Excel.Application")
Set wb = xls.Workbooks...
Taction asked 31/1, 2013 at 20:23
15
Solved
I have a column of values that often appear as duplicates. I need to create a new column, of unique values based on the first column, as follows:
Column A Column B
a a
a b
b c
c
c
This Column B...
Stomacher asked 9/11, 2012 at 12:16
20
A colleague at work made some changes to one of our macro workbooks and now on my PC only I receive the dreaded Run-time Error '32809' when I attempt to run it. This latest version runs fine on his...
Highspirited asked 8/11, 2013 at 14:22
7
I'm facing org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save:an error occurs while saving the package : The part /docProps/app.xml fail to be saved in the stream with mars...
Leastways asked 6/11, 2013 at 10:56
3
Solved
Using 2010 Excel VBA - I'm just trying to open a folder through a sub. What am I doing wrong here?
VBA
Sub openFolder()
Dim preFolder As String, theFolder As String, fullPath as String
theFol...
Wiskind asked 2/7, 2013 at 13:18
5
I am wondering how I can check if more than one cell is celected in a range?
I have 3 cells i want to check the Ranges are "A:B" and also "D", and im trying this code but its not working for me. ...
Labelle asked 16/6, 2015 at 6:26
8
Solved
I have different Collections in my code. Some hold Objects (of various kinds), others have types (like Long) within them.
Is there a way to check if a key is contained in the Collection that works...
Mahmud asked 24/6, 2016 at 7:24
2
Solved
I have an Excel 2010 template file with macros that includes the following code:
ActiveWorkbook.SaveAs Filename:= _
newname, FileFormat:= _
51, CreateBackup:=False
This saves the current work...
Billiot asked 16/3, 2017 at 12:46
5
Solved
I cannot find a way to change the color of an Excel data bar based on value. Current formatting options only permit different colors based on positive/negative values. I'm currently using Excel 201...
Amadeus asked 4/6, 2015 at 1:11
5
Solved
Whenever I do a dependent dynamic drop down list , I see a bunch of blank cell in the drop-down list , I search many topics that explain how to remove them while by adding two additional ranges lik...
Herpes asked 12/8, 2015 at 15:27
5
Solved
I'm using VBA to read some titles and then copy that information to a PowerPoint presentation.
The problem is that the titles have special characters, but image files that I am also coping over do ...
Vintner asked 23/6, 2014 at 0:23
16
Solved
I would like to write an IF statement, where the cell is left blank if the condition is FALSE.
Note that, if the following formula is entered in C1 (for which the condition is false) for example:
...
Chimpanzee asked 12/9, 2013 at 15:9
3
On my first worksheet in the workbook, I have a large table with multiple columns and rows (roughly a 1000 rows and 20 columns).
I was wondering if it is possible to display part of this table in...
Yellowgreen asked 11/6, 2013 at 0:46
5
Solved
In excel below formula will generate random number from a normal distribution with mean 10 and variance 1. Is there a way to set a fix seed so that i get a fix set of random numbers all the time? I...
Parotic asked 16/10, 2015 at 1:27
8
Solved
I have 8 variables in column A, 1,2,3,4,5 and A, B, C.
My aim is to filter out A, B, C and display only 1-5.
I can do this using the following code:
My_Range.AutoFilter Field:=1, Criteria1:=Array...
Samarium asked 18/2, 2015 at 4:3
5
With the help of this .doc to pdf using python
Link I am trying for excel (.xlsx and xls formats)
Following is modified Code for Excel:
import os
from win32com import client
folder = "C:\\Opranc...
Extensometer asked 31/12, 2013 at 9:15
7
Solved
I would like to create costum menu button using VBA in my excel 2010 file using predefined excel button that use face id. In my case i would like to use "lock" and "refresh" icon, but doesn`t know ...
Nonplus asked 12/9, 2011 at 1:50
3
I need to calculate the total hours and minutes between two dates mentioned in excel. i.e.,
Start date: 02-Sep-2013 02:03:00 AM
End Date: 04-Sep-2013 02:04:00 AM
The answer should be 48:01 ...
Eye asked 3/9, 2013 at 6:13
13
Solved
I have an excel sheet created by a 3rd party program.
One of the columns has dates in this format: "Jan 19, 2015 03:00:00 PM"
I would like these dates to appear in the following format: "19/01/20...
Guillot asked 14/2, 2015 at 15:7
1 Next >
© 2022 - 2024 — McMap. All rights reserved.