\r\n\r\n
Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > Activate sheets and cells in separate workbook


\r\n \r\n
 
 
Thread Tools Display Modes

\r\n\r\n\r\n
Hi
\r\n
\r\nI have two seperate workbooks in Excel - one with my command buttons and user forms, and the other to store the data entered. I need some code for a command button on the first workbook where the user forms are stored that will open the second workbook where the data is stored, activate a particular sheet within the data workbook and find the first empty row within the sheet, and then I need that sheet to be viewable to the user. I\'ve tried all sorts of different combinations, and either the sheet isn\'t viewable to the user, or the sheet isn\'t activated properly. Help Please.
\r\n \r\n\r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n'; // next/previous post info pn[1384107] = "1384107,1384107"; pn[0] = ",1384107"; // cached usernames pu[0] = guestphrase; pu[222249] = "Deemon"; // -->
Prev Previous Post   Next Post Next
  #1  
Old 07-04-2011, 04:55 PM
Deemon Deemon is offline
Newcomer
 
Join Date: Jul 2011
Posts: 1
Question Activate sheets and cells in separate workbook


Hi

I have two seperate workbooks in Excel - one with my command buttons and user forms, and the other to store the data entered. I need some code for a command button on the first workbook where the user forms are stored that will open the second workbook where the data is stored, activate a particular sheet within the data workbook and find the first empty row within the sheet, and then I need that sheet to be viewable to the user. I've tried all sorts of different combinations, and either the sheet isn't viewable to the user, or the sheet isn't activated properly. Help Please.
Reply With Quote
 

Tags
activate, cells, excel 2003


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->