Tagged Questions

-1
votes
0answers
13 views

Assigning values to dropdown menu or checkbox in MS Word 2013 [closed]

I am putting together a Word 2013 document which is split up into 5 areas. In each of the areas, the user will be presented with 10 questions and will have to select one of the 10 questions. Dependant ...
2
votes
2answers
82 views

Excel to copy realtime data and create a chart out of it

I am very new to VBA programming. I have a excel sheet where real time data is populated to a cell say for example Sheet1.A6 everysecond. I am in need of a macro which will run every 1 minute ...
0
votes
1answer
78 views

Hide AutoExec() and AutoNew() macros from the macro list yet still have them run?

I'm trying to keep certain macros running when Word fires up or opens another document, but I want them removed from the list of macros the user can access (alt+f8). I've tried adding 'private' ...
2
votes
0answers
85 views

How to programatically pickup list items from a word file and generate few others?

I don't know much MS Office VBA. I have tons (literally) of quiz questions in word files. Task is to create question papers for students. Word file contains 900 quiz questions categorized chapter ...
0
votes
3answers
46 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
436 views

Powerpoint VBA table & object alignment

I have a macro which generates a table with 3 columns and a dynamic number of rows. The 3rd column is labled "Trend" and the macro creates an arrow pointing up, down, or to the left but these arrows ...
0
votes
1answer
55 views

Creating new xlm macros in excel 2007

Is it still possible to create (note create: not run) xlm macros in excel 2007? I have an interest in historical languages (yes, I know xlm macros aren't going that far back in the grand scheme of ...
1
vote
1answer
141 views

Word Count through Find function returns different results than Macro

I have a word count function that looks for text that is either Highlighted or Bold and Un-Underlined and then returns the number of words in a document that meet that criteria. However the results ...
1
vote
1answer
186 views

Efficient Word Count by Formatting Macro

I have a word macro that counts all text in a document that is either highlighted or Un-underlined bold. The macro works fine - although the counts are slightly higher than what the "Find" feature ...
0
votes
0answers
461 views

Can't view or edit Word VBA in Office 2013

I have to update an automated Word document (a form, essentially) with some additional fields and modified logic. I created the original myself about two years ago with Word 2010. Now I'm using Office ...
0
votes
0answers
89 views

Split Word document based on common values in a particular table column VBA/Macro

I have a word document in which there are two tables. I need to read split the word document based on values in the 3rd column of second table, also keeping the first table intact in all new ...
2
votes
1answer
531 views

How can I use VBA to lock/unlock all fields in a Microsoft Word 2010 document?

The problem I have got is that my corporate template set uses a SaveDate field in the footer of every word document - which is used to detail when the document was saved, which ties in with our custom ...
0
votes
2answers
1k views

Find Results in excel copy the rows to another sheet

I need some help copying data from one excel worksheet to another. For example: Sample Data __A__B___C 1 aaa bbb ddd 2 bbb ccc eee 3 ccc fff rrr 4 ccc fff ttt 5 ddd eee ggg 6 aaa ddd eee 7 ...
0
votes
1answer
108 views

get all bookmark-elements from a word document to an array in sorted order: VBA / Word

as the title explains, i want to fetch all the bookmarks in my word document, and then push them to an array. The bookmarks must be sorted by their location in document not by name, ex. here's a ...
0
votes
1answer
189 views

Can I record a macro to add bookmarks and cross references to a word document?

I am looking to create a macro within Word 2010 to add text to a document, bookmark this text and then cross reference this text in the header and footer of the document. Is this possible? And if so ...

1 2 3 4
15 30 50 per page