Search:

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

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    104

    Different versions of Excel

    At work we are transitioning from office 2007 to office 2013. This transition is taking some time during which we have users who are on different platforms. Within macros>tools>references excel...
  2. Replies
    4
    Views
    322

    Deleting blank rows

    I need a few lines of code that delete the blank rows from a worksheet. I am currently using the code below, but this does not seem to always work

    In the following code...
  3. Replies
    0
    Views
    601

    Saving files to sharepoint

    I use vba to create monthly accounts files and save these to dirctory on the PC or server. I have now been asked to save the files to sharepoint instead. I have accessed the document properties...
  4. Replies
    12
    Views
    3,039

    No yellow warning bar is shown on opening the DB....

    No yellow warning bar is shown on opening the DB. However I think that, following a bit fo ferkling in the options area, I may have fixed the problem.

    However, I am still a bit confused about why...
  5. Replies
    12
    Views
    3,039

    I have copied all the tables and queries into a...

    I have copied all the tables and queries into a new data base instance on the server and the same fault has appeared in the new instance (still 2003 version) of the database. I have tried executing...
  6. Replies
    12
    Views
    3,039

    All the relevant records that I would like to...

    All the relevant records that I would like to delete appear to be displayed if I open the query and then choose data sheet view.
  7. Replies
    12
    Views
    3,039

    Thank you for all your suggestions. The...

    Thank you for all your suggestions.

    The delete query is just "Delete * from Accts2012 where period = 9" As stated previously this has worked quite happily for the last 4 years
    I will try...
  8. Replies
    12
    Views
    3,039

    Nothing happens when I run the delete query. If...

    Nothing happens when I run the delete query. If I change delete to select then the correct data is selected. When I change the query back to delete the DB once again just does nothing.
  9. Replies
    12
    Views
    3,039

    Access 2003: Running a delete query

    I have been using the same .mdb accounts database for the last 4 years, adding data to it on a monthly basis. Each month I need to add data in respect of an interim set of monthly draft accounts,...
  10. Update 2

    This problem is now solved. It helps if you do not send the email before you add the attachment...
  11. Update

    I have now found that I should use the code .attachments.add (filepath of item to be added) Instead of Attachments = .... However I have now encountered a further problem. I keep on getting...
  12. Excel vba to attach workbooks to a spreadsheet

    I have written code that successfully sends text emails by going down each line in a worksheet and sending reports to the addresses listed on each row. I now need to extend this code to attach...
  13. Replies
    5
    Views
    1,369

    Zeddy,The problem persists on both my local and...

    Zeddy,The problem persists on both my local and the network drives, however it is more pronounced on the network drive. Therefore I tend to copy the files to my local drive, run the macro and then...
  14. Replies
    5
    Views
    1,369

    Exporting sheets with multiple links

    I have a master standard monthly accounts workbook that holds project details and summaries for 100 projects. Each month I run a macro that: 1 Extracts detailed project data from Access for a...
  15. Replies
    1
    Views
    1,040

    Clearing excess formatting in a workseheet

    I have written a mocro that clears all the exces formatting from rows at the bottom of a worksheet.

    Now I would like to extend the macro to also clear the excess formatting that appears on any...
  16. Replies
    1
    Views
    583

    Copying sheets to a new workbook 2007

    We have just upgraded to 2007.

    I use macros to create project files. I have a master projects file in which I hold standard project reporting worksheets. By selecting a project from the...
  17. Replies
    1
    Views
    850

    excel 2007 file formats under save as

    As an example, when saving a .xlsm file in excel, the save as box restricts your view of other excel files whith the target directory to only those that end in .xlsm

    Is there a way of setting...
  18. Replies
    5
    Views
    1,008

    Thanks - formatting before inserting the formula...

    Thanks - formatting before inserting the formula worked

    @ Rory - the formula you provided was useful but has $ signs in front of the column references. Is there a variant that inserts formulas...
  19. Replies
    5
    Views
    1,008

    formatting imported data

    I import data from SAP into excel 2007. I then use a macro to insert 2 columns and in the second column the macro enters a formula as follows:

    ws.Cells(k, 4).Value = "=if(" & ws.Cells(k,...
  20. Replies
    4
    Views
    755

    Thanks for the replies - I will try out the...

    Thanks for the replies - I will try out the suggestions so far made

    I am just looking to change the font size in SQL

    Alex
  21. Replies
    4
    Views
    755

    Upgraded to office 2007

    I have just upgraded to Access 2007 and have 2 quick questions:
    How can I reformat the text on the SQL query page?
    Once a few tables and queries are open, they tend to get hidden behind each other....
  22. Thread: excel 2007

    by pergunas
    Replies
    3
    Views
    617

    Thanks for the information Rory - My initial...

    Thanks for the information Rory - My initial impression is that everything takes more effort in 2007:
    1. This action now takes potentially 3 clicks rather than one!
    2. This option is nicely hidden...
  23. Thread: excel 2007

    by pergunas
    Replies
    3
    Views
    617

    excel 2007

    I have just been 'upgraded' to excel 2007 and have 2 quick questions:

    Is there a replacement for the paste special values button, which appears to have disappeared?
    Given that the tools menu...
  24. Thread: pivot tables

    by pergunas
    Replies
    1
    Views
    467

    I use pivot tables to summarise staff time data...

    I use pivot tables to summarise staff time data by staff number and then by activity as rows and then by month in columns. Currently the pivot table only inserts the staff number in the first row...
  25. Replies
    3
    Views
    572

    Even if it works, note that the code will only...

    Even if it works, note that the code will only ever add validation to columns M and AG (if there's a 1 in column A) but never remove it (even if the 1 in row A is deleted).

    Thanks for the advise. ...
Results 1 to 25 of 249
Page 1 of 10 1 2 3 4