Search results 52

Sorted from new to old.

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

Bootstrap IE issue

Looks like IE has some issues in bootstrap 3, this is the solution, please ...

2019Jan11

CTRL+K,C

Comment and de-comment lines quickly in VBE Create shortcuts inside VBE to ...

2019Jan5

Bootstrap table by wenzhixin

Working jquery bootstrap table, with pagination, search, sort and column ...

2018Dec29

Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

2018Sep26

Arabic SQL+ASP

Enable Arabic in MSSQL DB, the correct way, as of Sep 2018 Tested in Alwah and ...

2018Sep24

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

2018Aug25

IsThere1_Folder

Checks if a folder is found or not, can pass either mapped path or unmapped ...

2018Aug10

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

Textbox focus issue fix

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jul29

CutString1

Cuts a string from a string starting from a specific character index and until ...

2018Jul11

Import_CSV

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

2018Jul7

Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

1 2 3 4