Search results for query: *

How can i assign macros to multiple buttons in excel? I have a code where i create a toolbar, add a button and assign macro to it, but when i add a second button macro is being assigned to the first button instead of the second. Dim cbar1, myBar ' Set cbar1 = CommandBars.Add(Name:="Future...

Hello, Is there a way when copy or cut data from one Excel sheet into another to preserve the column width, data formats, and print layouts? Thanks

I have a query that uses "Like" keyword. Select Field1, Field2 from Table1 Where (Table1.Field1) Like "*CL B" I do not really like that syntax, can someone tell me what function I can use instead. I tried InStr but it did not work, or maybe I did not use it properly, not...

Hi guys I'm using CR6 and need to export reports into pdf format. Does anybody know the way to do it or maybe a freeware that works with VB or just on its own and does the conversion? Thanks Denko

Hi I need to import a table from one Access database into another using VB5? Thnaks

Hello, How can i replace one line in the Text file with another without deleting any other lines in the file? Example: F444AF02050 03/05/31 09:56:19 188579Y101 XXX 88579Y10118M 188579Y101 BBB 88579Y10118M 188579Y101 ZZZ 88579Y10118M Need to replace date in the first...

Hello What control can I use to browse for a Server/Share name? The same way I use DriveListBox and DirListBox, but they do not allow browsing through my network? Thanks

Is it possible to export a report to pdf format using Crystal Report 6.0? Thanks

Hi there, how can I use Print # statement to create an Output file that is not char delimited. I need every field to start on the certain position like ABX.DV 2.05 2.25 03/27/03 ABX.GV 2.4 2.6 03/27/03 AYE.SA 0.5...

How can I run Access reports from VB executable? Thanks

Is there a way to set Printer Orientation for a Crystal report from VB. My default orientation for printer set to Portrait but report should print in Landscape. On some printers in does not work and want to force Crystal to change orientation from Vb code? Thanks

Can I install and use Visual Basic 6.0 and Visual Basic 5.0 on the same computer?"

I've got pretty complicated report, it contains about 15 subreports, and I force page brakes almost before every sub report. I also reset page counter before beginning of two different groups. I need to create another page counter that just counts pages and ignores any resets. It should work...

I've got pretty complicated report, it contains about 15 subreports, and I force page brakes almost before every sub report. I also reset page counter before beginning of two different groups. I need to create another page counter that just counts pages and ignores any resets. It should work...

I created a formula "As of " + Totext({TableName.Date}) it displays As of 7/3/02. How can I make it to show up as - As of 07/03/2002 ? Thanks

How can I create a sum of sum? I've got 2 groups Department(Gr2) and Company(Gr1). In GF2-Dept. I calculate total Profit/Losses per Dept. In GF1 I need to total Absolute value for Profit/Losses per Company. For Example: GF2 Dept1 3,000,000 Dept2 2,000,000 Dept3 -2,000,000 GF1...

Hi How can I copy all files from on e directory into another? I'm using FileCopy statement but in the loop my pointer to files in first dir does not move. Looks like I'm copying the same file over and over Thanks

Is there way to add through the vba multiple combo boxes ( as many as there are rows, more than 500) to a worksheet?

Is it possible to read multiple (I’ve got more then 100) Excel files and than copy them into one? To be more clear I have Excel files with some sensible data. I'm not sure if I need to open one of them copy the content into Main file close first file, open second one copy into main and so on...

Is it possible to read multiple (I’ve got more then 100) Excel files and than copy them into one? To be more clear I have Excel files with some sensible data. I'm not sure if I need to open one of them copy the content into Main file close first file, open second one copy into main and so on...