Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite. If your question is specifically about programming Excel, Access, Word or Outlook, use the appropriate tag: excel-vba, access-vba, word-vba or ...
1
vote
2answers
10 views
VBA excel code for copying sheets error
I want a copier to copy one sheet multiple times. So I have made a week planning for week 1.
And now I want this sheet 51 more times. So the name has to start with a 2 and end with a 52. To make this ...
0
votes
1answer
8 views
When using Access from within an Excel spreadsheet, the PC won't go to sleep
I've stumbled accross a problem I am unable to solve :(
Neither Google nor StackOverflow have given me any usable answers, so I'm turning to you.
The problem is this:
I've created a spreadsheet that ...
0
votes
1answer
18 views
ORA-00917: Missing Comma error in VB
I am having a lot of trouble trying to get some VB code to work in Excel, when trying to write to a DB. I keep getting this comma error, but i cannot for the life of me see where the comma is ...
0
votes
0answers
10 views
During run time of the macro, how to make the excel file editable
I am Fetching the most recent data from database and writing it to the excel, which get updated after every two seconds. It is working properly. But I want to edit the excel file editable while macro ...
0
votes
1answer
13 views
MS Word VBA to display Unicode strings
We have some VBA code in MS Word 2010 which needs to display Persian (Farsi) words dynamically; in other words, depending on which buttons the user clicks on the VBA app window, we will display a ...
0
votes
0answers
14 views
How to split the copied data in two or more excel sheet using VBA
I am using one of the report generating tool to generate the list of Users. Some times the data is so huge (more that 7,00,000) that I cannot paste it to the excelsheet(unable to copy the rows more ...
0
votes
1answer
19 views
excel attendance sheet(macro)
Public rctr
Public cctr
Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+A
'
Call RCount
Call CCount
If Range("B" & rctr) = "" Then
Range("A" & rctr).Select
...
1
vote
0answers
22 views
Formula displays as text regardless of NumberFormat being set to General
Okay, so my issue is regardless of the NumberFormat being set my formula still displays as text until I go into the cell and hit enter. What I am trying to do is dynamically create a new column and ...
0
votes
0answers
15 views
JSON to Anything (Dictionary, XML, …) Converter
I need to work with a complex json within vbscript.
Now I'm searching for a converter to Dictionary, XML or anything else which is good to use in vbscript.
It is not possible to implement further ...
0
votes
3answers
30 views
How to find value of one column in another and change color?
I'm new to Excel Macro VBA, so please bear with me.
I have an Excel file set up like this:
Col1 Col2
---- ----
a a
b c
c e
d g
e i
f
g
h
i
j
I want to write a ...
-1
votes
2answers
30 views
Get filepath from filename in vb?
Like ie.exe
It would find the path for ie.exe, and return something like:
C:/Program Files/Internet Explorer/Data/Apps/ie.exe (or whatever the path actually is)
How would I go about doing that?
1
vote
0answers
46 views
getting error “Object Variable or With block variable not set”
I have created an Add-In for Excel which determines the name of ActiveSheet and ActiveWorkbook. The code I used is below. When I run the Add-In it is showing the above mentioned error after the ...
0
votes
0answers
33 views
VBA Excel + Date UK/US error
New to macros here.
Have a macro that does a reasonably simple calculation:
Table(j, 13) = DateAdd("m", j, Day(DoD) & Run_Start)
Basically pulls the day from a another date called DoD, ...
0
votes
1answer
33 views
File Open Help - Excel Macro
I am relatively new to scripting and thus have come here to ask for some assistance to help me build an excel macro. I am currently working on an excel file to speed up data capture and verification. ...
0
votes
1answer
37 views
how to populate textbox depending up on combobox value?
I have this scenario where I have a combo box name contract, row source type is table/query. Now on the text box I would like to display the name of the person, telephone, mobile, fax, address. A ...
