Search results 83

Sorted from new to old.

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

GoToInternet

Opens webpage from within Excel, using default browser

2018May22

LogoutALL

Logs out Linkedin by running two commands One will open new window to logout ...

2018Apr23

ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my tools, very ...

2018Apr21

Paging with Alternating Colors

This script will take the results of a query and sets up number of records per ...

2018Apr18

1 2 ...5 6