I would like to print out one of my Export Specification templates to give to someone. The Help text says they are stored in the database under Filename_ExportSpecification.
I cannot find a way to access those files to print them out. Is it possible? (I don't want to send them my whole...
Hi, how do I make a calculated field in a query retain the display format I've chosen for it (000000000) when the field is exported? The field is a dollars and cents field, 5.54 for example, that I've created an expression field for which multiplies the value in the table by 100 (to strip the...
I'm using nested vlookup functions like this:
=Sum(vlookup(a2,range1,2,false)+vlookup(a2,range2,2,false)-vlookup(a2,range3,2,false))
and in some cells I'm getting only #N/A because one of the ranges (it could be any of the three) doesn't have an exact match to A2 in it.
How can I make the...
I have a CSS style I'm using for a particular area of my web page and I don't want it to use the link color defined in Page Properties. How can I attach a diffent link style to that section? Thanks for any suggestions.
Hi,
I'm trying to set up a CSS with a position that is in the center of the page no matter how large the browser window is. I know how to set a banner that goes across the entire page no matter how wide the browser window is, but in this case I don't want the text and graphics inside the CSS...
Hi, I want my page to have a textured background not just a solid color. similar to what I see folks who've done web pages in Front Page. Is my only choice for background in Dreamweaver just color, or are there page textures that I can pick from or somehow import into dreamweaver. Should I...
Hi, I need a macro to copy the contents of every non-blank cell in a column to the cell below the non-blank cell, then go to the next non-blank cell and repeat the process. There are about 8,000 rows in the column. Thanks in advance for help. I can use the macro recorder but can't get it to...
I need to remove the banner rows on a print file I imported into Excel. Every 63 rows, there are 9 rows of banner stuff I need to get rid of. The spreadsheet is about 8,000 rows big. I know I should be able to use a macro but am not familiar enough to do it. I can't sort the spreadsheet to...
I am trying to incorporate a user input box in a VB script. The input has to be a number, not a string, in order for the application to accept the data into the field from the user input. This is what I have:
-----------------------------------------------------------
Sub Main
' Generated by...
I'm really stupid at this, but I'm trying to do a VB macro in Emulator software (Reflections) and the thing compiles and seems to work okay except for one little thing. It doesn't put the user's input data that is prompted by the InputBox into the application I'm running the macro in.
The...
HI,
Using relative cell references I've created a macro using the macro recorder, where beginning at cell A1 I copy the contents of A1 to the nine blank cells below it (so I end up with A1:A10 containing the same data. The data changes in every 10th cell of column A, and at each of those...
Hi,
I'm just trying to do a simple macro in Excel where I want to use Shift End Down to get to the next non-blank cell, and then do a copy function of that cell to the range of non-blank cells below it. The number of blank cells varies between the non-blank cells. Even though I use relative...
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.