I currently have a data overview that draws data through power query from a folder in my windows computer:
However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following:
First of all, thank you for all the support I got here during my previous question. I much appreciate it.
I am still learning VBA, slowly getting the hang of it, but now I've ran across a complex problem which I have just no idea how to handle. Here is how it goes.
I have my workbook stored...
I am using Excel 2007 and Windows Vista.
I am using a set of 40 spreadsheets for tracking sporting events and sorting out the results and then the winners name and the number of competitors in each event is linked to a master tally sheet for review. I also use the master tally sheet to...
I have a summary file that contains several tabs for each supplier, and summarizes that data on the Summary tab. The data needs to be sent each month to each supplier. I have a macro that copies the data for each supplier into a separate workbook, and saves the workbook with the Supplier name...
I have the following code:
Sub DeleteFile ()
Dim TestFile As workbook
Set TestFile = ActiveWorkbook
' switch to another defined file
' do some stuff
TestFile.Close Save = False
The macro stops at the Kill TestFile line with error message: