How can I automatically execute an Excel macro each time a value in a particular cell changes? Right now, my working code is: Private Sub Worksheet_Change(ByVal Target As Range) If …

VBA will allow you to adhoc use variables, but its difficult to maintain if you do that. Add to the beginning of your code, right after version dim URL as string dim objHTTP as object

In most of the online resource I can find usually show me how to retrieve this information in VBA. Is there any direct way to get this information in a cell? For example as simple as …

Since most of the contents are repetitive in that file, only the hex values are changing, I want to make it a tool generated file. I want to write the c codes which are going to be printed in that …

How do I declare a global variable in VBA? Asked 15 years, 7 months ago Modified 4 years, 3 months ago Viewed 1.2m times

I'm trying to open an Excel file from SharePoint using VBA. Because the file I'm looking for might be different each time I run the macro, I want to be able to view the SharePoint folder and …

I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date. I keep trying the the following ActiveWorkbook.SaveAs …

Sub test() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Sheet1") Dim k As Long k = sh.Range("A1", sh.Range("A1").End(xlDown)).Rows.Count End Sub What happens is this: We …

Looks like you might have an issue supplying a name to the table that is a fixed value. You are calling it PivotTable6 but that name is only available the first time you create the pivot. After …

In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?" Application.DisplayAlerts = False Set xls = CreateObject("Excel.Application") Set wb = …