Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by teethofgold
-
PDF Automation
I need to automate the PDF'ing of a batch of Excel spreadsheets. A VBA solultion would be ideal. Any ideas? Thanks!- teethofgold
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
GROUP BY using Excel Worksheets
I suggest using a pivot table.- teethofgold
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Essbase Options Excel VBA woes...
Here's a better code sample... Private Sub retrieve_range(ByVal range_indx) 'the retrieve ranges are stored in records like this 'Type essbase_range_record ' sheet_name As String ' essbase_range As String ' password As String 'End Type 'the essbase options are stored in this public...- teethofgold
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Essbase Options Excel VBA woes...
So... I use the following code... ActiveWorkbook.ActiveSheet.Names("EssOptions").RefersTo = "A6100000000021000000001100020_01000" ... to set the options on Essbase retrieve pages... thus preventing the dreaded effect of retrieving and eliminating missing and zero rows... thus f&%king up your...- teethofgold
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
