When you add a new sheet to the workbook object, that becomes the activesheet, so you can address it so xlApp.xlWB.Activesheet From:xldbob
Hi Gary, I recommend that you NEVER rely on Excel’s ActiveXxxxx objects when automating. These objects (along with Application.Selection) are designed tograhammandeno
Sorry about that, I missed the show history button. I think I have it switching to the new sheet successfully. Next question, is it possible to set the cellg_w_hamon
Please Note: New Members will have their posts moderated for a period of time so we can be sure you are a real member and not a spammer. Sorry for the inconvenience.
Please Note: We do not allow job postings or recruiting at this site. Doing so will only get you banned.
Whether you are seeking help in database design, user interface, complex MS Access VBA code, MS SQL Server, we can help.
Our membership includes several MS Access MVPs and questions are answered quickly and accurately! Our Archive contains many sample databases, Utilities, Add-ins, code samples and more.
Share your knowledge and it will come back to you ten-fold!
For more accurate answers, please indicate which software version you are using when asking a question.
- Microsoft Access
- Mar 28, 2002
- This is a restricted group.
- Attachments are not permitted.
- Members can hide email address.
- Listed in Yahoo Groups directory.
- Membership requires approval.
- Messages from new members require approval.
- All members can post messages.