133 questions
0
votes
1
answer
126
views
VBA PowerQuery Directory
I am using VBA to try and hopefully automate my PowerQuery needs.
I've recorded a macro from the import data from PDF in the data tab.
I have then tried creating a user definable source path within ...
- 13
2
votes
1
answer
218
views
TextJoin Function could not merge more than 142 columns/cells
I want to merge cells/particular columns from one row till next non-empty cell in row-3. But i got #CALC! error. Is there any solution to this. Getting same error in CONCAT function. Below is my code, ...
0
votes
3
answers
206
views
want to split data depends on multiple columns
I want to split data on basis of A & B-column, if next row is same from A-column then look into B-column. if next row is same from B then copy F, G H-column till value from B is unchanged. Its ...
1
vote
1
answer
64
views
Error when creating additional fields during data upload (Excel to Access)
I am using this code to copy the data from excel sheets to access db.
For each table i am creating additional 2 columns to hold the excel file name (Data.xlsx) and run date.
I am getting "ByRef ...
- 31
0
votes
0
answers
95
views
Delphi 10.4 Initiated VBA code - not able to debug - fails with Out of memory
I have recently upgraded my application from Delphi 7 to Delphi 10.4. My application launches VBA 6.5, which kind of is hosted within Delphi (i.e. it vanishes along with the main application).
I am ...
- 33
0
votes
0
answers
45
views
Where to place procedures/sub in VBA between classes, modules and User Forms?
I have a project with classes, modules and user forms and I need to know how to structure it and put what functions/subs where, so it runs.
I have a 3rd party library installed in VBA that allows me ...
0
votes
0
answers
80
views
Unstable listbox with vba hiding/unhiding Excel worksheet rows
I have created a userform for inputting and updating records for a worksheet with 108 rows and some 80 columns. Rows 4-108 and columns 1-7 are contained within the named range, 'tblDiners'. The lower ...
1
vote
1
answer
44
views
Microsoft Excel 365 VBA - Inserting Image into Table via UserForm
Private Sub CommandButton1_Click()
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.ButtonName = "Submit"
.Title = "Select an ...
- 13
0
votes
0
answers
73
views
Error 70 permission denied when adding or deleting a file
I have a client. The code worked perfectly for years. But suddenly this error pops up on his and all of his coworkers' computers. Yet, when I run the same code on my own computer, I encounter no ...
- 101
0
votes
0
answers
92
views
Prevent Excel from crashing when creating multiple pdf's
I have a large Excel sheet where I use vba code via a simple do loop to generate a number of pdfs from a given worksheet. The sheet is used for invoicing and the worksheet where the invoice amounts ...
- 1
0
votes
1
answer
86
views
UserForm_Initialize not processing as expected, etc
Apologies if I've not posted this correctly. I don't yet know how to put vba coding into its own window.
I’ve been relearning to use excel and vba try to automate an excel monthly meal plan for a ...
0
votes
1
answer
68
views
VBA : Request Payload as nested dictionary
I used to scrape data from www.niftyindices.com with following code in VBA.
However, they have changed the Requestpayload to nested dictionary:
{"cinfo":"{'name':'NIFTY 50','startDate':'...
- 15
0
votes
1
answer
326
views
Update connections and queries with a button using VBA Excel Macros
I have many workbooks with many pivot tables and many connections on different sheets. What I'm trying to do is update the pivot tables and external connections separately. For this I already got a ...
0
votes
1
answer
157
views
Put attributes in the XML file using VBA
How do I put the attributes below that are in the node envideclaracaoautodesembaraco in my vba code. I want my .xml file to generate the same attributes as the example below.
<...
0
votes
1
answer
86
views
Adjust export script (excel->XML) to combine nodes under parent
How do I export my xml file as per the example using the data generated from Excel below:
[sample input data](https://i.sstatic.net/hz68v.png)enter image description here
Below is my xml of data ...
0
votes
1
answer
86
views
Create an XML file using spreadsheet data with Visual Basic
The VBA codes generate an xml file as per the model below:
<Produtos xmlns="http://www.test.com/engine/3">
<Item_1>
<UF xmlns="" yid="1">AM</UF&...
1
vote
1
answer
169
views
Archiving folders that contain subfolders with files that are past a certain date
I am creating a macro that functions as an archiving tool. Basically, the tool has to archive folders that contain subfolders that contain files that meet certain archiving criteria (ex. archive ...
- 11
0
votes
1
answer
87
views
How to evaluate this function in VBA?
I am trying to use the below Excel formula in my VBA code but can't get it to work:
=Rows(Unique(Filter(myRange, myRange))
This function works as expected in Excel, and the range I am using is a ...
0
votes
1
answer
523
views
How to create a Deepl Glossary CSV separated from a Excel selection using API with VBA
I have the following code which is executed from a Excel From, which also containing the variables.
This code works for CSV format, but I cannot get it to work for CSV.
DEEPL support mention this.
In ...
- 1
1
vote
3
answers
3k
views
VBA Excel Sumif and sumifs function
Sales Details
Month
Amount
January
120
March
250
April
380
June
510
January
640
March
770
April
900
June
1030
January
1160
March
1290
April
1420
January
1550
Noted: all vba code write below.........
...
0
votes
0
answers
247
views
Automate Updating Text boxes in PP with Excel data
This VBA code, titled "UpdateTextboxesFromExcel," is designed to interact with both Microsoft Excel and PowerPoint to read a specific cell value from an Excel workbook and update a textbox ...
0
votes
1
answer
130
views
Update the file paths dynamically in network drives using Word VBA
I'm trying to create an Excel object in Word which reflects live update of data from Excel.
My use case is to update the object path dynamically when two files, Word and Excel are being sent to ...
0
votes
2
answers
90
views
Automate creating new PP/Excel sheets and updating the links
I'm having troubles with a VBA code I have written which is designed to do the below:
Define File Paths:
The macro begins by defining several string variables for file paths: originalPptPath, ...
-1
votes
3
answers
450
views
Is there a vba code that can parse out specific data from a single cell that has multiple paragraphs in excel?
I am in need of some help please. I have found multiple vba codes that can help with pulling certain characters in a cell, but the trouble I am having is that a single cell has multiple paragraphs ...
- 1
0
votes
0
answers
77
views
There is an error on line 12 of custom code BC30205 End of statement expected using rdl VBA
I am working on an application I am facing an issue below is the error and the code
[rsCompilerErrorInCode] There is an error on line 12 of custom code: [BC30205] End of statement expected using rdl ...
- 1,111
0
votes
1
answer
65
views
VBA Subroutine Does Not Retain Bookmarks in Word
I generated the VBA code below in order to populate a large Word template document from Excel. My goal is to update a bookmark and then the associated cross references to that bookmark to update as ...
1
vote
1
answer
571
views
How to filter tasks in MS Project, using VBA, and with multiple conditions?
I have a line of VBA code that creates a filter with one condition, this works well:
FilterEdit Name:="temp", TaskFilter:=True, Create:=True, OverwriteExisting:=True, FieldName:="...
- 13
0
votes
1
answer
93
views
Copy List of Tables from Excel to Word
I am trying to copy list of Tables in a single sheet to Word.
The tables are pasted in the beginning of document.
Is there any way to paste at bookmarks?
Also can the code contain manner to format ...
0
votes
0
answers
41
views
VBA how to include the Last Row as part of the range? [duplicate]
Sorry am still new in VBA and find it confusing. I need to include the last row as part of my range but somehow finds error in it. (see: "Error in this line")
Sub Clear()
Dim r1 as Range
...
0
votes
2
answers
59
views
Copy specific rows based on text in a specific column to a different sheet
I am currently tryinig to hardcopy data from one sheet1 (Output for Exact) to a different sheet2 (Hard Output Accruals). Column I in both sheets provides a description that can be either Mark-up or ...
0
votes
1
answer
219
views
Excel: Running a macro in one sheet causes all references from different sheets to this worksheet to lose their reference and return a #REF
I am currently working with multiple macros in my reporting model. The problem I encounter is the following:
The first macro that I use, copies all data in worksheet A (data is based on formula's from ...
0
votes
0
answers
37
views
How select a variable range to paste in VBA when there are blank cells in between [duplicate]
I want to paste a formula of VLOOKUP in my whole column but the last cell changes everyday. How to select the variable last cell of Column "S" according to the last cell in column "A&...
0
votes
0
answers
74
views
VBA copies only first row to text file
I am looking to copy non-blank column data into a text file, while the copy is successful, the paste part of the vba copies only first row to the text file. Below are the issues
1.Though copy of the ...
- 87
0
votes
1
answer
50
views
VBA Excel - Delete the repeated values and rearrange non-repeated data line wise
I am trying to organize the set of data starts from A17 to C30
A18 (Doc. No.)
B18 (Doc. Title)
C18 (Revision)
Monday
Red
R1
Monday
Red
R1
Monday
Red
R1
Monday
Yellow
R1
Tuesday
Blue
R2
Wednesday
White
...
- 77
0
votes
1
answer
737
views
Excel VBA Print to PDF - with cell reference file name and folder path
I am trying the save/print excel report 30 pages to PDF.
file and folder path set to the cell reference.
I tried with the below code, Please help me to clear the issue at the end.
RUN TIME ERROR '1004'...
- 77
1
vote
1
answer
491
views
How can I create functional internal links when converting an Excel document to a PDF? Link to Place in this document
I'm seeking guidance on how to create and maintain functional internal links when converting an Excel document to a PDF. These internal links are crucial for navigation within the document.
I've ...
- 77
1
vote
2
answers
65
views
Collect column range value combined in one cell followed by comma and end with & seperator
I am trying to get the collect combined value in one cell followed by comma and end with &
Column range : AM4:AM20 may be with value or blank.
I need to collect this value combined together with ...
- 77
0
votes
0
answers
282
views
Creating Datum Target using Catia VBA
I have a question on Drafting side of Catia, I am trying to record creating a datum Target on a view in a drawing. But the recording is unfruitful. I also looked into the documentation and searched ...
- 9
0
votes
1
answer
272
views
Passing Power Query M through VBA
I need to pass the following Power Query M through my VBA Script:
let Source = Excel.CurrentWorkbook(){[Name="C192767TO15_D3"]}[Content],
#"Changed Type" = Table....
0
votes
1
answer
471
views
Excel VBA With Pivot Table From Data Model
I make a query with connections in data model then i make some measures and make some pivot table to excel sheet with filter field.
now i want to connect my pivot tables with VBA to clear or select ...
0
votes
1
answer
58
views
Have a newly created template sheet with table automatically append mater table. Building a fully automated template, hung up on the PowerQuery
The Project Premise:
Creating a invoice tracking template that automatically appends a table on the newly created invoice worksheet to an existing table on the Master Worksheet.
The process will work ...
0
votes
1
answer
75
views
Locking the Textbox Position To Be the Same While Update
I am creating a calendar feature in Excel that takes inputs from a form and based on that I will put the job details into the dynamic calendar. The problem I'm facing now is that whenever I'm updating ...
0
votes
1
answer
109
views
Putting a textbox directly below another textbox in the same cell in Excel VBA
I am creating a calendar feature which takes inputs from a form and based off that I will assign into a dynamic calendar.
The problem is that my third textbox and subsequent textbox will not be ...
0
votes
1
answer
86
views
Implementing User-Defined Function (UDF) with IF equations
I'm working on a function that uses different formulas based on the DOH of a specific Person in different groups. Some groups may use different formulas depending on the status (if it's active or non-...
- 1
0
votes
1
answer
101
views
Output formula results based on a word in a specific column and row
I'm building a function that uses different formulas based on the DOH of a specific Person in different groups. Some groups may use different formulas depending on the status (if it's active or non-...
- 1
0
votes
1
answer
1k
views
How do I Unzip a 7z zip file using VBA
I have a 7z .zip file I am trying to unzip with VBA. I have attempted several methods but to no avail.
See below the zip file type just to be sure where the problem could be from:
Image of 7z file
I ...
- 3
0
votes
1
answer
58
views
Doesn't show the value on the sheet
The code have to do this: Open the external file to push the information, if the id is the same at the other sheet they copy the value of the two columns and paste on the column on the sheet "...
0
votes
1
answer
70
views
The code is not extracting the complete specification part
I tried to extract the specification part for a few URLs, "Example Link - https://in.rsdelivers.com/product/3m/3400961/fall-arrest-fall-recovery-kit-3m-3400961/1965607", However, using the ...
- 47
1
vote
1
answer
103
views
GET value from web table
based this code i need to get also the link value from each row in table.
Actually i get only PR and PROVINCIA
reference link: https://www.comuniecitta.it/sigle-province-italiane
for example of first ...
- 91
0
votes
2
answers
148
views
Drop All Relationships and relAttributes
I'm trying to repair some relationships in a database. I created an xml copy of a backup DB.
Do I need to drop all existing relationships first?
I tried DropRelationships from Importing/Exporting ...
- 1