Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Edit existing Excel file and read cells

Status
Not open for further replies.

fmientjes

Programmer
Mar 27, 2002
55
NL
From VBA I would like to do the following:

1) Open Excel with a given file (read only if possible)
(A2=value, B2=A2*2)
2) Edit the value in a specific cell (say A2)
3) Recalculate
4) Read the value from a specific cell (say B2)
5) Close Excel, without saving changes

Extra:
If more users run this action at the same time, will it cause problems (or will open read only do the trick?)

Thanks for your help,
Frans
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top