Running VBS to extract data

**badmullah** · 02-27-2021, 04:06 AM

I have a main XLS sheet that I run a VB script and that would produce me a CSV file that is fed into a BI report to show some visualizations.

Question is, How do I make running these VBS scripts automated so when I modify the main sheet, these VBS scripts would automatically run and have my BI report show the latest updates at the next refresh?

Thanks

**6StringJazzer** · 02-27-2021, 09:09 AM

Do you mean VBA?

In the code module for the main sheet, use the Worksheet_Change which will run anytime there is a change to the sheet.

Running VBS to extract data

LinkBack

Thread Tools

Rate This Thread

Display

Running VBS to extract data

Re: Running VBS to extract data

Thread Information

Users Browsing this Thread

Similar Threads

VBA to extract zip file attachments AND extract time stamp data from .msg file

[SOLVED] vba code to extract data from data table and update data sheet

[SOLVED] Extract Data /Look up Data / To get data automatically by refering invoice number

code works running in visual basic editor but not when running from Excel macro

Extract certain entries and returns value to a new worksheet with running balance

extract data based on four criteria in excel sheet or VBA code to extract

Extract all data to new workbook then filter and extract to new worksheets

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions