Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Visual Studio 12 express export text to csv file

    I am stuck. I am trying to export text from form to a csv file.

    Below is a part of the code I am working on, but I am now quite lost.

    Thanks for any help you can give me.

    Peter...
  2. Replies
    4
    Views
    197

    I have found the problem. I am using Excel...

    I have found the problem.

    I am using Excel 2013

    I have a lookup to lookup a reference number for a selected school, e.g. 2008. '=INDEX(SchoolList,MATCH(A24,SchoolNames,0),1)

    Excel is...
  3. Replies
    4
    Views
    197

    Thanks for picking this up. 1 - complete the...

    Thanks for picking this up.

    1 - complete the form and press the Save and Close button
    2 - Press the Import button on the Excel Database. 2 of the fields returned have a #N/A

    On the ReportForm...
  4. Replies
    4
    Views
    197

    #N/A when sheet is protected

    Please, please, please help. I must have spent 20 hours working on this with no resolution.

    I am creating a master form to be held in many schools.

    The user inputs data, which is held on a...
  5. Word VBA populate an imagebox with first image in table of images

    Hi

    I am at my wits end here.
    I have a word document with a table of 6 columns. The second column has a photo of a person in the row.

    I want a Userform with the data from the document table. I...
  6. Replies
    6
    Views
    1,170

    Thanks for the replies. This macro will be run...

    Thanks for the replies.
    This macro will be run by about 100 different machines in extended independent locations many times and it looks as though the code by Maudide will do the trick.

    Many...
  7. Replies
    6
    Views
    1,170

    Writing a function to another workbook

    Hi

    When the software I'm working with generates a report to Excel, it uses a standard workbook(1) to collect and format the data into a report in a new workbook(2). It is usual to add custom code...
  8. Replies
    4
    Views
    578

    Exactly what I wanted thanks Steve

    Exactly what I wanted thanks Steve
  9. Replies
    4
    Views
    578

    Sorry I wasn't very clear was I. What I have...

    Sorry I wasn't very clear was I.

    What I have is a table of staff names + column with date of birth of each.

    All I really want is this year's birthday date in another column for further...
  10. Replies
    4
    Views
    578

    Show last birthday date in Excel 2010

    I need to calculate how many days leave staff are entitled to.

    Leave entitlement is counted from their last birthday month.

    I have birthday and today's date, but I am having trouble with a...
  11. Hi zeddy The error has returned when I use the...

    Hi zeddy

    The error has returned when I use the userform, but in other cells too.

    I have scrapped the idea of using a dual system of inputting data and exported and removed the userform and will...
  12. Thanks

    Thank you so much for solving this, and thanks for the code cleaner link.

    Not sure how I would run it, but it obviously works.

    Is it worth you saying what was wrong or was it just 'left over...
  13. With attached file

    Please excuse the messy coding.
  14. Love to have your help thanks. I'll change the...

    Love to have your help thanks.

    I'll change the details to protect the innocent and, if I can work out how, post a copy.
  15. No, no code there. Here is a screen shot? ...

    No, no code there.
    Here is a screen shot?

    34647
  16. Thanks Steve and zeddy Every time I change the...

    Thanks Steve and zeddy

    Every time I change the list box the formula is lost. I have searched the VBA code for ThisWorksheet and the userform, but cannot find any reference to the cell that's...
  17. Well Steve I suspect you are right. I built the...

    Well Steve I suspect you are right.
    I built the worksheet for data entry with the calculated result all working OK.
    I then had a brainwave and built a VBA userform to step through the data entry...
  18. Cell reference keeps reverting to data result

    Hi
    I have a cell F13 and I enter this formula into the cell: =O9

    Cell O9 contains a formula to return a number formatted as General, say (15) without the brackets.

    Cell F13 displays the result...
  19. Outlook form from Access - How do I change field property in generated form

    Hi

    Not sure if Outlook is the correct forum, but will start there.

    I need to send out a survey form by email. The recipients have Office 2007 or 2010.

    Building the form in Access 2010 and...
  20. Thank you so much for your help. One of the...

    Thank you so much for your help. One of the reasons it didn't work was that the focus was on the wrong sheet (Sheet2) immediately before the create pivot table code.
    I tried many different methods...
  21. I'm sorry, but it still doesn't create the PT. It...

    I'm sorry, but it still doesn't create the PT. It fails at the create pivot table line.

    I have pasted the whole code below and if needed I can post the spreadsheet, but I must get this working...
  22. Back again! I tried to create a Name as below:...

    Back again!

    I tried to create a Name as below:

    Sub MakeName()
    ActiveWorkbook.Names.Add Name:="Database", RefersTo:="offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A$1:A$A3000 0),4)"
    End Sub

    Added...
  23. Thanks That will be what I need. The rows,...

    Thanks

    That will be what I need.

    The rows, in real life probably will never be more than 500 and your code is perfect.

    Many thanks

    Peter
  24. New pivot table macro hard coding the range - I need a flexible range

    Hi. I created a macro recording to create a pivot table and, because it worked well on my test data set, used it in a functional spreadsheet.

    Now I discover that the range for the pivot table data...
  25. Excel 2010 - show (PivotTable) report filter pages

    Hi
    I have created a pivot table and click Options - Options - Show report filter pages.

    This works admirably except that the final page is always named Sheet11 or whatever the last number of...
Results 1 to 25 of 50
Page 1 of 2 1 2