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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: commandchief
- Content: Threads
- Order by date
-
Formatting Excel 2007 worksheets within Acess using VBA
I had the function below working in AccessXP but it no longer works in Access 2007. I get an error that says it can't create object. Any suggestions?? Function fixXLS(mySheetPath) Set Xl = CreateObject("Excel.application") Set Xlbook = GetObject(mySheetPath) Xl.Visible =...- commandchief
- Thread
- Replies: 20
- Forum: Microsoft: Access Modules (VBA Coding)
-
Send Object in Access
When I am sending a query object in an e-mail in Excel format, the data resulting Excel file appears to be in reverse video. I have to open each file and change the font color so it's readable. I'm not sure when this happened but it only affected the queries I created during a certain time...- commandchief
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
