No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi, I want to write a VBA macro in Word that open an Excel file, save that Excel file to another file (to another name), and then clear all content of the original Excel file. How to do that? Thanks!
|
|
|
Hi, I want to store today value in a string in VBA Word, e.g. today is Oct 04 2012, the string will be = "04102012". Any simple code can achieve that? Thanks! 
|
|
|
Hi, I have created a label template in Word and written a macro to print all records (see code below printAllRecords() and attachments) from an Excel datasource. The problem is when I press F2 (defined function key to print all records in my macro), it prints the 1st page once …
|
|
|
Hi, in Excel I can use below code to call a function via a shortcut, how can I do exactly in Word? Thanks! Application.OnKey "{F1}", "functionToCall" 
|
|
|
Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks
|
|
|
Hi, in Excel I want to use a marco to automate a process so that for all the cells in a Range, if any cell is null, it changes to value 0. How can I achieve that? Thanks!
|