The tag has no wiki summary.

learn more… | top users | synonyms

-4
votes
0answers
9 views

Word macro referencing Excel worked in Office 2007 but fails in 2010 [migrated]

I created a VBA macro in Word 2007 that determines if Excel and a specific Excel workbook is open, opens the workbook (and Excel if needed), then performs various tasks in the workbook. Under ...
2
votes
1answer
71 views

Why would a program allow an object to be initialized when it doesn't support all methods/properties of the interface type it was defined as?

I'm under the impression that an object MUST support all methods/properties upon being initialized or else the program will create an error. However, if you see below I am defining 2 variables (doc ...
1
vote
1answer
111 views

Managing sets of configuration data for an Excel/VBA program

I have two versions of an "Excel-Tool", i.e. a spreadsheet with a lot of vba code. Lets say, this tool is used to monitor two facilities. Both facilities differ in minor aspects. That means, I have ...
6
votes
6answers
640 views

performance versus reusability

How can I write functions that are reusable without sacrificing performance? I am repeatedly coming up against the situation where I want to write a function in a way that makes it reusable (e.g. it ...
1
vote
1answer
115 views

Range or Row and Column Indices in VBA

I would like to know what the pros and cons are for storing a range variable instead of four integers or long variables (representing the first and last row and column) to define that range. One ...
17
votes
7answers
4k views

Team member questioning moving from VBA to C#

Background Last year, I was asked to create a tool to be used for business planning for around 10 users. This was done on behalf of another IT team who "sub-contracted" the work to me, and due to the ...
1
vote
1answer
218 views

Should I use Strategy Pattern for this task?

I'm setting up a data validator that will iterate through the rows of a spreadsheet, and for each column, perform a validation check. I was thinking that this might be an appropriate task for the ...
1
vote
0answers
1k views

Excel: Vba Copy and paste efficiency with 000's of rows and columns

Hey guys so I'm sure this is probably out there but I can't seem to find it. Updates I have tested some different code, and reduced my time to complete the task from 50/60 seconds to 10 seconds. ...
-3
votes
1answer
168 views

Automating daily procedures [closed]

Is there a way to automate running VBA in Excel to clean up the file from inside an application? Everyday my office has to confirm that 50 people have shown up for work on time. The scheduling ...
4
votes
1answer
180 views

Implementing a Username Class

I am attempting to encapsulate several features about a user in a single class. Although the main use for this class would be to initialize it once and never have to call set any variables again, I ...
2
votes
4answers
894 views

Why does Microsoft still ship VBA within Office products, instead of integrating .NET directly? [closed]

I know that it's possible to call .NET code from your VBA code, but why does VBA continue to exist? The only reason I can think about is legacy. I just had to sort a Scripting.Dictionary and the ...
3
votes
2answers
358 views

Why does VBA / VBScript require “Set” prefix

When I set a variable to an object in VBA / VBScript, I always need to prefix the statement with "Set" such as: Set Dict = CreateObject("Scripting.Dictionary") If I set a variable to a primitive or ...
6
votes
2answers
2k views

Is there a difference learning VBA on Mac vs Windows [closed]

I'm a programmer who'd like to learn VBA, but I don't have a Windows box. However, I have a MacBook Pro with the latest version of MS Office for Mac on it (2011 I think). Since I work in a .Net shop, ...
0
votes
1answer
1k views

Guidance on Excel VBA resource scheduling algorithm?

This was posted originally at StackOverflow though suggested to post here instead. I am looking to create an Excel VBA solution that will create a rota/schedule allocating staff to service users ...
3
votes
0answers
393 views

Implement FBP / Dataflow programming in VBA?

Intrigued by Flow Based Programming a la J Paul Morrison. I wonder if one can implement FBP in Excel/VBA. I searched quite a bit for a Basic-Lang FBP implementation to no avail. I've looked at some ...
2
votes
1answer
194 views

Enterprise application with lots of SQL queries

Context: I'm working on a fairly large Access database (which I inherited) that has its interface and tables separated. In order to make this work together, we have a lot of SQL queries (dozens). ...
0
votes
2answers
9k views

What's the difference between VBA and VB Script? [duplicate]

I need to get VB Script training so I think it's a good start point.
0
votes
3answers
288 views

Which programming designs leads to more problems?

As a fresh programmer, one of the first thing for me to learn was to learn language and its syntax. Now my next training issue is to design my code heirarchy in such a way it is simple to maintain ...