Search:

Type: Posts; User: Mario; Keyword(s):

Page 1 of 16 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    5
    Views
    484

    Thanks, it works 100%

    Thanks, it works 100%
  2. Replies
    5
    Views
    484

    I'm receiving a file with a column with alpha...

    I'm receiving a file with a column with alpha numerical text. I need to add to the left of the value zero's to make it 12 digits. An example is 1A becomes 0000000001A and 124ABC should be...
  3. Replies
    1
    Views
    404

    Error was in the formula. Thanks

    Error was in the formula. Thanks
  4. Replies
    1
    Views
    404

    A colleague is trying to do a vlookup on Excel...

    A colleague is trying to do a vlookup on Excel 2007 in column 257 and based on values on another column 257 in another spreadsheet and the result is #value. Are there a work around except splitting...
  5. Thanks Hans

    Thanks Hans
  6. How do I show the next page's number on the...

    How do I show the next page's number on the current page. I would like to end the page with ..../2 on page 1

    TIA
  7. Replies
    3
    Views
    421

    So Hans there is no id for separate Excel...

    So Hans there is no id for separate Excel "Sessions" on a server if the users uses an generic log on?
  8. Replies
    3
    Views
    421

    I have the following problem. I receive Excel...

    I have the following problem. I receive Excel Spreadsheets via email and then upload via a web page to a server. Excel process does not successfully close. Is there a way of identifying a Excel...
  9. Replies
    1
    Views
    455

    I have a spreadsheet where the spreadsheet is...

    I have a spreadsheet where the spreadsheet is flipped. Cell A1 is in the rigth top cornor and the row numbers runs on the right side of the spreadsheet. The scroll bar is also on the left side. I...
  10. Thread: Instr Function

    by Mario
    Replies
    3
    Views
    437

    Thanks it work great

    Thanks it work great
  11. Thread: Instr Function

    by Mario
    Replies
    3
    Views
    437

    I've written the following code but keeps getting...

    I've written the following code but keeps getting an #name error

    Public Function INSTRING(TextSearch, TextFind)

    Dim LPosition As Integer

    LPosition = InStr(1, TextSearch,...
  12. Replies
    2
    Views
    2,415

    Re: Can't get rid of 2nd page (Word 2007)

    Thanks the second solution work.
  13. Replies
    2
    Views
    2,415

    Can't get rid of 2nd page (Word 2007)

    I have a document with only 1 page of writing. I can't get rid of the 2nd page. Refer attached.

    TIA
  14. Re: Changing Excel import behaviour (Excel 2007)

    Thanks Hans. The other alternative is to use Macro's. I know that there is a way of using a specific naming convention for the macro, then SAP performs this macro in Excel before it finalise the...
  15. Re: Changing Excel import behaviour (Excel 2007)

    Thanks Jan
    Thanks Hans

    I will try and explain Hans. Inside SAP (Access is the same) you have the option to open your current view with Excel and the SAP Report changes to an excel worksheet. ...
  16. Changing Excel import behaviour (Excel 2007)

    I want to open a Excel File from within SAP. When Excel opens it reads the fields and queses the field type. In this file I'm opening it has a credit card number. Excel then changes it to a...
  17. Replies
    1
    Views
    366

    import into access from .net (office 2003)

    I currently have couple of forms in access with a button that triggers the import of files into an Access table using docmd.transfer and a saved spec. I want to trigger this event from a .net front...
  18. Replies
    4
    Views
    1,326

    Re: Macro to mail message (Outlook 2003)

    Thanks Hans. I will try it
  19. Replies
    4
    Views
    1,326

    Re: Macro to mail message (Outlook 2003)

    To be honest I'm to lazy to click forward and then selecting the right address. I will be "saving" 1 click.
  20. Replies
    4
    Views
    1,326

    Macro to mail message (Outlook 2003)

    Can someone maybe help me with a macro to send a message out. I would like to setup an icon that will send the open message out to another address. I know it would be better to create a rule but I...
  21. Replies
    6
    Views
    416

    Re: Email address with 's (Access 2003)

    Thanks Hans.
  22. Replies
    6
    Views
    416

    Re: Email address with 's (Access 2003)

    No I don't. What is the right method/code

    TIA
  23. Replies
    6
    Views
    416

    Re: Email address with 's (Access 2003)

    After your statement about spaces not allowed I realized that I am showing the name as it appears on our company's address book. I will change the email address the RAM's@shop as it appears under...
  24. Replies
    6
    Views
    416

    Email address with 's (Access 2003)

    I would like to send an email to the following address (WC RAM's@shop) with code. I'm having problems with the 's and or space and when the email goes out it goes to WC. How do I change the code to...
  25. Replies
    9
    Views
    536

    Re: Excel Template (Excel 2003 / 2000)

    Hans I don't understand it. We've changed the code and created the template. If I take that template to the Excel 2000 I can't edit the range. If I then unprotect the worksheet and go to Format...
Results 1 to 25 of 399
Page 1 of 16 1 2 3 4