2,449 reputation
1819
bio website awmisfits.com
location Texas
age 47
visits member for 2 years, 7 months
seen Dec 20 at 14:48

Afterworld player, and forecasting/VBA/excel/access to support the habit :)


Oct
30
comment Microsoft Excel 2010 subtraction results in wrong answer
stackoverflow.com/tags/rounding-error/info
Oct
30
comment Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table
stackoverflow.com/questions/16742454/… may give you some ideas
Oct
28
comment excel sql server error: Invalid object name
@FrankThomas, added code. I do not have access to view or edit the function itself, but I added the code and connection information
Oct
28
revised excel sql server error: Invalid object name
added code from actual function
Oct
24
comment excel sql server error: Invalid object name
the function works correctly in SQL Server, but if I put it into an excel data connection, I get the error. The manipulation is actually taking a time field, and rounding down to the nearest half hour
Oct
24
comment excel sql server error: Invalid object name
@FrankThomas, can I set no count from an excel data connection? The naming of the column is only for readability, but removing it has no effect on the response from excel
Oct
24
asked excel sql server error: Invalid object name
Oct
8
revised Can I delete empty recovery partition (Win8)
added picture inline, instead of external link
Oct
8
revised Old MsWord file opening with junk characters
removed spam tag
Oct
1
comment Link Excel workbooks so that I can use them on another computer (Excel 2011 for Mac)
excel stores relative links only when the path is on the same drive. see this for further info
Oct
1
comment Alphanumeric cell format (using custom format)
A shortcut to make a 5 character zero padded string would be right("00000" & splitstring(1),5) - no loops or extra variables needed. Your entire string construct would be splitstring(0) & "\" & Right("00000" & splitstring(1), 5) & "\" & Right("00000" & splitstring(2), 5)
Oct
1
comment Avoid horizontal scrolling on websites
squarefree.com/bookmarklets/zap.html#force_wrap may help - it's an old site, so Chrome is not listed, but many of these bookmarklets work in (almost) all browsers
Sep
25
comment Check if path to file is correct on Excel Column
sneaky trick to remove reliance on the default of the boolean variable: FileExist=Len(Dir(path))>0
Sep
25
answered Replace Pivot Table row names
Sep
25
answered How to sort only part of multiple columns in Excel
Sep
25
comment Is there a keyboard shortcut to turn a tab-delimited recordset into a table?
are any of the letters underlined in the menu selections? if so, you can use ALT+UnderlinedLetter to select those specific items
Sep
24
comment Formula to add minutes to date+time in Excel
the reason the TIME formula does not work is: The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99999999 [which means that after 24 hours have been added, it wraps around again - see what happens if you add 1440 minutes using this method]
Sep
24
answered Is it possible to log out of Chrome using the command line?
Sep
23
answered How do I seed another data table's records with category information in another Excel data table?
Sep
18
answered Can I use an IF statement as a parameter in a COUNTIF function?