Hi there, hoping someone can help. I've been searching and experimenting for weeks with no luck so far.
For my work I was tasked with coming up with an electronic system to gather data from the field. I created a spreadsheet form weighing in about 2mb to be run off a touch Tablet with an atom processor. Its win7 and office 2010 but obviously quite reource limited.
To the issue, once back in the office for checking they want it as a pdf for easy markup and revision so I need to create an output to pdf macro for the whole workbook (fit to page) so the field guys can easily convert the job when done. Issue being, ive no VBA experience and recording the macro makes it attempt to save the file in the same spot and with the same filename whereas i need it to save to the same folder as each excel document each time and be named the job number (excel doc already named). To further complicate things, the atom processor on the tablets we're saving the pdfs on are quite slow (save to pdf is freezing it for a good few min) so im also wondering if theres a faster program to convert them through excel (ex. cutepdf) or out.
If someone can help me out with the macro I'd be over the moon.
For my work I was tasked with coming up with an electronic system to gather data from the field. I created a spreadsheet form weighing in about 2mb to be run off a touch Tablet with an atom processor. Its win7 and office 2010 but obviously quite reource limited.
To the issue, once back in the office for checking they want it as a pdf for easy markup and revision so I need to create an output to pdf macro for the whole workbook (fit to page) so the field guys can easily convert the job when done. Issue being, ive no VBA experience and recording the macro makes it attempt to save the file in the same spot and with the same filename whereas i need it to save to the same folder as each excel document each time and be named the job number (excel doc already named). To further complicate things, the atom processor on the tablets we're saving the pdfs on are quite slow (save to pdf is freezing it for a good few min) so im also wondering if theres a faster program to convert them through excel (ex. cutepdf) or out.
If someone can help me out with the macro I'd be over the moon.
