The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
8 views

VBA Array cell value duplication problem [migrated]

I'm struggling with the same kind of problem for weeks. I thought now is the time to as professionals on the web: Dim txt, show As String Dim NameList(1 to 50) as Varriant Dim i, j, t As Integer t = ...
2
votes
2answers
135 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 ...
4
votes
1answer
188 views

Is there a difference learning VBA on Mac vs Windows

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
543 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 ...
2
votes
0answers
324 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 ...
1
vote
1answer
164 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). ...
-1
votes
2answers
2k 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.
2
votes
3answers
1k views

Query regarding VBA as career option [closed]

I am a dot net developer, with over 7 years experience in VB, Vb.net, C# and Asp.net. Would it be worthwhile to learn VBA/VSTO? Would it be adding value to my career? Would there be any companies ...
0
votes
3answers
251 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 ...