Export2CSV

Exports a sheet into CSV file
Dynamically finds number of rows/columns and export as they are, starting from A1.
Forcing each column to be exported as the format found in its row 2, meaning, if a cell has 0.35444 and displayed as 35%, it will be forced to ba saved as 35% in CSV.
Can pass sheet, workbook and file names as parameters as well as SaveMethod.
Edit 2024-12-04: Fixing the call to Active sheet in WB workbook

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydevlib.com

Linkedin Login

CSVFullFileName, Optional Shee = "Active", Optional Wb = "This", Optional StartCell = "A1", Optional SaveOver = 1, Optional SaveMethod = 1

Views 280

Downloads 78

CodeID
DB ID

ANmarAmdeen
710
Attachments
Revisions

v2.0

Wednesday
December
4
2024