View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tritaco tritaco is offline
external usenet poster
 
Posts: 1
Default Problem- Recording macros for "file save" and "File open"

i am trying to write a macro that has the following steps:

1- copies certain text from a worksheet cell
2- opens the "file-open" dialogue box
3- opens the "rename" function on the selected file
4- pastes (using rightclick menue) the copied text into the "file name"
field on the "file-open" tree.

problem: when i record these kestrokes and the stop the recorder and
review the macor in VB. steps 2-4 dont show up a all.

please help me.

thanks


---
Message posted from http://www.ExcelForum.com/