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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
ZIPPING A FILE FROM SAS
Hi, I am producing a huge number of big files exported to different file types (mainly xls or CSV) and I was wondering if there is any way to produce these files already zipped directly from SAS instead of having to go and zip one by one (they go to different places so it is not zipping all in...- depacho
- Thread
- Replies: 2
- Forum: SAS Institute, Inc. solutions
-
UNHIDE an Excel workbook
Thank you PH, It worked perfectly. You always so helpfull.- depacho
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
UNHIDE an Excel workbook
Hi I have the following code: Dim objXLApp As Excel.Application Dim objXLBook As Excel.workbook Dim objXLSheet As Excel.worksheet Dim sHeader, sFooter, sDay As String Set objXLBook = GetObject(sFilePath & sTableName) Set objXLApp = objXLBook.Parent Set objXLSheet =...- depacho
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Blank Excel spreedshet after modifying it.
Thank you PHV, you always prompt to answer questions. I tried this but it didn't work, but I found what is the problem. For some reason it HIDES the spreadsheet. a tried hide= False attribute but it says that this is not an attribute. Any ideas? Thank you again.- depacho
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Blank Excel spreedshet after modifying it.
Hi All, I have the following code. It is something that I have used many times and this time when I try to open the excel file, excel opens but I do not get anything (not even a blank new spreadsheet), can any one help me? Thank you. Dim objXLApp As Excel.Application Dim objXLBook As...- depacho
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
