I am trying find out what Excel functions I am using in a specific Excel workbook. The workbook is quite large, so i need a VBA macro or utility that will loop through each used cell on every sheet...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 11/12/2007 Grade: A Views: 0
I have a Ms Word document that has docproperties.
ex: {DOCPROPERTY test \* MERGEFORMAT}
How can I use VBA to read the value for this Docproperty and store it as a variable? From my code, ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/...
I am using the GetOpenFileName API to present the Windows Dialog box to a user so he or she can select a folder for my software to deposit files. What flag do I need to set to tell GetOpenFileName...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23175335.html
How would I find the:
- 1st day of the month
- 1st day of the week
- last day of the week
- last day of the month
for example, if I were to search using today's date I would find:
5/1/2008
...
http://www.experts-exchange.com/Microsoft/Development/Visual_Studio_Express/Q_23377668.htm...
I have a form named "SysAcs". On the form, I have a button (Cmd21), and on the buttons onClick event, I'd like to have the form (with the current record) printed to a PDF.
I'm trying to make th...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23622598.ht...
i have this line in a macro i recorded
ActiveSheet.Range("$CBO$1:$CBO$31").RemoveDuplicates Columns:=1, Header:= xlYes
and the macro always works on this range, when trying to reuse it.
so i...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi,
I can't find the Redo keyboard shortcut in VBA.
If there is one, what is it?
If there isn't one, can one be made? How?
Thank you,
Michael
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23879397.html
#1 - I have a Word document that contains many pages. I want to split the pages and save each page into a new Word document using VBA macro. Is this possible?
#2 - My Word document contains cust...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/...
Hi all,
re: Office VBA
I want to step through all the textboxes I have on a form and change the text color. So I have written the following using the "Control" type , but I see that the "Cont...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_235...
Hi,
How do I incorporate a font size or font name variable into a "PageSetup.CenterHeader = ..." line?
What I have so far:
Sub Macro2()
Dim FontSize As Integer
FontSize = 14
...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
