run

I have an extensive macro that builds a database from a number of daily files but it requires me to type a negative number into cell C23 and then I must click a button to run my macro. These negative numbers represent each past day eg. -2 produces the info for the day before yesterday and -365...

My database is 4 million records and when I import the new data every week it's a mess because the source people are idiots. SOOOO, I created a long list of update queries that find the things that should not be there and eliminates them. Each query takes about 90 seconds to run - there are...

Hello, I have been working on automating a spreadsheet that contains a Regression Analysis. I have ran through it numerous times and it works just fine. However, when I send it to a coworker she gets an error saying "Run time error. Cannot run macro." She has macros enabled, but for whatever...

Hi everyone, Sorry, with vbna I am only at the search for what I want, find what I can alter and put the pieces together stage of vba i.e. quite a novice. Your help is MUCH appreciated as I am using excel to automatically update a form with every change of lesson to give links focus and time...

Hey guys, I have a project that I'm making and it contains 3 arrays. Once i run the macro, all the actions are done, but the array is not erased, if i re-run the macro the values inside keep doubling(keeps old values and adds them again). I am using erase at the end of the last sub now to make...

hi guys, i have an issue where the following index letter $E7$:$E$100000 changes whenever i enter a call to refrence sheet "Raw Data for PR Dist" =IF(INDEX('Raw Data for PR Dist'!$E$7:$E$100000,MATCH(1,(A3='Raw Data for PR Dist'!$A$7:$A$100000)*(B3='Raw Data for PR...

Dear all, i noticed suddenly that my VBA is taking so much time to run the VBA, i dont know why for example to filter and unfilter an entire row it starts from Threadh (0%) and takes 5 minutes to reach Threads ( 100% ) that's only to filter and unfilter one row !!!! can someone please help :( ?

Hi, When copy the following direct into excel i dont get any errors, works perfectly but if i put it into a module and run it, i get syntax error... =average(INDIRECT($A2&"!a:a"))*SUM(INDIRECT($A2&"!B:B"))+1 But VBA it doesnt not allow me, what am i doing wrong? Range("E2").Formula =...

Hi to everyone, kindly require to provide me a VBA code so that to run a code from another folder/file. The bath of the code is follow: w:\accoffice\inv.people\VBAacc.xlsm.personal.XLSB!moduleacc Please note without opening the file It would much appreciate any support. Thank you in advance

works fine on my pc but when the macro is run on a mac you a print error - and i'm only trying to save it. any ideas?

how can i list all the subs in my project into a listbox and then run the subs from the listbox?

I've managed to save an active worksheet as a pdf using the following: Sub save_as_pdf() Dim Path As String Dim filename As String Path = Range("B35") filename = Range("B36") ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, filename:=Path & filename & ".pdf", Quality:=xlQualityStandard...

I'm getting a compile/syntax error when i try to run this macro. Can you see what i've done wrong please? Sub filename_cellvalue() Dim Path As String Dim filename As String filename = Range("B31") ActiveWorkbook.SaveAs Filename:=filename, FileFormat:=xlOpenXMLWorkbookMacroEnabled End Sub The...

Hi - I don't have any code for this because i'm not sure where to start. On Workbook1.Sheet1 is a lot of data from column A:O. Workbook2 has sheets with names that correspond to column O on Workbook1.Sheet1. I would like to put the date the procedure is run in column A of each corresponding...

Good Morning I have a file open we will call this file 1 I want to run a macro from another file and we will call this file 2 when i run the macro will it do the instructions i have set on file 1 or file 2 Hope anyone can help Cheers Steve

Hi, Strange issue. I have a workbook that was working fine this morning. Now when I try to open it Excel looks like its loading the file, then disappears. It doesn't give any sort of error, it just completely closes as if I'd never tried to open it. If I open it in safe mode it will open but...

Hi All, I am having trouble getting this to work. I am close, but probably missing something. I am trying to play a wav file when the active cell is U18. When the user selects this cell, I want the audio file to play. When I use the code below, it works when I have the cell selected and run the...

Hello All, Greetings for the day! I'm having a VBA script which works absolutely fine when run manually. However when I tried to run it through windows Task Scheduler, few codes of this script not executing and hence not giving desired result. Any idea for this paradox? If required, I can post...

I have encountered a very usual error that I have tried to resolve for several hours with no luck. The code involved is spread over several procedures, so I don't think it would help to include it here. As an overview, my code does the following: Prompts the user to open another workbook...

I was wondering if anybody can tell me how to exclude a specific value from a filter after I run my macro. I have the code at the end so it runs last however I am needing to always exclude 0 and #N/A from the output. I cannot tell it what values to include because they change with every run of...