Search results 485

  2. Search results
  3. q
Sorted from new to old.
Card image
Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20
Card image
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3
Card image
Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1
Card image
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28
Card image
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14
Card image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10
Card image
Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7
Card image
Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5
Card image
Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3
Card image
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25
Card image
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19
Card image
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10
Card image
DB connection driver

What is the Driver part in ConnectionString

2023Jun2
Card image
Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25
Card image
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23
Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11
12...5...3031