Questions tagged [vba]

Microsoft Visual Basic for Applications

11 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
1answer
20 views

C# Library for manipulating Excel Files?

I'm working on a project to migrate excel data into new excel files that are compatible with another system. As part of this work, I have to do a lot of data manipulation between excel sheets (...
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
4 views

On editing protected view using “ProtectedViewWindow.Edit”, settings under “Display options for workbook” are getting changed

When I call ProtectedViewWindow.Edit in ProtectedViewWindowOpen event, document gets open successfully without protected view but all settings under options-> Advanced -> "Display options for workbook"...
0
votes
0answers
78 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
2answers
11 views

VBA in Excel vs Access for data conversion

We are upgrading our enterprise software and part of that effort I have to perform sales order (data) conversion from legacy to new software. I have moderate experience with macros/VBA in excel and I ...
0
votes
0answers
4 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
13 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
28 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 ...