Questions tagged [vba]

Microsoft Visual Basic for Applications

Filter by
Sorted by
Tagged with
5
votes
2answers
77 views

What softwares should we use in creating a live web-based dashboard?

We're new programmers in the company and our supervisor wants us to make a web-based dashboard that updates every time. But there are even no senior programmer here that helps us and trained us ...
2
votes
3answers
121 views

Software to learn Excel VBA without buying Excel

I have a job interview coming up, and I've been told to brush up on using Visual Basic Applications in Excel. That would be fine, but I have no experience with the BASIC language. On top of this, my ...
2
votes
1answer
21 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 (...
2
votes
1answer
22 views

Library to modify Excel in Python

I love to use Python, but I also found C# and VBA as options. I want to read one Excel file, then search another Excel file (with multiple sheets), and use this information to modify the initial ...
2
votes
1answer
23 views

Ingesting word documents into internal systems [closed]

Current Problem: We have a vendor that provides us with a bill of lading in the form of a word document via email, and we are looking to ingest this information into our SQL Server database. I've done ...
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
7 views

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

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
86 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
14 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 ...
-1
votes
2answers
19 views

Convert CSV file to another layout

I would like to change the layout of a input CSV file and change the layout of values. So the initial Format has headings like: - Customer Zone Type 1 2 3 4 5 6 7 8 9 10 11 12 Under the number ...