Replies

Another thank you to Hans. At least now I know what to situations to avoid.

Thanks Hans,

Personal.xlsb is now loading on startup

I played around a little more and found this syntax will work.

PDF Format(*.pdf)

I appreciate your efforts

I get a message reading “The format in which you are attempting to output the current object is not available”.

However, I have included a screen shot of the options when manually exporting a file.

I have a similar question. I have a spreasheet that we use to track employee attendance. In cells D12 thru J65 we enter codes to specify what happened with the employee on that day. The codes are either a one, two or three characters long followed by a space and a number (i.e. “v 8”, “lp 6.5”, “fmv 4.25”). I am currently using conditional formatting to change the background color of the cell based on the alpha characters that were entered in the cell. The problem is I have more codes than conditional formatting will allow. Are there any workarounds or code that may tackle this better?

For the cells that I want to highlight, I have four different colors that the backgrounds can be changed to, but I also have 18 different codes that need to be reviewed. Any ideas?

Thank you very much Hans. That worked perfectly. I knew I was doing something wrong, but I rarely work with strings.

Cell E1 had a space before the word Status that was causing the import issue.

Thank You

When maximized the movable line was not available.

I did try all the other steps listed, and I am now able to view the design grid.

Thank you very much for the quick response.

Thank you very much. By adding the red code, it now works. I should have known this, as I have another procedure that loops thru all the worksheets and then prints the selected sheets a specified number of times. I cut/pasted the red code from my other procedure.

Sub PrtWksht()
'   Created by Steven M Henderson on August 21, 2001
'   This procedure will cycle through the worksheets of the active
'   workbook and print all of the CPWU worksheets ignoring the
'   built in worksheets used to create everything else
        Dim oSheet As Worksheet
        For Each oSheet In Worksheets
            If oSheet.Name  "Template" _
                And oSheet.Name  "RCList" _
                And oSheet.Name  "Template(2001)" _
                And oSheet.Name  "List" _
                And oSheet.Name  "DataLibrary" _
                And oSheet.Name  "DataLib" Then
                    If oSheet.Visible = xlSheetVisible Then
                        oSheet.PrintOut
                    Else
                        'fall through by design
                    End If 
            Else
                'fall through by design
            End If
        Next oSheet
    Next x
End Sub

I appreciate your quick response.

That worked. Thanks.

However, I didn’t explain my problem well enough, or I have a different problem. After making the changes suggested above, when I open an existing document and check the settings they are set on manual paper tray. It is almost like every exisiting word document had its properties changed to the manual paper tray.

Any other suggestions?

couple of reasons. 1) the things being tracked are different for each department, and more importantly 2) when I set this up several years ago, I didn’t know any better. I was an access beginner who was tasked with the project. Now I don’t have the time to do it better.

What a simple solution. Thank you for pointing it out to me. It worked like a charm.

Thank you Jan Karel. What a simple solution.

AutoFilter didn’t occur to me as a solution. I was trying to delete rows where the value in column F started with the letters “PASS”. I didn’t realize until I was testing your solution that I could use wildcards in the criteria for AutoFilter.

I will be able to use this in multiple places. Thanks again for the time saving tip.

Thank you Hans!

Once I corrected my typos, the domain function worked like a charm. Exactly what I was looking for.