• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy paste Particular page from .TIF extension file

A

Abhijeet

Active Member
Hi

I want to know from 20 to 30 files of .TIF extension particular page number i want to copy paste in new file. I have all data in One excel sheet File Names Which Page number want to copy paste. i.e if file name is abc.tif page number 50,65,78,99 then save this pages in new file with same file name abc in different path that is also mention in excel sheet

actually i have tried with this data loader but that is not success 100%

Please tell me if any one have idea how to do this with help of macro
 
Hey Abhijeet.

Your are referring to "Tagged Image File Format" not really sure, if this is possible..But if you can post sample file with dummy data..Just wanted to give a try.
 
Hi

I found one VBA code for PDF file can any one please tell me how to modify for .TIF files
Code: 
Sub OpenPDF()
Dim aRow As Row
Dim vDocument As String
Dim vPage As String
Dim vAdobe As String
Dim result As Long

vAdobe = <File path to Acrobat.exe here.>
If Selection.Information(wdWithInTable) = True Then
    Set aRow = Selection.Range.Rows(1)
    vDocument = Trim(Replace(Replace(aRow.Cells(2).Range.Text, "", ""), vbCr, ""))
    vPage = Trim(Replace(Replace(aRow.Cells(3).Range.Text, "", ""), vbCr, ""))
    result = Shell(vAdobe & " /A ""page=" & vPage & """ " & vDocument, vbNormalFocus)
Else: 'Some error message here.
End If
End Sub
 
Hi

Unable to upload Sample file because .tiff file not allow to upload here so please tell me what to do
 

Hi !

Nothing to do with Excel !
You must save "pages" for example from a photo editor software …
​
 
there are multiple folder this files are saved particular page i want to copy paste in new files save that file to particular location all info is this possible
 

The question is : what is a .tif file ?!

Just search on Web and use an appropriate software …​
 

What crystal clear means « page » and « new file » ?

As there is no obvious match with Excel, you got the wrong forum,
the reason why there is no answer …
​
 

This link is about converting a pdf file using Adobe Pro version ($$$ !) …

As tif is a graphic file format you need a graphic software !
​
 

Maybe, it's often erratic using SendKeys … Good luck !

This thread is closed for me now …​
 
I use send key in to send emails from Outlook this work also i read on net this is not good but try its work in that macro i am not sure
 

As it not exists in standard VBA you coud use external API
like for example Windows Image Acquisition …​
 
You must log in or register to reply here.
Back
Top