Questions tagged [vba]

Microsoft Visual Basic for Applications

Filter by
Sorted by
Tagged with
0
votes
2answers
9 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
3 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 ...
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 ...
0
votes
0answers
7 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 ...
-1
votes
2answers
17 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 ...
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
16 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
13 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 ...
1
vote
1answer
19 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
22 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 ...
0
votes
0answers
27 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 ...
0
votes
0answers
48 views

parent-child tree with csv data?

I found this solution posted by Vincent Tang -How do you create a parent-child tree with table/excel data?. However, I have 50K rows in the input file and the program hangs. Any better way to get ...
2
votes
3answers
114 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 ...