Excel Tabs

Microsoft OFFICE

    Sponsored Links

    Next

  • 1. Encrypt data in SQL Server
    Hi. I'm developing a VBA application with SQL Server. I need to encrypt data from client machine to server, but I have no idea how to do it. Any help will be grateful Regards.
  • 2. Duplicate Checks on a Text Field
    Hello, I'm using the following code on an add new record button on a form in my database: Dim rs As Recordset Set rs = Me.RecordsetClone Serial_No.SetFocus rs.FindFirst "[Serial_No] = " & [Serial_No].Text If Not rs.NoMatch Then MsgBox "Serial: " & [Serial_No] & " Is Already In Use, This Item Does Not Need To Be Re-Entered!", vbOKOnly + vbCritical Else DoCmd.GoToRecord , , acNewRec End If End If End Sub on line 4 I get a runtime error 3464 which is a datatype mismatch. The reason it has to be text is as our serial numbers are not just numbers, otherwise I'd use a datatype of number and change my code to .value, which I have tested and does work. Does anyone have a solution to this problem? Would be much appreciated. Chris.
  • 3. MS Office 2003 does not offer features promised in its advertisem.
    I upgraded from Office 2000 to Office 2003, only because I read a Microsoft Office advertisement in many magazines, which claimed that unlike Office 2000, the Office 2003 version would give me access to certain features, and I quote the ad "the latest version of of Microsoft Office includes Information Rights Management technologies. Now you can put limits on the printing, copying, or forwarding of sensitive e-mail and documents". After this advertisement persuaded me to buy Office 2003, I have now been told by Microsoft support staff that the Microsfort Office Basic Edition 2003, does not offer this feature. This was not mentioned in the magazine advertisement and I would therefore regard this advertisement as containing claims that are false and misleading and would be grounds for a lawsuit. I demand to know why Microsoft chose to mislead consumers like me in this regard and I demand that Microsoft offers a patch that Microsoft Office 2003 customers like me can download so that we can get the features that Microsoft claims that Office 2003 has.
  • 4. quick start
    I don't do programming very often so I always forget how in between. I just need some sort of a tutorial or short paper to get me started again. Does anyone have any suggestions? I definitely don't want to read a 500 page book, and I don't need to be an expert when done.

Excel Tabs

Postby Q3JlYXRpbmcgYSBXb3JkIHNob3J0Y3V0IGluIEV4Y2Vs » Sun, 06 Apr 2008 05:50:00 GMT

How can I call anther Worksheet, Word and Outlook from a Tab in a worksheet?
If I right click on a tab it has a View Code option. I've tried puting the 
path to the worksheet in there, but that doesn't work.

Re: Excel Tabs

Postby JP » Sun, 06 Apr 2008 09:57:02 GMT

What do you mean "call"? Do you mean "open"?

--JP


On Apr 4, 4:50m, Creating a Word shortcut in Excel




Re: Excel Tabs

Postby Q3JlYXRpbmcgYSBXb3JkIHNob3J0Y3V0IGluIEV4Y2Vs » Sun, 06 Apr 2008 11:45:00 GMT

Yes, I mean open. Thanks






RE: Excel Tabs

Postby TWlrZQ » Sun, 06 Apr 2008 11:51:01 GMT

Sub CreateWordDoc()
Dim wrdApp As Word.Application

    Set wrdApp = CreateObject("Word.Application")
    With wrdApp
        .Visible = True
        .Documents.Add
    End With
    
End Sub





Re: Excel Tabs

Postby JP » Sun, 06 Apr 2008 12:18:07 GMT

To start Word:

Sub StartWord()
Dim wdApp as Object
Set wdApp = CreateObject("Word.Application")
wdApp.Visible = True
End Sub

To start Outlook (late binding):

Sub StartOutlook()
Dim olApp as Object
Set olApp = CreateObject("Outlook.Application")
olApp.Visible = True
End Sub

To select another worksheet:

Worksheets("Sheet1").Range("A1").Select

Replace "Sheet1" with the actual name of the sheet you want to view.

All of this code should be placed in a standard module (see
 http://www.**--****.com/ ).

HTH,
JP

On Apr 4, 10:45m, Creating a Word shortcut in Excel



Similar Threads:

1.look up names in one excel tab to find a match in another tab

I have two tabs in an excel worksheet. The first tab is an older list of 
names. The last name is in column A and the first name is in Column B. The 
second tab is a recent list with new names added that are not on the first 
tab, which is an older list. How do I search the names in the 2nd more recent 
list to see which names are not on the original list? I need to know what 
names have been added on the recent list that are not on the older list.

2.PDF'ing in MS Excel 2003: Avoiding having each Excel tab saved as separate PDF file

I'm noticing this while trying to PDF in MS Excel (2003).  When I try
to send the pages I'm interested in PDF'ing to the printer to create
an Adobe document, the tabs are all saved as separate files.  I have
up to 200 pages that I need to PDF, and many of these documents are in
fairly complex Excel models in different tabs.

Is there any way to bypass this - in other words, have all the tabs
that I've selected to print, save as a single Adobe file, so that I
don't have to combine them later into one, consolidated document?   

By the way, I noticed that when I do this at home using MS's
PdfFactory, the whole thing saves as a single file.  But my cheap
employer isn't interested in getting PdfFactory.  Anything that I can
do.  Btw, the Adobe we're using at work is not the most recent Adobe
read/write either.  I believe it's either 6.0 or 7.0 Adobe
Professional which enables reading, writing, combining, encrypting,
etc.  Thanks.

3.PDF'ing in MS Excel 2003: Avoiding having each Excel tab saved as separate PDF file

On Sep 2, 11:27 pm, global risk appetite
<< XXXX@XXXXX.COM >> wrote:
> I'm noticing this while trying to PDF in MS Excel (2003).  When I try
> to send the pages I'm interested in PDF'ing to the printer to create
> an Adobe document, the tabs are all saved as separate files.  I have
> up to 200 pages that I need to PDF, and many of these documents are in
> fairly complex Excel models in different tabs.
>
> Is there any way to bypass this - in other words, have all the tabs
> that I've selected to print, save as a single Adobe file, so that I
> don't have to combine them later into one, consolidated document?  
>
> By the way, I noticed that when I do this at home using MS's
> PdfFactory, the whole thing saves as a single file.  But my cheap
> employer isn't interested in getting PdfFactory.  Anything that I can
> do.  Btw, the Adobe we're using at work is not the most recent Adobe
> read/write either.  I believe it's either 6.0 or 7.0 Adobe
> Professional which enables reading, writing, combining, encrypting,
> etc.  Thanks.

I'm using Excel 2003, too, with Adobe Std. 6. On the print, I select
"Entire workbook" and print to the PDF printer. It gives me everything
in one file. Perhaps the Print Selection works differently if
selecting only certain tabs?

4.Copy Excel tab (worksheet) to another Excel file

Hi!

I have a question about Excel tabs (worksheets)

Is there a possibility to copy a tab-page (worksheet) from an Excel file to 
another Excel file. I know that it is possible within the same Excel file, 
but is it also possible to copy outside this file?

Example:
Sheet X with worksheet ABC DEF GHJ
Sheet Y

I want to copy DEF from worksheet X to sheet Y

Kind regards, Stefan van der Hooft.



Return to Microsoft OFFICE

 

Who is online

Users browsing this forum: No registered users and 86 guest