2007 Excel Issues

J

Jenny B.

Good Afternoon,

I'm running into a problems with Excel 2007 at my workplace vs. my Excel
2007 home addition. I have a program written in Excel 2003 (has to stay that
way for other users) that I'm running from Excel 2007. The program (see
below) writes and copies all data to another workbook. When I'm testing the
program at my workplace, it does not copy over any of the shapes or text
fields just the cell content. In Excel 2003 and Excel 2007 at my home, this
data copied over automatically (no special or additional programming needed).

I posed this question before and Barb Reinhardt was kind enough to provide
me with a way to accommodate both 2007 and 2003. I'd go ahead and update the
program, but I don't want to write extra code just to accommodate what
appears to be a quirk if it's not necessary. Is there an add-in Tool Pak
that needs to be updated or something else I'm not thinking of? Has anyone
else run into this before?

If it turns out that no one else has seen this same problem, Is there a
quick way to capture all the text and fields so they paste over like the
Active Sheet data? Traditionally, ActiveSheet.Copy would bundle everything
into the new worksheet and I’m wondering if there's an equivalent to capture
both the shape and text fields.

Thanks in advance and I appreciate anything that would keep me of writing
tons of new code that might not be necessary -

Jenny B.




Sub Finalstop()

Dim myPath As String
Dim nRng As Range
Dim fName As String
Set nRng = Range("F64")

ActiveSheet.Copy

myPath = "I:\Document Management\Print management\Operations\B55
Docs\B55 Testing Checklist\"
fName = nRng.Value & ".xls"

ActiveWorkbook.SaveAs Filename:= _
myPath & fName, FileFormat:= _
xlNormal, Password:="", _
WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False
ActiveWorkbook.Close
ActiveSheet.Visible = False

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top