Hi,
I have some code that set up a logo in Excel thu VBA code in Access
all of a sudden, I am getting the 1004 error ......
at the .filename = ....
Can anyone help me shed some light on this ? I cannot figure this one out
THanks
I have some code that set up a logo in Excel thu VBA code in Access
all of a sudden, I am getting the 1004 error ......
at the .filename = ....
Code:
Dim strLogo As String
strLogo = DLookup("path_logo", "parametre_general")
Debug.Print strLogo
'bypass insert logo if path is null
'the logo should always in the the logo folder
If Len(strLogo) > 0 Then
' If Forms![MENU_PRINCIPAL]![LOGO].Picture <> "(none)" Then
With oXls.PageSetup.RightHeaderPicture
.FileName = strLogo
.Height = 51.75
.Width = 112.5
End With
Can anyone help me shed some light on this ? I cannot figure this one out
THanks