filesize

Context: I'm updating a report for someone that is currently 145KB in size. I suggested doing various changes including the introduction of VBA to automate some of the manual tasks. Currently, the file size now after my adjustments is 800KB. They're worried about file size but I don't think...

Hi. I have written the below code and I need help please someone can assist in how I can list of all files in a given folder which are more than 50KB in size . Option Explicit Sub Run_Tool() ' ' Run_Tool Macro ' ' Sheets("File_n_Size").Select Columns("A:AQ").Select Selection.Delete...

Is there a vba macro that will delete all empty rows of a worksheet? I'm seeing my workbook sizes growing exponentially but when looking at the rows/columns that contain data, it showing the last row 2500, last column G. I wouldn't think that the workbook size should contain 1048576 rows and...

I have some coding (from http://www.mrexcel.com/forum/excel-questions/471508-list-properties-all-files-folder.html ) to get filesize. Public Function FileSize() Dim FSO As Object Set FSO = CreateObject("scripting.filesystemobject") FileSize = FSO.FileSize("C:\Windows\Windows.exe") End Function...

I have a 2010 Excel file with three tabs, one that only has any data on it... and it only has 26 rows and 34 columns that have any data??? the file size is 5.2MB??? same file saved as 97-2003 is more than half the file size smaller at 2.1MB??? Can anyone help! Thanks, Sybo2

I am using an excel 2007 workbook as a basic form that returns lookup data from another workbook. Both files reside in sharepoint 2007 document libraries. I'm using a simple VLOOKUP function and the values are being returned just fine - my problem is that including these formulae makes the...

Hi, I've been given a 300MB spreadsheet and asked why is it so large? Where do I start? Any help would be appreciated.