Home |
Search |
Today's Posts |
#1
|
|||
|
|||
2 questions: Using solver in Macro AND converting to Word document to print A3
Hi, Thank you for your wonderful forums and help. Please help me with my two questions below. I tried searching but did not find anything on point. QUESTION 1 Does anyone of you clever ones know how I can include solver in a macro??? What box do I untick???? Right now, Macro doesn’t recognise solver as a function, even though I desperately need this QUESTION 2 I have an excel table which is A3 size in excel and prints to one page. However, I need to put this into a word file. How can I make sure that it still remains one A3 page in the word file please? thank you! -- yendor28 ------------------------------------------------------------------------ yendor28's Profile: http://www.excelforum.com/member.php...o&userid=28697 View this thread: http://www.excelforum.com/showthread...hreadid=483809 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 questions: Using solver in Macro AND converting to Word document to print A3
can anyone help please? -- yendor28 ------------------------------------------------------------------------ yendor28's Profile: http://www.excelforum.com/member.php...o&userid=28697 View this thread: http://www.excelforum.com/showthread...hreadid=483809 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 questions: Using solver in Macro AND converting to Word document to print A3
1) Initial thoughts are that Solver could be referenced by a keystroke macro. If any of the parameters need to be set before hand they could be taken from specific cells on the worksheet, that are predefined by a normal macro. At least the keystroke macro would be a starting point to the final solution 2) Could the paper size be set to custom in Word at 297mm x 410 mm adjusting the margins to the same size they are in excel? -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=483809 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 questions: Using solver in Macro AND converting to Word document to print A3
Does anyone of you clever ones know how I can include solver in a macro???
What box do I untick???? Right now, Macro doesn't recognise solver as a function, even though I desperately need this Hi. Make sure Solver is loaded from the worksheet menu. (Tools | Add Ins | Select Solver). Now, in the vba editor, go to the menu item Tools | Reference.. | and select Solver. HTH :) -- Dana DeLouis Win XP & Office 2003 "yendor28" wrote in message ... can anyone help please? -- yendor28 ------------------------------------------------------------------------ yendor28's Profile: http://www.excelforum.com/member.php...o&userid=28697 View this thread: http://www.excelforum.com/showthread...hreadid=483809 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting Lotus 123 macro to Excell macro | Excel Discussion (Misc queries) | |||
Macro for changing print settings | Excel Discussion (Misc queries) |