All Questions
1,093
questions
5
votes
1
answer
1k
views
How can I reverse engineer a (deprecated) Excel V4 macro?
I have been tasked with figuring out that this does. I haven't seen this type of language/formulas before and when I browse the web for these formulas I can't seem to find any concrete definitions as ...
- 301
4
votes
3
answers
7k
views
VBA macro in Excel 2016 for Mac: SaveAs will not work with a CSV file format
I am running a VBA macro in Excel 2016 for Mac. The macro works on Windows platforms with Excel 2016, and on Mac platforms with earlier than the 2016 version. The issue appears specific to Excel 2016 ...
- 133
4
votes
2
answers
492
views
Excel VBA - Renaming named ranges causes unreadable content error?
I'm trying to teach myself VBA by completing a project, but unfortunately I've reached the limit of what I can figure out.
The project involves a workbook with worksheet intended to be used as a ...
3
votes
3
answers
64k
views
Copy and Paste row by index number in Excel Macro
I'm trying to copy an entire row by index number and paste it to another row with a different index number when a certain condition is met (I know the issue is not with the conditional logic). I'm ...
- 503
3
votes
2
answers
2k
views
Prompting a macro on close of workbook, but kill the closing if user press "No"
I am trying to execute a macro on close of a workbook.
The macro works perfectly but the problem is the closing function. I want a user to be prompted to say "Yes" or "No" when closing the workbook. ...
- 67
3
votes
2
answers
10k
views
Copy .csv files into a .xlsx workbook using python
I have done extensive researches, however have not been able to come up with the right solution for my needs.
I have python script which generates multiple .csv files.
Each .csv file only has data ...
- 33
3
votes
1
answer
2k
views
How to call a Sub from another Sub dynamically
I have never come across this idea until now, but is it possible to set another macro to a variable within my current macro to call it from the VBA code? I have made the attempt to do so in my limited ...
- 182
3
votes
1
answer
753
views
What does the FORMULA.FILL function do in Excel 4 Macros?
I'm translating some functions written in Excel 4 XLM macros into VBA. One of the functions called within the macro I'm currently translating is FORMULA.FILL. I cannot seem to find any documentation ...
- 252
3
votes
1
answer
4k
views
Run macro when linked cell changes value (Excel VBA)
I am currently trying to obtain historical information about how the backlog is developing.
My Excel file is based on queries from an Access Database which can give me a view of the current ...
3
votes
1
answer
2k
views
Dynamically add and run a vba code
The followings are my current steps
Access file exports a CSV file by Macro (VBA code)
The exported CSV file get modified by Macro (VBA code)
Right now, I'm executing the macro on Access (step 1)-> ...
- 185
3
votes
3
answers
2k
views
vba excel AdvancedFilter method for a table with dates criteria does not work
first af all i'm glad to enjoy this nice community, this is my first post so apologize me in advance for any mistake i'll do in the post.
I got a table named example generated by importing data ...
- 414
2
votes
2
answers
700
views
VBA to past certain cell values on different worksheet in predetermined columns
Gods of VBA,
I would like to request your help on some code i can't seem to get working straight.
Purpose,
When a row has a cell Value "x" on row A in sheet 'Dump', i would like to past certain ...
- 181
2
votes
1
answer
3k
views
How to identify Excel 4.0 Macro?
We were trying to Sign an Excel Macro, but got an error that it contains Excel 4.0 Macros and hence it can't proceed to sign them. MSDN says it won't allow Excel 4.0 Macro's but we couldn't find ways ...
- 1,059
2
votes
2
answers
18k
views
How to open Excel workbook without updating external data sources (but keeping it enabled)?
I have some workbooks, which starts with automatic macros and data refreshing (and, pre-empting some suggestions, these workbooks need to work like that, because I'm starting them automatically from ...
- 231
2
votes
2
answers
94
views
If 0 or "" delete row: code works but very slow
Question:
With the recorder and help on this forum I made a code (for a button). Column 'i' has got (from row 25) 'Pcs' or a number. My Macro finds Pcs and changes it to "" and than the macro deletes ...
- 65
2
votes
5
answers
2k
views
VBA Macro is running extremely slowly
I have this Macro, and finally got it figured out, but it is running very slowly, and would take about 3 days to get through my one sheet of 800 000 lines, and I have 100 sheets. I would appreciate ...
2
votes
2
answers
98
views
VBA: Fill cells based on 'random' content from column
i'll try to explain my problem.
I need to fill values based on one of four values that apears in cells (column).
I have a code
Sub testmacro()
If Sheets("List1").Range("A1") = "Keyword1" Then
...
- 91
2
votes
4
answers
5k
views
Make macro run in specific workbook
This seems like such a simple request, but I can't seem to find any answers online.
I have two open workbooks (lets say A and B). All I want to do is run a macro that I have created in Workbook B and ...
2
votes
2
answers
209
views
Save file xls in dynamic directory
I am trying to create a macro that saves the xls file in a specific directory called Months in this directory there are 12 other directories with the name of the months.
I wrote a Macro where the file ...
2
votes
2
answers
768
views
Copy cells "n" number of times. "n" is user specified
I am trying to code a macro that will look at the numerical user input in one sheet and will copy something that number of times in another sheet.
For example, I want to copy the company name and ID "...
- 137
2
votes
2
answers
3k
views
How to draw a dashed line between two cells if a condition is met in Excel
My Excel file looks like this :
How would I go about drawing a dashed red line between cell (xxxx) and cell (aaa) if a certain condition is met?
- 5,375
2
votes
1
answer
2k
views
Loop through each WS in each open WB and unprotect
I need to complete a task which involves collating data from a large amount of workbooks, I have put them all in the same folder and are all *xlsm files.
I already have a macro to grab the data from ...
- 191
2
votes
2
answers
24k
views
VBA to paste value in next empty cell
I have a VBA macro that simply copies the value from one cell (Worksheet1.a1) into another cell (Worksheet2.a1), that is triggered by a button with the assigned macro.
Sub copy_values()
...
- 701
2
votes
2
answers
154
views
Delete rows based on more than one condition
can you help me with the following code I made?
Sub DeleteRows()
Dim c As Range
Dim SrchRng
Set SrchRng = ActiveSheet.Range("A1", ActiveSheet.Range("A65536").End(xlUp))
Do
Set c = SrchRng.Find("...
- 75
2
votes
2
answers
741
views
Add Module code of BeforeDoubleClick_event to dynamically created worksheets
I have this code:
For a = 1 To 5
strFoglio = "SheetName" & a
Sheets.Add
ActiveSheet.Name = strFoglio
ActiveSheet.Move after:=Sheets(Sheets.Count)
Next a
Is there a way to write ...
- 41
2
votes
1
answer
2k
views
VBA Copy and Paste Between Template Worksheet and Variable Worksheet
I've edited this post to show that I have done some research on this. Some of the code below was captured during a "Record Macro" session. I just can't figure out how to change the workbook names that ...
- 85
2
votes
1
answer
3k
views
Find and Replace in Excel 2010 without losing cell formatting - unable to run on a cell that has 255 characters
I am using this macro in Excel 2010 to find and replace words without losing cell formatting (e.g. some words are in bold, some are in italics so this macro just makes sure the cell keeps the same ...
- 23
2
votes
1
answer
4k
views
run a macro on another workbook and then close the workbook that launched the macro
How to
1. Run macro from current (FIRST.XLSM) workbook to open another workbook(SECOND.XLSM)
2. Run Macro on (SECOND.XLSM) workbook that closes (FIRST.XLSM) and then continues its procedure
I tried ...
2
votes
2
answers
3k
views
How to Find special Characters in a column with like in excel macros
I am facing problem while searching for special characters in a column in excel vba.
I used the like operator as follows:
If Sheets("Eclipse Report").Cells(j, k).Value Like "*[%, !, *, ;, :, ~, °, ß, ...
- 23
2
votes
2
answers
2k
views
Changing colour of cells using command button (VBA Excel)
I currently have a userform that loads up with three command buttons (primary, secondary and tertiary). The idea here is that a user will select their own colour scheme using these three buttons.
I ...
- 331
2
votes
1
answer
3k
views
Count rows and filter and then delete filtered rows with VBA
Can any one tell me how to count the total number of rows in an Excel spreadsheet and then pass the value dynamically?
Instead of the value of 2691 for the last row, I want to pass lastRow variable ...
- 115
2
votes
3
answers
61
views
How to create a parameterized add-in for an excel workbook
I need to create an excel add-in that takes parameters of the upper and lower bound of two data sets. I currently have a function written that performs the correct calculation for integration using ...
- 21
2
votes
1
answer
2k
views
How to bypass "Select Data Source" Prompt For Query Tables w/ VBA
I have a macro that exports queried data from SQL into a Query Table in Excel. The whole process is done through a macro and it's been set-up an ODBC connection. Since the connections are already set-...
- 63
2
votes
2
answers
1k
views
Why does my VBA macro stop after opening and closing a few hundred CSV files?
I've written a macro that downloads zip files containing CSVs from a website. The downloading and unzipping is going perfectly, however when I try to loop through the CSVs searching for the occurrence ...
- 33
2
votes
1
answer
2k
views
Optimizing VBA / Excel Macro Code (Finding Duplicates in Large Sheet)
I haven't really ever coded in VBA or anything of the sort except short little things in VB done years ago. This is my attempt at writing some code that will search through a excel sheet database of ...
- 117
2
votes
1
answer
11k
views
Error 450: Wrong number of arguments or invalid property assignment on vba
Im writing an excel sheet for work that when I press a button a loop runs through some rows and will edit some data if they're empty but I cant seem to get the macro to run as it keeps returning the ...
2
votes
1
answer
597
views
I Need a Excel VBA code for to copy paste a range of cell
To be short and sweet with my requirement, I need a code to do the conditions below.
Select from range A2:G5
Then check if a sheet named with current date i:e 29-02-2016
If yes,
then copy paste ...
- 21
2
votes
1
answer
2k
views
Adding file date created to list
I've been trying to edit a bit of code which gives a list of all files in all subfolders to also give me the date created in the next column but am unsure how. Here is the code i'm working with: It ...
- 600
2
votes
1
answer
389
views
Excel Macro 4.0 event handling
Following these steps, you can create an Excel 4.0 macro within a workbook:
Right click on a sheet/tab (e.g. Sheet1) at the bottom of the Excel workbook.
Click Insert....
Select MS Excel 4.0 Macro ...
- 21
2
votes
1
answer
1k
views
How to handle missing xml node in excel macro
I am using ms excel for macro written in vb. I am reading xml file, looping through and few nodes as missing. see the xml example below :
<document>
<element>
<fname></...
- 123
2
votes
1
answer
21k
views
VBA Run Time Error 1004 AutoFilter method of Range class Failed
I hope you can help. I am getting the error Run Time Error 1004 AutoFilter method of Range class Failed
When I run my code Public Sub TestThis(), the funny thing is It works perfectly by itself, but ...
- 651
2
votes
3
answers
381
views
First Available Cell in Column within Excel Macro
I am creating a macro to take an entry and put it on the first available line. this is what I have so far. It doesn't work, but what I am trying to do is to use the Range function to select the ...
- 23
2
votes
1
answer
2k
views
Possible bug? xlwings cannot run an Excel macro? [duplicate]
I am having a problem getting xlwings to run a macro from Python. Despite following the code from xlwings documentation, I cannot get xlwings to execute an Excel macro. For instance, in Excel workbook ...
- 859
2
votes
2
answers
1k
views
Excel VBA: How to Loop Through Workbooks in Same Folder using Given Code?
(Previous Post)
I need to create a macro that loops through the files that are in a single folder and runs the code that I have provided below. All the files are structured the same way however, ...
- 47
2
votes
1
answer
218
views
Share macros modules between excel and word
Over the last two years I have written several macros for excel and word and saving them in normal.dotm and personal.xlsm. I have some modules that handles filereading,database interactions, html ...
- 856
2
votes
1
answer
8k
views
Excel Macro to copy row of data to bottom row
Good day,
I am trying to create a macro that copies data from the current month row to the bottom. The current month row is refreshed and the date will change for a new month (sep--16), but before it ...
- 133
2
votes
2
answers
3k
views
VBA to find text from webpages
I have created Macro which gives me all URLs present on any webpages.
We just need to provide the URL and it gives us the all links present in that webpage and paste it in one column
Private Sub ...
2
votes
1
answer
2k
views
Excel Interop C# Can't add VBProject Error 800A03EC on Workbook.VBProject.VBComponents.Add(..)
I) Global Explanation
Hello,
I'm developing an app in C# using Microsoft.Office.Interop.Excel. In my case I implement some olds macros stored in a file to an Excel Workbook, opened by C#, to upgrade ...
- 41
2
votes
1
answer
2k
views
How to debug a Pivot Chart Macro?
I am not able to run this, I want to count total rows in sheet and pass that to pivot chart to create.
Pivot chart create
select fileds
Double click grand total to create new spread sheet
Sub Macro2(...
- 115
2
votes
2
answers
2k
views
vba Get Cube update time with formula Need to delay macro execution
I have a cube connected to Pivots in excel.
In one cell i display the "latest updated" value by this formula:
=CUBEVALUE("CUBE NAME";"[Measures].[Last Data Update]")
It takes 5-10 seconds for excel ...
