sline

Hello, I have this VBA code below, but the output text file has a lot of commas in it. Note that i have hidden formulas in my excel file. Most likely this is the reason. Is there a way, then when i generate the text file it will only get the rows which has data. 'Declaring the variables Dim...

I found this code bit searching google and it does exactly what I need after a few changes. I would like to change it to run silent (No command window) but can't figure out how. down vote Based on Andrew Lessard's answer, here's a function to run a command and return the output as a string -...

I can generate a list of UDF with the following macro, but I'd like to put the args needed next to them. You can manually get a UDF args by pressing CTRL+SHIFT+A so there must be a way to do it programmically. Anyone? Sub ListProcedures() Dim sProc() As String Dim lngLine As Long Dim...