Search:

@wqweto

Hi

Can you show me please how to do it with ZipArchive single class library

Thanks
Steve

Hi All

Could someone please help me out by modifying the code below, I am trying just add a sub folder and files without the full path being in the zip file, please see attach Correct.zip and...

Sorry posted in Wrong section

Hi All

I am trying convert the excel file to PDF via code, but the PDF file is not saving the same has if I choose Adobe PDF in excel if you look at the attached images you see the page size is...

hi

I have copied the contents of the recorded macro from Excel to my vb6 code when using my code the converted PDF file the page size is bigger than if I do it manually by using Adobe PDF printer...

@Magic Ink

Interesting where do I start with that

Steve

@LeandroA
Thank you for your help that worked, but for some reason when converted using the code above the excel page goes cross two pages in pdf file, if I do it manually in excel it saves in the...

Hi All

Could someone please help me to convert the code below to do excel instead of word please.
Original Code

Call ConvertToPDF("C:\Users\stephenbarber\Documents\test.docx",...

@xxdoc123

I still get a Type mismatch on the code below


Private Sub Command1_Click()
SaveJPG "C:\Users\Steve\Pictures\new cam.bmp", "C:\Users\Steve\Pictures\MyJpegPicture.jpg", 100 ' range...

@xxdoc123

Sorry I having trouble where to insert those 3 lines I think there go in the modules file and if I have to delete any other lines. Thank you

HI Steve

Funny that i was just trying that one but getting error with the line in red says runtime error 2145320854 "name not found" but works if i disable that line, i presume it defaults the...

Hi

I am trying to convert a series of bmp files to jpg then delete the bmp files i found this code on this forum, how can i get rid of picture1.picture and replace it using a file path instead for...

@Arnoutdv

Thanks All Good Now

@ChrisE
I will give that ago thanks

regard

steve

@Arnoutdv

Hi
Thanks for your reply

I have tried your post #10 but i get Compile Error: User-defined type not defined on the line in red below.



Private Sub Command3_Click()

HI all

thanks for your help that great all working, But i got a simlar problem with another part of the code below which also fails the second time i tried putting set nothing statements in but i...

Hi ChrisE

It still seems to come up with same error after second time, i have put below more of the code becuase i am doing one file after another 3 times.


Private Sub BoarderButton_Click()
...

Mistake

Hi All

I am trying to create a excel file in vb6 which does work on a click of the command button but if you click the command button second time i get runtime error 462 "the remote server machine...

@Westconn1

Thank you that easy

Hi All
Thanks for your help.

Hi All
Using code below to create a excel file but just wondering why I get a error message saying "Run Time Error '1004' Apllication-defined or object-defined error" when I go up to AJ column and...

@Arnoutdv

First thing I thought of but it wont delete the files in those sub folders

Hi All

I am trying to delete all files in sub folders with the code below, but not delete the sub folders which this code below does.

Regards

Steve


Dim OFS, Sfolder, Subfolder, File,...

@dilettante

HI
I thanks for the code just trying to use it not sure what to do with the code, I am trying to use DeviceId with Label array is this right label2(0) = DeviceID(0) but get error of...

@Arnoutdv

i am using
Label1(0) = sDrives(0)
Label1(1) = sDrives(1)
Label1(2) = sDrives(2)
Label1(3) = sDrives(3)
Label1(4) = sDrives(4)
but if a drive letter disconnects then they...

@Arnoutdv

Yes thats correct

Hi All

maybe Using the code below i want output all drive letters i.e "c:\" = Label 1, "d:\" = Label 2, "e:\" = Label 3, to drive P = label 14, at the moment it's outputting to a List1 under...

@ChrisE

Thank you for your help, works great

Just a thought is there away in the code to make it save has a PDF file?
Regards

Steve

@ChrisE

the textbox's will be pre filled with text I want it to change the word document automated I will properly move the code to a timer so I can tell it when to run so there be no user doing...

@ChrisE

Thank you for that code, how can I change it so it finds and replaces two separate lines in one doc file then save close all in the background thanks

Regards
Steve

@westcoon1

Problem is this code don't seem to work if word is already open

regards
steve

HI all

please could someone help me with this bit of code below, WHICH I am find and replace text in word which works fine, but what I trying to do is search for two different find and replace.
...

Hi westconn1

I am getting a compile error: with first bit if code on line if daAlarm5 < now then LastWeekDayOfMonth(Date + 7, vbSaturday) + TimeValue("10:06:00") says the + should be a = I change...

HI all

Sorry not replied sooner been away I have tried all the codes above they all work apart from they freeze up the VB program while its deleting the folders and theirs a lot of folders to...

HI ChrisE

they are interesting codes you posted, but its the every last Saturday I am having a problem with not trigging correctly on the last Saturday is always 00:00am not set time.

Regards
...

Hi all

Sorry main code meant to say 10:06 has well does now in post 1

regards

steve

HI All

Could someone please look at code below not sure why this is happening, DaAlarm 1 to 4 work fine they trigger at the right times of the week, but DaAlarm5 which should only trigger every...

@baka

Question on your Post#10 when you say root you mean root of the main folder not the root of the drive, where would I put the main folder name so it knows where to delete the subfolders or...

@optionBAse1

Hi I change those that you said and I get error with "DeleteDirectory txtDir.Text" Compile Error Argument not optional


' Delete this directory and all the files it contains....

@Baka
I tried moving those two lines, SetAttr dir_name, vbNormal and RmDir dir_name but did not delete the sub folders only the files within them.

regards

Steve