Posts by msjacks

    I have a spreadsheet with several rows of data. Would I would like is a pair of buttons on each row where the user could approve/not approve the info on that particular row.
    I've tried Option buttons from the Forms toolbar, but you can only choose one option on the entire page, not one per line.

    Anyone have any thoughts?

    Re: Macro Is Shutting Down Application

    Yep. I replaced my code with yours and I ran it and it still shut down. In the same place it seems.

    I noticed that you have ".Close SaveChanges:=True" in your code. It still asked me if I wanted to save changes when it tried to close the file (this was before Excel gave me the error).[hr]*[/hr] Auto Merged Post;[dl]*[/dl]I had an Add-in called Hyperion Smart View for Office loaded on my excel. I unchecked the add-in and ran it, and it worked now.
    It seems that add in was interfering with the macro.
    Thank you for your help.

    Everytime I run this macro it shuts down Excel. I get a pop up box saying "Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience."
    The thing is, it runs at first and I seem to get this error when it gets to the 'Next' line in the macro.

    Is there something in my code that would cause Excel to shut down like this?

    Re: Macro To Open Workbook With Password

    Thank you so much!! This worked, but I have one more question.
    The file I am opening is also linked to another file. I do not want to update the links. Anyway to add this into the macro?[hr]*[/hr] Auto Merged Post;[dl]*[/dl]I found the update link info in another thread.

    Thank you again for your help.

    I have a workbook with the following code:

    This code opens a msgbox that asks for a password and then unlocks certain cells based on what the password is.

    I have 140 of these workbooks. I need to be able to open them all and change one cell in each file, save it and close. I've gotten the macro written to open, change and save the files, but I am still having to type the 'password' 140 times. Is there a way to bypass it?

    Re: Sql Code Converted To Access

    Thanks a whole bunch. I'm just not that familiar with writing queries using SQL in access.

    Here's what I changed it to. I'm getting an error message Syntax error (missing operator) in query expression ".

    I have been given the code to a SQL Query and I would like to recreate this in access. But obviously access doesn't recognize some of the syntax. Does anyone have an idea on how to update it to work in access?

    I am writing a SQL query and everything works, but I'd like to be able to prompt the user to enter the period they want to pull. I'm not sure what the proper syntax is.

    I know the [Enter period] statement isn't right, but does anyone know what the syntax should be?

    I'm not very fluent in creating access queries in SQL. Up to now, I've pretty much only used the Design View:

    I have two tables.
    One table lists all the residents in June, Another lists all the residents in July.

    I would like to be able to create a query that tells me which residents are in June but not in July. (Basically, who moved out during that period)

    Re: Max Date Adjustments

    The code was given to me by someone else. I copied it directly from the VBA screen.

    I don't need them to delete the date.
    For example. In cell k1 the user types $80, the macro would populate the date stamp (today's date) in cell Q1. But suppose they didn't mean to put in the $80 and want to undo the $80. Currently this macro prohibits them from being able to use undo.
    I was wanting to know if there is a way to still capture the date they change a cell, but without disabling undo.
    If there is a different code I should be using - I'm open to any suggestions.3

    Maybe if there's a way to have the macro run at the time of saving - it would update the changed cell date stamp on saving. But I don't know how to do that.

    I have the following code in my spreadsheet which marks the current date/time whenever a certain column has been updated.

    The problem is that when I have this macro it disables the undo option.
    I need to be able to date stamp any changes made but still allow user to undo any changes they make. Is this possible?

    Re: Max date in color range

    Yes, that worked!! Thanks a bunch!

    Ok - now how do I get it to update automatically when I open the file. Right now you have to click on the cell to get it to recalc.

    I have a spreadsheet (I've attached an example) that has a date stamp for when column B is updated.

    What I would like is to put into cell a1, the max date/time that the yellow cells have.
    This is the code that I currently have on Sheet1 to put the time stamp in.

    Private Sub Worksheet_Change(ByVal Target As Range)
        If Target.Column = 2 Then
            Application.EnableEvents = False
            Target.Offset.Offset(0, 2) = Now()
            Application.EnableEvents = True
        End If
    End Sub

    I am running a contest for my office and the theme is 'nascar'. Anyway - we'd like to chart the contestants using a racetrack. Is this possible in Excel or any other MS Office tool?

    Basically I'd like to show the placement of ten contestants on a circular racetrack. It would be updated weekly.

    Re: Send Keys error with Scheduler

    Can I bump this? Does anyone know anyway to possibly assist with this?
    Or if no one can help with scheduler is there a way excluding send keys to have an access macro open up password protected tables?

    I have set up an access macro to run several queries.
    I made a shortcut of this macro and set it with the scheduler to run everyday at a certain time. I need it to run regardless of whether I am in access or not and I am going to eventually save it on the server so it can run whether I am on the computer or not. It works in every aspect except when I have a send keys function as a part of my macro. I'm guessing the send keys doesn't work because when you run a scheduler it doesn't actually open the program on your desktop.

    There are passwords on the access tables and I needed the send keys function to type the password in for me.
    Is there any way around this? It gives me this error whether I run the scheduled program manually or on the server.
    The macro itself does not give me any errors when I run it manually - Just through the scheduler.