blinkme323
09-18-2008, 09:52 AM
Hey guys, my company is currently using a VB coded Excel sheet to estimate certain jobs. We are also using ACT 10 as our contact manager. There is a tool that allows you to attach and save excel sheets to the ACT databse that we would like to use. The tool works by embedding certain functions within the excel sheet, such as "setting_SaveAs", "setting_Attach" , etc.
Whenever I input the "save as" function and try to use the excel sheet I am hit with a "run-time error 1004, unable to set the MergeCells property of the range class." I know it's a shot in the dark, but does anyone know why this might be happening? Or why the "save as" function would have this effect? I'm kind of at a loss.
Thanks
Whenever I input the "save as" function and try to use the excel sheet I am hit with a "run-time error 1004, unable to set the MergeCells property of the range class." I know it's a shot in the dark, but does anyone know why this might be happening? Or why the "save as" function would have this effect? I'm kind of at a loss.
Thanks