Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by chinster99

  1. chinster99

    Problems with cell reference

    Hi, I have problem referencing a cell from another worksheet. When I reference a cell by using: ActiveCell.FormulaR1C1 = "=costadjust('Video DVD _& Playstation'!R[" & -lastrow_dvd_paste2 & "]C[1])" The variable lastrow_dvd_paste2 works fine if its a postive number but when I put the...
  2. chinster99

    dynamic auto fill

    Geoff, Thanks for that, it works perfectly. i didn't know that was an option.
  3. chinster99

    dynamic auto fill

    Hi, I have a report that is connected to an external data source. One of the columns is a function that converts a number stored in the database to a recognised date format. So what I am looking for is a method in VBA to see the range of the data after the refresh, and autofill the function...
  4. chinster99

    waiting for the refresh

    Thanks for the answers, the time iinterval method seems to work. cheers Leo
  5. chinster99

    waiting for the refresh

    Hi, The problem I have is that I have about 20 reports scheduled to run on certain days. I have used VBA to refresh the data, make a copy and save the master document. For most of the reports when run in scheduler works fine. However some of the reports does not finish refreshing before it...
  6. chinster99

    Keystroke to get out of workbook_open macro?

    Thanks Geoff, I have already got similar if statement for the path of the document (so it only works in the master directory) but your idea is good because it means that the macro only works on my computer and only I need to know how to break the macro. Good job!!!
  7. chinster99

    Keystroke to get out of workbook_open macro?

    The only problem with the input box method is that the reports are run on a scheduler and needs to be an automatic process. The shift key method seems to work on my own computer however when I try to do it on the document via PC anywhere, it doesn't work. I don't know if its not working due...
  8. chinster99

    Keystroke to get out of workbook_open macro?

    Thanks for that, it helps with security level problem. Is there a way to stop the macro by a keystroke? because i still have the problem of the report looping to a close. (ie. if someone wants to modify the master document without the macro running)
  9. chinster99

    Keystroke to get out of workbook_open macro?

    Hi, I have a number of reports that are scheduled to run at various parts of the week/month. At the moment I have written a macro that resides in workbook_open. The macro saves the master documnent, makes a copy in another directory and creates a log of the process before shutting down. The...
  10. chinster99

    Lost VBA Password

    Thanks
  11. chinster99

    Lost VBA Password

    Hi, I have been give a MS Access db to alter at work however the original author has left along with the password for the VBA modules. Is there anyway to unlock the password, I have tried various things on the net however they only seem to be for user name and passowrds or VBA macros in...
  12. chinster99

    How to select multiple tables to autofit

    Cheers, that works fine
  13. chinster99

    How to select multiple tables to autofit

    Hi, I have a document that has a few hundred different tables in it, however some of the tables are not formatted correctly. I am trying to find a bit of code that selects all the tables then autofits the columns. Please can anyone help? Cheers Leo
  14. chinster99

    Word - Inserting the doc title into the sava as dialog box

    Sorry, I didn't make myself clear. When the user opens the template, a summary box is displayed where the title, author etc is shown. The user will enter something for the title. I then want the title of the document to be displayed in the saveas dialog box (the documnet is currently...
  15. chinster99

    Word - Inserting the doc title into the sava as dialog box

    Hi, I am trying to write a macro that inserts the title of the word document into the save as dialog box. I am going to use: ActiveDocument.saveas (???????) Dialogs(wdDialogFileSaveAs).Show to insert a value into the dialog box, however I need some code to call the title...
See more

Part and Inventory Search

Back
Top