• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 86
  • Last Modified:

Publish

I had this question after viewing Fasten The Updating Process Watch 11.

Hi Experts,

i have one file --were macro create tables in 4 sheets ....i need that sheets to be saved as PDF files in this path "C:\Users\itjockey\Documents\Performance Watch" if this folder dosent exit then save files to Workbook location.

See attached Thanks
Funds-Watch-v10.xlsm
0
Naresh Patel
Asked:
Naresh Patel
  • 13
  • 6
1 Solution
 
Naresh PatelTraderAuthor Commented:
Forgot to mention if PDF file is already exist then over past...

Thanks
0
 
Ejgil HedegaardCommented:
Try attached file.
Start button on Setting sheet.

The first creation of the 16 pdf files used more than 15 minutes, so I have changed the code to use manual calculation for dashboards and rolling returns also.
It only calculate the calculation sheet when data is transferred, before copy to result.
And calculate all when each procedure ends.
Then the pdf files are created in a few minutes.
Existing files in folder are replaced without warning.
It would be quite easy to add a feature where you could select the output folder.

To be able to catch all types on the Rolling sheets, the validation list are moved to the hidden sheet Lists, with the range name ValidationList.
Funds-Watch-v11.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Few Questions..
It would be quite easy to add a feature where you could select the output folder.

1) As A Code writer what you suggest do we go for that feature or current scenario is ok? what logically it should  be ?

2) Some PDF have Extra pages ......it is purposely left blanks For  in future if i add more schemes  So there is  room for that data table...???

3) It possible to Add Fund type in each page Upper Left ...See attached & my contact information in each pages Lower Right of PDF file?Snap
And Above all 3 ...i am happy with current WB if above 3 takes too much coding & time.

Thank You
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Ejgil HedegaardCommented:
1) Another way is to let the program make a subfolder to the Funds-Watch folder, for each new day with the format "Pdf yyyy-mm-dd", so for today it will be Pdf 2016-07-29.
If folder exist, files in folder are replaced.
I have used that in attached version.
Try that, but if you prefer folder selection, just let me know.

2) It is not intended to have blank pages.
I used last used cell to set the print range, but Excel does not always clean up, and I did not check all pdf files, so I have changed to use the last cell in column A for dashboards and column B for rolling.

3) Fund type and contact information added.
Funds-Watch-v11.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Sir i cant able to download file ......may be some issue with EE server ...i am chatting with EE Representative .....will revert you soon.

Thanks
0
 
Naresh PatelTraderAuthor Commented:
One Favor please if you dont mind it ....Send file on my email as not only me others too facing same problem i.e. cant able  to download macro enable file.

Bug

Thanks
0
 
Naresh PatelTraderAuthor Commented:
or do one thing change extension to .txt and post i will change extension to .xlsm and will check.

Thanks
0
 
Ejgil HedegaardCommented:
0
 
Naresh PatelTraderAuthor Commented:
it not happening i guess bug is related to file size ...Bug
0
 
Naresh PatelTraderAuthor Commented:
EE support able to download but i cant ....they said sending me in email with file but still not got email ...
0
 
Ejgil HedegaardCommented:
E-mail send.
0
 
Naresh PatelTraderAuthor Commented:
ok thanks got it ...my main email is itjockey@hotmail.com
0
 
Naresh PatelTraderAuthor Commented:
Sir one request -  need to stay with fix location or if  location is not their then save to workbook location ...as old files have no use for  me ...and it will be data overflow.

Thanks
0
 
Naresh PatelTraderAuthor Commented:
This weekend will frame new series of workbook .....this will be big but it may also use for you ...if you trade in stock market in your country ...i mean OMX Exchange. So please be a part of it..

Thanks
0
 
Ejgil HedegaardCommented:
In module M13_MakePdf, sub MakePdfFiles, change these lines in the beginning of the sub

   
strFolderForPdf = ThisWorkbook.Path & "\Pdf " & WorksheetFunction.Text(Now, "yyyy-mm-dd")
    If Dir(strFolderForPdf, vbDirectory) = "" Then
        MkDir strFolderForPdf
    End If

Open in new window


to

   
 If Dir("C:\Users\itjockey\Documents\Performance Watch", vbDirectory) <> "" Then
        strFolderForPdf = "C:\Users\itjockey\Documents\Performance Watch"
    Else
        strFolderForPdf = ThisWorkbook.Path
    End If

Open in new window

0
 
Naresh PatelTraderAuthor Commented:
ok noted,,

Thanks
0
 
Naresh PatelTraderAuthor Commented:
Will You Take On This Question?i Greatly Respect Sir.Glowflow And I Never Invite Other Expert If Someone Is working On It....But It Seems Sir.GowFlow Is Busy Now Days.

Thanks
0
 
Ejgil HedegaardCommented:
It looks as an expansion of a long series of questions gowflow has answered.
His question to you shows he knows what is happening when the subs run.
I don't, and it will take some time to find out.
And his question could mean you should ask a question for the change of BuySel first.

I respect gowflow too, so I will not do anything for the moment, expect set the monitor on for the question.
I nothing happens, perhaps look at it then.
0
 
Naresh PatelTraderAuthor Commented:
Please look into my question as it is being abandon since 8 days.....Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 13
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now