Save workbook with values not formulas

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

I am merging a form in Excel by Linking the form cells to another worksheet
that is exported from Access. After the underlying sheet is created the form
is opened and updated.

From here, I save the workbook but would like to replace the linked values
with just the values.

Is this possible? Any suggestions are greatly appreciated.
 
Hi one
way:
Activesheet.range(A1:A1000).value = Activesheet.range(A1:A1000).value
adapt the range to your needs
 
Another

Cells.copy
Cells.PasteSpecial paste:=xlValues
Application.CutCopyMode = False
 
You must log in or register to reply here.

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

Cell values to an array, then array transpose to another workbook 8
Export Sheet Values to new workbook 20
VBA code for pasting links -- modifying RDB code for summary workbook 10
Copy value from changing cells without VBA 1
how to copy worksheet to new workbook with values only 3
copying cells with more then 255 characters to new workbook 4
Changing Formulas to values in "protected workbook" 5
Export Only Values 7

Back
Top