Answer Questions

• Buddhist macro script?

  hi peoples im trying to write a macro script that will (in acrobat) open a new bookmark (ctrl+b) the enter a page number 1 2 3 4 etc changing the page as it goes and of course increasing the number value one at a time ctl+b 1, enter, left click, right arrow, ctl+b (previous number, +1), enter, left click, right arrow, atl+b, (previous number, +1) this is the type of thing im looking for. i cant seem to work out how to do the numerical increments :@ if someone would be extremely kind and maybe post a script it makes it would make it very easy for me to paste it in a programin software and execute it. thank you all very much for reading my post mitch Hi This is ...Show All

• Jimmy Koo Runtime error 1004 when adding a seriescole to a chart

  Hi all, this is a very stubborn problem of VBA and I have had to deal with it for years already: Excel version 2003 Error: Runtime error '1004' Unable to set the name property of the series class the macro creates several graphs with multiple seriescollections. Strangely, the first couple of graphs work perfectly! only after a couple of graphs the macro stops at the line ".Seriescollection(ibatch).name = batchfile(ibatch).charseriesname". I can't figure out why, as batchfile(ibatch).charseriesname contains a perfectly fine string Now I have to mention that this problem can also occur on other moments, when assiging other properties, such as the scaletype for the x-axis. Any help is highly apprecia ...Show All

• txteacher saving data in a userform without saving the workbook

  Hi, I have an excel VBA project which interacts with the user entirely through userforms (built it in excel rather than VB since I want to access underlying data from excel sheets for the calculations). How can I export all the data and calculations on a particular userform into a txt file or other file There may be multiple userforms open, and saving will just save one of them, loading will load the data from file, initialise a new userform and load the data into it, all without upsetting the other userforms or the underlying workbook. I'm thinking that I can use one sheet of the workbook as a scratchpad, so when the macro is called, write the userform data onto that sheet, then save the sheet only as a text file by Sheet2.Sa ...Show All

• lamont_23 Select query returns non-existing data

  Hello everybody, I'm trying to match entries in a table up against each other based on a number of criteria (Quantity, Date). Three types of entries exist: Those from source 1, 2, and 3. I'm trying to match data from source 1 with data from source 2 and 3. Some is identical, some is not. In a VBA Script I first select every entry from source 1 (indicated by the field "Datasource"). I then run a While loop. For each entry I run a second select query on the fields I want to match (Quantity, Date). It works OK, ie. as expected, in some cases. In other cases, the quantity is completely off - it's as if Access just invents some random quantity instead of using the one from select query one (the one with source 1 data). What on Earth is w ...Show All

• cheekster what OS are included in MSDN OS subscription?

  Can I find all the flavors of Windows XP, original, SP1, SP2, ... Pre XP if I subscribe to MSDN OS I am trying to build several machines for webapp compatibility testing, and it would be nice if I could download any OS snapshot from MSDN, but it's not clear from the MSDN OS product index that anything previous to latest SP2 is available on disk or download. Any help would be appreciated. From MSDN Operating System Subscription : The MSDN Operating Systems Subscription includes: The Windows Server 2003 product family that builds on the strengths of Windows 2000 Server products to deliver a superior and cost-effective server operating system with increased reliability, availability, sca ...Show All

• GrahamY Text wraping on edit box of dialogsheet

  I have created a form with an editbox and what I need to do is to make the text content wrap rather than continuing on to the right past the size of the box. Any ideas welcome please. With DialogSheets("FormAdd") .EditBoxes("Edit Box 144").Text = "" .Show End With MS Excel 2002 VBA but I am using form and code module templates that I created a few version back, which still work just fine. Rather then reinventing the wheel each time I just recycle and modify to suit but occasionally, I run into a variation - such as this word-wrap or Multiline issue (which now solves the wrapping problem), that presents an obstacle. T ...Show All

• PaTwo Switch graphic on/off in Excel

  Hi all, How do I switch graphics on/off in function codes in excel I'm filling columns with data with my macro and to speed up the process I would just like to show the final result when every cell has its number. For the moment it adds a number to a cell I displays it immediately. Any ideas Best regards Jonas To do it properly, you can set the ScreenUpdate property of the Application to be false and turn it back to true after you finish. Application.ScreenUpdating = False Aslo, you can also turn the interactive mode false which will disable the user input. Application.Interactive = False Hi Jonas A good way to speed up the process is to turn the Calculation mode to Manual while loading the cells, ...Show All

