Tagged Questions
0
votes
1answer
36 views
“Importing” CSV into open Worksheet
So I am looking for a VBA method that duplicates the default behavior/parsing when opening a CSV file (Double-clicking the file itself) without using the Import Text Wizard.
Since this is opening ...
0
votes
3answers
69 views
Write a Macro in VBA - excel AFTER the user has closed the Excel
I need to write a macro in Excel VBA, that terminates a process running in windows tasks AFTER the excel has been closed down. I tried it doing this on event workbook_BeforeClose
Private Sub ...
0
votes
3answers
33 views
Copying the rows to different column with rows incrementing by 21
I want to copy my data from different rows to some other column.
Example.
B4 has to be copied to H129 ,
B25 to H130,
B46 to H131...and so on ..
Here the rows are getting incremented by 21 rows .
...
0
votes
3answers
211 views
Excel change column format using macro
If there is word COST in column name then change the column format to currency using macro for excel.
like if column name is - "Final Cost" or "Total Cost" or "Item Cost"
then change column format to ...
0
votes
1answer
189 views
Copy specific area with points in Excel
I want to copy i specific area in Excel using points.
Actually I want to copy the print area for landscape in Excel to my Word document, where I run the code from. But I haven't really found a good ...
0
votes
1answer
173 views
Auto insert a dropDownList when a new row
I have an excel sheet with three columns. (Name), (Surname) and (Identity Type). The colum identity type can take only 3 values, (Id,Passport,Drivers Licence). What i want is when the user Start ...
1
vote
1answer
610 views
MS Office VBA changes from 2003 to 2010
in my company the IT-department finally decided to switch from MS Office 2003 to 2010. In my department we developped many small Applications running on VBA. Particularly all of them were programmed ...
0
votes
1answer
547 views
excel vba msoShapeType enumeration item - msoIgxGraphic - 'not defined'
The following sub, which enumerates interesting properties of the shapes collection of the active worksheet, does not compile when Case msoIgxGraphic is included. Though I swear that it did compile ...
1
vote
1answer
3k views
How do I change the font size and color in an Excel Drop Down List?
I was wondering if its possible to Style a Drop Down List in Excel. The text is rather small and has no styling and I was wondering if the drop down list styling could be changed?
What would ...
1
vote
2answers
332 views
Customizing Office (Word/Excel/PowerPoint) standard toolbar, ribbon, menu and context menu from my plugin
I've an Office plug-in implemented in C++.
Depends on the context and logic of my plug-in, I would like to enable/disable some existing UI elements of Office (menu, ribbon, context menu, and for old ...
0
votes
2answers
1k views
Auto sort and format and Excel
I have a table of clients in Excel, and I want to be able to add new client into the last row of the table and excel will sort the table automatically so that the client's name will be sorted in ...
11
votes
2answers
3k views
How to comment and uncomment blocks of code in the Office VBA Editor
In the VBA editor of Office (ALT + F11), how do you comment or uncomment a block of code?
5
votes
1answer
207 views
Using base64 data stored in CustomXMLPart as image in Office
As a followup to this question about using images stored in an Excel file on a button in the ribbon:
Is it possible to use an image stored in a CustomXMLPart/CustomXMLNode in base64-encoded string as ...
0
votes
0answers
294 views
Does this copy all formatting of a gradient from a ShapeStyle'd object to another Format?
This issue has arisen as a result of a previous question:
How to apply ShapeStyle to a specific Series of a Chart in Excel using VBA?
I am trying to copy a ShapeStyle from an object in Excel to ...
1
vote
3answers
5k views
Auto increment row number in excel sheet
I have the following formula written in the cell B5
=SUMPRODUCT(--(COLORINDEXOFRANGE(Data!D10:HO10,FALSE,1)=COLORINDEXOFONECELL(Data!$F$3,FALSE,1)))
When i drag down from B5 to the next row, the ...
