![]() What are you doing with the data.zip "exe" file? zipping large CSV data source files to reduce size and improve portability. The new version of the C:\Reports\Pivot_Source_Data\Data.CSV is now on the business users computer and they can then refresh the Excel pivot table report. WinZip then executes, unzips the CSV file and saves it to the business users computer folder named C:\Reports\Pivot_Source_Data\ Winzip runs and saves extracted file to C:\Reports\Pivot_Source_Data\ What I am looking for is the VB code for the business user click a Macro button in the business report to run the \\Server\Reports\Pivot_Data_Source\DATA.exe. The CSV files sizes are huge (500K to 1 million rows of data) so they are zipped for faster download.ī. The CSV Files are refreshed each week with new data. CSV data source file that will be used in Excel Pivot tables by business customers. This DATA.exe 'package' contains a zipped. I create a WinZip Self-Extractor (DATA.exe) and save it to our company server location of \\ Server\Reports\Pivot_Data_Source\DATA.exe. Also curious, what are specifically happening in a. Curious why Winzip? - This is a company standardĢ. MsgBox "Pivot source data refresh process complete."ġ. ReturnValue = URLDownloadToFile(0, strUrl, strSavePath, 0, 0)Īpplication.StatusBar = "Refresh Process completed" StrSavePath = "C:\Reports\Pivot_Source_Data\Data.csv" ' Code below provided from Excel VBA User Forum (Mav55th)Īpplication.StatusBar = "CSV data source file being copied from SharePoint, please be patient" I just need to figure out how to adjust it to address the ZIP executable (Data.EXE) question above: Here is the VB code that does work beautifully for downloading files from an URL that was provided by Mav55th on this forum. Winzip runs and saves extracted file to C:\Reports\Pivot_Source_Data\ Data.ZIP exe file on \\Server\Reports\Pivot_Data_Source\ī. here is a text staw dog of the VB code I require.Ī. ![]() I need to tweak an Macro (currently downloadsa CSV file type from the internet) in an excel workbook to trigger a WinZip Self-Extractor (.exe) located on a server that will run and copy a CSV data source file to a users hard drive. I have been working (searching the web) on this in chunks for a couple of days and I am stumped. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |