Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 1004
I open an Excel spreadsheet from within MS Access 2003. I have the following code: ExcelSheet.Application.Rows(intRow & ":" & intRow).Select ExcelSheet.Application.Selection.Font.Bold = True ExcelSheet.Application.Columns("B:B").Select ExcelSheet.Application.Selection.HorizontalAlignme nt "xlRight" The first three lines work fine. I select the current row and set the font to bold. I then select colum B and want to set it to right align. I get the following error msg: Run-time error '1004' Unable to set the HorizontalAlignment property of the Range class. Found a tip on MS.com where you set Macro Security to allow VBA... this doesn't work in this situation. I created a macro within Excel, which works fine... just not fro within MS Access. Any ideas -- edrecz ----------------------------------------------------------------------- edreczk's Profile: http://www.excelforum.com/member.php...fo&userid=1609 View this thread: http://www.excelforum.com/showthread.php?threadid=27544 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 1004
ExcelSheet.Application.Rows(intRow & ":" & intRow).Select
ExcelSheet.Application.Selection.Font.Bold = True ExcelSheet.Application.Columns("B:B").Select ExcelSheet.Application.Selection.HorizontalAlignme nt = xlRight Take the quotes off xlRight if you are using late binding, use the value of the constant: ExcelSheet.Application.Selection.HorizontalAlignme nt = -4152 -- Regards, Tom Ogilvy "edreczk" wrote in message ... I open an Excel spreadsheet from within MS Access 2003. I have the following code: ExcelSheet.Application.Rows(intRow & ":" & intRow).Select ExcelSheet.Application.Selection.Font.Bold = True ExcelSheet.Application.Columns("B:B").Select ExcelSheet.Application.Selection.HorizontalAlignme nt = "xlRight" The first three lines work fine. I select the current row and set the font to bold. I then select colum B and want to set it to right align. I get the following error msg: Run-time error '1004' Unable to set the HorizontalAlignment property of the Range class. Found a tip on MS.com where you set Macro Security to allow VBA.... this doesn't work in this situation. I created a macro within Excel, which works fine... just not from within MS Access. Any ideas? -- edreczk ------------------------------------------------------------------------ edreczk's Profile: http://www.excelforum.com/member.php...o&userid=16094 View this thread: http://www.excelforum.com/showthread...hreadid=275440 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error 1004 | Excel Discussion (Misc queries) | |||
runtime error 1004 HELP PLS | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
runtime error 1004 | Excel Programming | |||
runtime error 1004 | Excel Programming |