civilmonkey
October 16th, 2003, 02:28 PM
Hello,
I would like to be able pass values to a macro I have programmed into an excel spreadsheet.
I've been able to open a spreadsheet and add data, but if I try to open a spreadsheet with macros, I get an error.
I'm running a website from win 2000, using IIS.
I've used this code to open my spreadsheet:
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Open ("c:\test.xls" )
and can add data with this:
ExcelBook.Worksheets(1).Cells(2, 2).Value = "whatever"
If I add a macro to test.xls, this doesn't work. I thought it might be a problem with securities, so I set the security in EXCEL to low, but it doesn't make a difference. Do I need to digitally sign my macros and become a trusted source?
Any help would be appreaciated.
Thanks,
Paul
I would like to be able pass values to a macro I have programmed into an excel spreadsheet.
I've been able to open a spreadsheet and add data, but if I try to open a spreadsheet with macros, I get an error.
I'm running a website from win 2000, using IIS.
I've used this code to open my spreadsheet:
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Open ("c:\test.xls" )
and can add data with this:
ExcelBook.Worksheets(1).Cells(2, 2).Value = "whatever"
If I add a macro to test.xls, this doesn't work. I thought it might be a problem with securities, so I set the security in EXCEL to low, but it doesn't make a difference. Do I need to digitally sign my macros and become a trusted source?
Any help would be appreaciated.
Thanks,
Paul