• Chris Honcoop Assign an array to .values and .Xvalues in an excel chart

  Hi, I'm having trouble with assigning arrays to a chart. Below is how I done. Anyone nowing how to make this work     Set MyDispl = Application.InputBox(Prompt:="Select displ.", Type:=8)     Set MyForce = Application.InputBox(Prompt:="Select force.", Type:=8)     Do '''Collects Displ data             plot_disp(i) = MyDispl.Offset(i, 0)             i = i + 1     Loop Until IsEmpty(plot_disp(i))           Do '''Collects force data                ...Show All

• mrplatypus Sorry it may not have been clear as>>

  I have created a program that I plan on disbursing to other people, on this program, I have added a simple form with support info. I would like the text to be a hyperlink for a website and email. Any suggestions thanks no worries, yeah shell mailto works, it's spawns an instance of the browser though but there's an other option for email, and for web pages as well...I'm going with Excel Useforms here. Try a search for hyperlink in the help if your using something else. ActiveWorkbook.FollowHyperlink " mailto:john@yahoo.com " For emails this won't spawn an instance of the browser. With the cursor at first I thought you'd might need to program it but there are properties of the label you can use to set the cursor ...Show All

• shakalama Once copied, can we export as a GIF file?

  How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much     I don't know why everyone thinks it's so hard to copy an image of a region and paste it elsewhere. To copy a chart as a picture: ActiveChart.CopyPicture _ Appearance:=xlScreen, Size:=xlScreen, Format:=xlBitmap To copy a range as a picture: ActiveSheet.Range("B1:C6").CopyPicture Appearance:=xlScreen, Format:=xlBitmap These copy the selections as bitmaps, but you can also copy as a metafile (Format:=xlPicture), and you can copy an Excel range and paste it into Word as a table. You can get this or similar syntax by simply turning on the macro recorder while you manually do w ...Show All

• Charles Tam Interactions with Outlook

  I've developed a workflow application in Excel, which starts off with a form, which users complete whenever they have a data/report request. I then want the application to do two things: From the user end, I want their request to automatically email to me when they click FINISH on the form, so they don't have to worry about sending it themselves. Second, when I receive their request in my inbox, I want my application to look through all my messages, select all new requests, take the information in the email and log it somewhere. I have been successful in achieving both of these things and have tested it on my own machine. The problem is, as soon as Outlook detects that another program (i.e my Excel application) is sending mails on ...Show All

• NozFx Can you tell me why Int(1.4 * 100) = 139

  Can someone help me to find solution: Int(1.3 * 100) = 130 Int(1.4 * 100) = 139  (also  Int(1.38 to 1.49  * 100 ) ) Int(1.5 * 100) = 150 (VBA:Retail 6.0.874) Thanks in advace Hi magicalclick , thank you for replay. It seems CInt() is not "totally fine". Try this: CInt(1.455 * 100) = 146 CInt(19.455 * 100) = 1945 Any ideas For the behaviour of CInt(), I don't see any problem will it. Basically, CInt() is a rounding function. And if you refer to the documentation, you will find that there is a line When the fractional part is exactly 0.5, CInt and CLng always round it to the nearest even number. F ...Show All

• Hussain Saffar Please Help!! Excel driving me mad!

  I didn't know which section to put this in. I have a general excel query, rather than a VBA one. I'm running Excel 2000. I'm creating a series of charts, which are all 3D 100% stacked column jobbies. I have quite a few to create, all looking at identical blocks of data, all the same size and shape. To save me re-formatting the graph each time I create one, I'm simply copying an existing chart sheet and re-defining the source data range. When I get to graph number 4, the look of the graph suddenly changes. The stacked columns appear as thin as spagetti and there's absolutely no explanation or anything I can do about it ! I've even tried copying the chart sheet and re-defining the source data to look at the same range it was looking at an ...Show All

• http200 Open PDF file

  Hi everybody, I'm creating a program in MS. Access but I just want to ask:, how to open *.pdf(extension) file in visual basic access (vba) thanks in advance. :-) Depends what you want to do - if you want to be able to save a PDF into your database (or any other document type) then i have code that allows you to do that and then double clicking on it will open it up in the appropriate program. Is this what you want RHhs. By double clicking the desire path in the data sheet view, the *.pdf file name would be open. For example: Path = \\ipc154\contract\filename.pdf when you double click that path in the datasheet view it will open. Do you have ...Show All

• K. Ravinder Reddy How can I be gold partner

  Our company is ISV partner. How can we be gold partner. I read all the information from partner website. I need short summery of that. The short answer is certify your applicaiton and register your references (3 minimum) then you get on the map for gold partner. FOr more info i wrote a book called "Partnering with Microsoft". Ted Dinsmore ...Show All