Tagged Questions
3
votes
0answers
566 views
Excel VSTO fails to load if there's VBA macros
I have an excel XLS developed with Visual Studio Tools For Office (VSTO) 2005. Most of the code is in C# VSTO, but there is also a VBA macro to implement a worksheet function. I'm not trying to have ...
2
votes
0answers
64 views
Excel macro not working after upgrading to Office 2013
My company uses excel to produce network configs that go out to all of our stores. the configs are pretty much same with the exception of a few variables that get inputted into a variable sheet in ...
2
votes
0answers
469 views
Excel worksheet - if the column contains X then copy the row and all rows with the same word in column A to sheet 2
The current code copies content from sheet 1 to sheet 2 if X and from sheet 1 to sheet 3 if Y. I need it changed so that if a row in column B = X it copies every row that has the same word in Column ...
2
votes
0answers
263 views
How to release an vb.net class libary object from Excel VBA
as the performance of Excel VBA was to poor for my calculations, I migrated my code to a VB.net class libary which I add as a reference in Excel. I am using VBA for all my read and write function, but ...
2
votes
0answers
157 views
Regroup data automatically
I would like to group data in my Excel in a automatic way (by using a macro)
For example, in my column A, I have fields tuck as this:
in A1 I have " 1.0.1",
in A2 " 1.0.3",
in A3 " 1.0.5",
in ...
2
votes
0answers
262 views
Look up Column number in a range?
I'm trying to use the filter option to filter my range.
ActiveSheet.Range("$K$2:$ZZ$200").AutoFilter Field:=11, Criteria1:="yes"
Basically that will filter Column U for yes.
What I have is a ...
1
vote
0answers
44 views
Using Range.Offset but “User-defined type not defined” popup in VBA
I write a simple function in the Modules as follow:
Function allocate(ByVal pq As PriceQtyClass, ByVal al As AllocationClass) As Boolean
Dim tmpRange As Range
Dim tmpDic As Dictionary
...
1
vote
0answers
24 views
Subtleties of Office / VBA in different Countries
I have a Question about Microsoft Office.
I have an Excel Sheet with about 20 Macros, some for unziping a *.zip File and inserting the Data from xml files into Excel. Others create with the Excel ...
1
vote
0answers
57 views
edit the program to sumif with visible cells in MS excel
i got some countifv thats counts visible and sumifsv which sum visible cells only ... i want sumif only visible using vba
Default Using SUMIFS on visible lines only
I have a large table, lots of ...
1
vote
0answers
57 views
SharePoint + Excel with Macro
I'm trying to figure out how to move an Excel spreadsheet from a mapped drive to SharePoint.
We have an engineering department who uses this spreadsheet to keep an active list of job and job numbers.
...
0
votes
0answers
12 views
Restrict the data in powerpivot based on the user who is using file in excel 2010
I wanted to create a powerpivot report. In which i wanted to show only the data the user authorized to view based on his windows credentials.
For example consider the following table
ID Code ...
0
votes
0answers
38 views
VBA How can I make a code to create tables from a set of data
I have a worksheet which comes in every week with the same format that I need to summarise information for, for a number of Business units. The format is as follows:
The worksheet is populated from ...
0
votes
0answers
52 views
QueryTable refresh generates two HTTP GETs
The following VBA in Excel 2007 generates a call to a perl script on the host. It works exactly as intended, except it consistently generates two calls. First the code:
With ...
0
votes
0answers
93 views
VBA help - inserting data lines in excel 2012
Have the following snippet of data
Bank Address City State Zip Product Effective Date
Bank 1 Address 1 Plano TX 75024 Auto 08/01/1997
Bank 2 Address 2 ...
-4
votes
0answers
26 views
Rationalization Model in Excel
Hey guys I have to make a Retailer Rationalization model where the algorithm will be something like this
A Form which will have certain parameters like Volume/Spokes etc. Data will be entered into ...
