Questions tagged [vba]

Microsoft Visual Basic for Applications

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
8 views

Which programming language works with tables and databases, considering reports and GUI?

I’ve been working with VBA previously but i want to learn other programming language, having a project in place I would like to know which language to pick and start learning… This project is based in ...
1
vote
0answers
12 views

Update VBA macros across multiple Excel files

I have created a few VBA Macros and I need to use the same macros in different files. So say I have a macro "X" and I have files "A", "B" and "C" that use the same macro "X". Currently whenever I ...
1
vote
0answers
15 views

Free embedded database for VBA/VB.NET billing desktop application

This is mt first post, so any mistakes pls excuse. I have created a excel based billing system using forms and VBA. Basically when i open the excel file and select the customer name, his details are ...
0
votes
0answers
209 views

Generalized Excel VBA tool to run SAP reports and save output

My team often needs to extract data from the SAP R3 GUI into a file format such as Excel. We have been using VBA scripting to do this, using the approach described in https://stackoverflow.com/...
0
votes
0answers
2 views

Automating word report by VBA vs JavaScript API

I'm doing an automation tool for my team to do the daily report. The report is net worth and income verification, which is kind of standard but still different case by case. The usual routine for ...
0
votes
0answers
5 views

Parent, Child, Descriptions and Code Tree View

Good day community, I am trying to create a tree view in Excel using 5 columns (Parent, Child, Description, Code and Code Description). I managed to find some useful code below but would like to add ...
0
votes
0answers
16 views

Tool to connect Excel VBA macro to IBM AS/400 Access Client

I am working with data in excel and IBM AS/400 Access Client. they linked together using vba macro. However, recently my company wants to change to IBM AS/400 Access Client Solution which is the ...
0
votes
0answers
29 views

Extract table from PDF offline, on a computer where I can not install anything, but where VBA is available

I need advice if/how the following is feasible. I am working on a computer, which does have Excel 2013 but no Adobe Acrobat installed. No third party software is to be installed or used. Now I want ...