Saving TIF file question

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

In my macro, I open a TIF file and store the file name /
location in a variable.

At the end of the macro, I want to save the file in the
variable with a different name but I'm having trouble with
the syntax.

I've tried using the macro recorder for save as but that
helps me save the Excel workbook instead of the TIF file.

Any help with the syntax would be appreciated.
 
You can't really save a TIF file from excel. What you can do is make a copy
of the Tif File

see help on the filecopy command. Note that the file can't be open. If you
have imported the file into excel, then I don't believe it will be open, but
haven't tested it myself.
 
If you know the name of the TIF file, couldn't you just do a FileCopy to copy it
from its original location to another location.

VBA's help has a nice example if that fits.
 
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

Excel help - Find and copy files 10
Opening a list of Excel files and run a macro in each 17
script to replace data in csv file 5
Copy List of Files using Excel 5
Macro to insert picture from specific folder 0
Lose macros before saving 4
How do i save a image to the same folder my .xls file is located? 2
Macro for all Excel Workbooks to print to PDF 2

Back
Top