Stack Overflow
Stack Overflow

Questions tagged [visual-studio-macros]

A macro is a series of commands and instructions that you group together as a single command to accomplish a task automatically. Macros allow you to automate repetitive actions. Visual Studio includes the Macros integrated development environment (IDE), which is used solely for creating, manipulating, editing, and running macros. The Macros IDE is separate from the Visual Studio IDE.

The Visual Studio Macros integrated development environment (IDE) has the same look and feel as the Visual Studio IDE, but is separate from it. The Macros IDE includes the Code Editor and several tool windows. These windows function the same as their Visual Studio counterparts, except that they apply specifically to the code and projects within the Macros environment.

209 questions
0
votes
1 answer

Use a module for all excel files in a folder

I have created a module for an excel file which is kept in a certain folder on the system. I want to be able to use that module for all the excel files that will be stored in that particular folder for the days to come. The trick is that this module…
varunagarwal97
  • 11
  • 5
0
votes
1 answer

Search 'Checked' CheckBox in Another Excel File using vba macro

My problem I think is quite simple, but since I am new to this excel vba macro, it is quite tricky. To put it simply, I have two excel file.One with "Refresh" Button. Another excel file with several CheckBoxs, with some words and number in…
silver_river
  • 169
  • 1
  • 10
0
votes
1 answer

Running multiple queries in access with two variables changing

Right now I have this query that I am running in Access: UPDATE [Part B Mater Table] SET [Part B Mater Table].MCCat = 1 WHERE ((([Part B Mater Table].fyear)=1990)) AND CUSIP IN (SELECT TOP 33 PERCENT [Part B Mater Table].CUSIP FROM [Part B Mater…
user3577371
  • 3
  • 3
0
votes
1 answer

Match full line

I want to match a full line containing a word, say its 'josh' "^13*[!^13]@^13" doesnt match anything in my document: Josh Joshd adf Josh fffJoshfff
JoshDG
  • 3,871
  • 10
  • 51
  • 85
0
votes
1 answer

macro to extract dates from a weeks date range string and add 7 days to print next date range

I am writing a macro that processes an excel with lots of data. One of the rows contains a date range like wkstartdate - wkenddate and I would like to use dateadd function to print next date range every week (like '27-01-14 - 02-02-14' in below…
user3269635
  • 3
  • 1
0
votes
0 answers

Modify VBA macro to delete unneeded text

I have a .txt file that needs to be cleaned up. It needs to have a page break before the word "Individual" on every page. It also needs to be Courier New 8.5pts, top and bottom margin of 0.5in, left and right margin of 1in. I modified another script…
Mr.Syrax
  • 396
  • 1
  • 9
  • 26
0
votes
1 answer

Find text in File, Copy and Paste in Cells Excel VBA

I am writing a code in VBA to look into a file for a characters that the unser inputs in the macro, after the macro finds the characters provided by the user I want it to extract that whole line and past it in a sheet in excel by taking the first…
Alfredo A.
  • 3
  • 3
  • 8
0
votes
0 answers

Visual Studio 2012 VC++ debugging

I am using Visual Studio 2012 VC++ for debugging some of the code. Is it possible to log the list of functions the program is hitting and provide a snapshot of the variable when it hits at the specific point. I am trying to place breakpoint at many…
Matt
  • 179
  • 1
  • 3
  • 14
0
votes
1 answer

How to open and save a notepad.exe using Macro

I'm new to programming and so I have come here for some help. I need to copy a text field from excel and paste it in a notepad and then save the notepad with the specific name to a specific location. These things should be done with the help of…
narayanan
  • 3
  • 1
  • 2
  • 5
0
votes
1 answer

How to select shapes using vba in an already created Visio drawing

I have a Visio drawing and I want to be able to Select shapes from it and paste them to other sheets depending on certain variables. What is the code for selecting the different shapes on the page. I am trying this but it is not working. Dim…
JahKnows
  • 2,618
  • 3
  • 22
  • 37
0
votes
1 answer

Find Function in Excel VBA

I want to search for all Dates belonging to a month. The Month will be selected by the user. I am unable to search all dates, I only get the last date which is entered. I am using find function and unable to provide the specific conditions. mois…
Ameya
  • 69
  • 2
  • 10
0
votes
1 answer

Set Legend Text Pie Chart

I have been trying to set my two legends using a VBA Macro. I want to change my two legends from 1 and 2 to Male and Female on my Pie Chart. I can change it manually by setting it in the "Select Data Source" dialog by setting "Category (X) axis…
Jacques Blom
  • 1,794
  • 5
  • 24
  • 42
0
votes
2 answers

get selected cell in table powerpoint 2007 vb.net

I need to get the selected cells of a table. I tried the following code Set oTbl = .ShapeRange(1).Table For x = 1 To oTbl.Rows.Count For y = 1 To oTbl.Columns.Count If oTbl.Cell(x, y).Selected Then With oTbl.Cell(x, y).Shape …
Intricate
  • 117
  • 1
  • 11
0
votes
1 answer

Implementing a Macro on Excel

I have two worksheets in excel. First Worksheet has User vs Transaction Code. Second Worksheet has User vs Module The Result I want is : What User has what transaction code and module. How do I write a macro so I can get to know which user is in…
user2531308
  • 17
  • 8
0
votes
2 answers

Sheet Specific macros

I have a workbook with three excel sheets in it. I want a user to be able to copy data from the third sheet which is result of calculations in the second sheet. How ever, the code I am using 'The code for the Macro Sub…
Ameya
  • 69
  • 2
  • 10
1 2 3
…
13 14