Questions tagged [vba]

Microsoft Visual Basic for Applications

Filter by
Sorted by
Tagged with
5
votes
2answers
86 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
69 views

“Honeypot” code to send me forensic data when stolen files are opened

An ex-girlfriend has demonstrated an ongoing ability to acquire files from my computer. I am trying to determine when and how this is being done. One stratagem I want to use is to put "honeypot" ...
2
votes
3answers
139 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
29 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
26 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
29 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
7 views

Software for navigating native assembler code and memory hex for interpreted languages like VBA

I'm trying to understand the layout of VBA code in memory, how COM objects are structured, what VBA functions look like under the hood etc. As VBA code is interpreted not compiled, I need some kind ...
1
vote
0answers
12 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
13 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
27 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
2answers
15 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
1answer
15 views

Relating VBA to Python

I'm new to python. The last programming language learnt is VBA. I know that with python you can import libraries or module such as the requests, math, and selenium. VBA has a tool called the object ...
0
votes
1answer
161 views

Is there a VSCode extension for VBscript that can create an outline?

Visual Studio Code: There is some support for VBscript already built in. And I know there exist several extensions for VBscript that can do even better syntax highlighting, but is there one that can ...
0
votes
0answers
955 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
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 ...
-1
votes
2answers
23 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 ...