After running some queries, my current graphing macros call an excel workbook(Because of the size and scope, I couldn't get Access to cooperate, and I'm much more familiar with Excel). Well, now that I'm done making sure that the graphs work, I'm trying to have it so that it doesn't open the...
As part of a query, I need to be able to select only part of a field for a certain record to see if it fits in with a query (I'm working with a database someone else created, and the powers that be are used to the layout so they don't want me to change it).
So, the only way that I know how to...
I'm trying to have, as part of a macro, a message box that has buttons labeled "Up", "Down" and "Cancel." I'd rather not have it be something where the user types in the command, but with in VB 6.0, I can't find a way to do so within a macro (since it doesn't...
Hey
I'm trying to make the word application window (not the document) go to maximum size, but I've been unable to find a way how to do so. anyone know how to do it?
Brian
I'm writing a VB Macro in Excel that opens up a word document (A form letter), adds the file that the user is working on as the data source, and then prints the merged document. I'm running into a few snags.
The first is that when I try to do this, it tries to reopen the excel spreadsheet...
I'm writing a VB Macro in Excel that opens up a word
document (A form letter), adds the file that the user is
working on as the data source, and then prints the merged
document. I'm running into a few snags.
The first is that when I try to do this, it tries to
reopen the excel...
I have a form letter generated in Word after a table is generated in Excel (based on User input into another sheet in the same Excel Workbook). For some reason, about 70 % of the time, when I do the merge, almost half the data WON'T merge. I have no idea. It seems random as to when it does...
Hey all
While working on a form letter that is generated after a user performs many calculations (Excel -> Word), I encountered slight problem. What happened was I needed more merged areas than Word wanted to create in a header (After starting the initial header, I was going into the file and...
Hey all
I was using Mail Merge (Thanks Dreamboat! ^_^) to put values into a word document from an excel spreadsheet. However, I'm running into a problem with the merge itself. I've been succesful if I've copied all the data I need to merge from the main spreadsheet in a workbook to another...
To be honest, I'm not sure if this post should be here or in the VB6 forum. But, I'm going to try my luck here first, hoping this is just a macro that I can write in excel.
I'm working on a cost spreadsheet, and one of my bosses asked me, to save time, to use excel to generate a word...
After creating some glorified spreadsheets in Microsoft Excel, I started making a users guide for using the spreadsheets I created, as well as helping those in my office who would be using these spreadsheets, use excel more efficiently. Part of that was taking screen shots, and in some of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.