Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    482

    Perfect! Your code produced the original number,...

    Perfect! Your code produced the original number, and I added a "+3" at the end for the end date of 2016. This is one of those documents that goes on for decades, and having a field code...
  2. Replies
    4
    Views
    482

    Yes, indeed -- I've been a devotee of several...

    Yes, indeed -- I've been a devotee of several versions of Date Calculation -- I have at least three on the desktop right now. I have a field code that adds a year, or subtracts a year, from the...
  3. Replies
    4
    Views
    482

    Date Calculation Election Schedule

    My efforts to tweak the field codes to calculate a date range hasn't been successful.

    What's needed is an automatic update for the beginning and end of an organization's three-year election...
  4. First, thank you, Andrew; the method worked...

    First, thank you, Andrew; the method worked perfectly. The temp file is gone for good.

    Second, I now have a related query. Once the temp file was gone, I had the bright idea of deleting the...
  5. Excel 2010 VBA: language to delete "temp.xls" file

    I have a two-part payroll process where employee data is exported from an Access utility to an Excel file, whereupon the user runs an Excel macro of mine to put the data into the format required by...
  6. Thank you very much! I will share the DoCmd...

    Thank you very much! I will share the DoCmd TransferSpreadsheet approach as being the most likely to work well.

    axsc
  7. Office 2010 (Access VBA) export to Excel 2003 .xls?

    We have an Access utility which processes timesheet data. One of its valuable features is that it will export a week's worth of data to a spreadsheet in Excel 2003 format, which the clerks enter...
  8. Replies
    1
    Views
    1,701

    Iím attempting to encourage an Excel macro to...

    Iím attempting to encourage an Excel macro to repeat a block of code about fifty times by using a For Next loop.

    I need to
    Copy and paste a set of headers from one workbook
    Extract data from...
  9. Replies
    3
    Views
    496

    Thank you! I'll test the Sending Mail with CDO,...

    Thank you! I'll test the Sending Mail with CDO, which looks the most likely. The "A1" reference picks up a subject line in the format "Report of " &B1 -- B1 being the cell showing the date of the...
  10. Replies
    3
    Views
    496

    I have a simple little one-line macro -- at least...

    I have a simple little one-line macro -- at least at the moment -- to send a workbook.

    ThisWorkbook.SendMail "RAJ7", Range("A1").Value


    However, it triggers a warning message from...
  11. Replies
    11
    Views
    2,299

    Thank you, John, Hans, and Macropod! I may not...

    Thank you, John, Hans, and Macropod!

    I may not have been as clear as I should have been in describing the problem: I could certainly right-align the 80-character concatenation and every one of...
  12. Replies
    11
    Views
    2,299

    I'll try the code and see what happens. What I...

    I'll try the code and see what happens. What I have is ten source-data-from-the-field Excel sheets which I paste into a single workbook, and extract their data into two other worksheets we've been...
  13. I downloaded the newest DateCalc.zip file,...

    I downloaded the newest DateCalc.zip file, DateCalc V2_85.doc from http://bro.ws/249902L, and happily buried myself in it, but found that when I arrived at "Calculate the day & date of the nth day of...
  14. Replies
    11
    Views
    2,299

    Is there a variant cell formula that will cope...

    Is there a variant cell formula that will cope with leading zeroes? I had just formulated a somewhat complicated report so that the output had everything the state office wants, IN the required...
  15. Replies
    3
    Views
    386

    As it turned out, you can select the entire GAL...

    As it turned out, you can select the entire GAL -- select the first entry, go to the end and shift-click to select All, and add everything to your Contacts list. From which you can export the whole...
  16. Replies
    8
    Views
    4,172

    I find that Username, UserAddress, and...

    I find that Username, UserAddress, and UserInitials are very handy fields to have. Does anyone know of any way to create and store for permanent use another field? UserPhone and UserFax, for...
  17. Replies
    3
    Views
    386

    Many thanks! I can see this one will take me a...

    Many thanks! I can see this one will take me a while, since I probably will have to cobble it from scratch.

    Ann
  18. Thread: Concatenate

    by axsc
    Replies
    13
    Views
    831

    I just recreated it with no problem, including...

    I just recreated it with no problem, including trailing spaces, which just appeared in the result when they were added to the source cells.

    I did use the Function Arguments dialog box -- typed...
  19. Replies
    3
    Views
    386

    I need to extract from a large (46K entries)...

    I need to extract from a large (46K entries) General Address List about six hundred individual entries and save them as Contacts. (Next step, export the Contact folder to an Excel spreadsheet). I...
  20. Replies
    1
    Views
    465

    Does a workaround exist to allow a time format...

    Does a workaround exist to allow a time format with a 12-hour clock which doesn't include "AM/PM"?

    I have a smallish available space for this information on a PowerPoint slide, with the data...
  21. Replies
    1
    Views
    491

    We have seven conference rooms in the...

    We have seven conference rooms in the department's Outlook calendar, and need to transfer the next day's scheduled meetings to a PowerPoint slide to post on a conference board. I can use the Active...
  22. Re: Data Validation using source from other worksheet (2003 SP2)

    Thank you! If this is a new idea, let's make a note of it for future reference ...

    L.P.H.,

    Ann
  23. Data Validation using source from other worksheet (2003 SP2)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    I need to use data validation using a list maintained in another workbook on a shared network. I set up an experiment with...
  24. Replies
    1
    Views
    406

    Used.Range Tweak (2003 SP2)

    Earlier help on forcing the format of cells to plain text gave this piece of VBA. It works so well that I'd like to tweak it to work on, say, a selection of cells of the "A10:B15" or named range...
  25. Replies
    10
    Views
    733

    Re: Stretch-Squeeze Button (2003)

    For what it's worth, I finally concluded that the smoothest way to deal with stretching and squeezing was to remove all Lock Ratio options and specify/reset the picture size every time the file...
Results 1 to 25 of 71
Page 1 of 3 1 2 3