Can VBA Be Used To Make Web Pages
I know that if you make a documeant in word and save it as a web page you can up load it on to your web space, So can you use some of VBA features to make the page more interactive
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Make Html Pages
hi, is there a way to make a vb application to make html (.htm) pages from some values in text boxes like one text box does the text to be displayer and one has some title and so on?
Combining Adobe Doc But Unable To Make Smart With Regard Length Of Pages To Insert
Okay. So I finally struggled to get something going on combining several Adobe documents into one.
I would like someone to look at my VBA coding to see if I could improve on it.
Please if this is the wrong forum to do this - please inform me.
Basically - I set up everything in the default folder - Documentation under an I: path.
And for testing purposes I just did two documents (14101data.pdf and 14101 - Lanier-Copier5622.pdf) to combine into one called CodeFile.pdf.
These two issues are my problem.
1.) For one where it comes to inserting the first document into the Adobe document (pdCodeFile.InsertPages lngPage, pdFormCapture, 0, 1, 0) if you notice after the pdFormCapture I have 0, 1 <-- denoting that there is only one page in this document to insert.
Also notice for the second document (pdCodeFile.InsertPages lngPage, pdFormCapture, 0, 4, 0), I have 0, 4 <-- denoting that there are four pages to this document to insert.
So thus I'm manually assigning the number of pages to insert and I want to automate that process when I later loop through a SQL query using ADO. I want it to be smart enough to recognize how many pages are there to insert!
2.) The other aggravating thing about this is that I have to start off with a blank Adobe document (CodeFile.pdf). Basically all CodeFile.pdf is a blank page made in a Word doc to help me to start off the process of combining documents. What I would like to do instead is create a new Adobe doc (without any pages existing) and then load only the documents I would need - thus CodeFile.pdf wouldn't even be pulled up in the following process.
Code:
Const DOC_FOLDER As String = "I:dataACCESSDataMainDocumentation"
Dim objCurrent As AccessObject
Dim frmCurrent As Form
Dim strFormName As String
Dim blnNeedToClose As Boolean
Dim Acroapp As CAcroApp
Dim avCodeFile As CAcroAVDoc
Dim avFormCapture As CAcroAVDoc
Dim pdCodeFile As CAcroPDDoc
Dim pdFormCapture As CAcroPDDoc
Dim lngPage As Long
Dim AVPage As CAcroAVPageView
Dim PDPage As CAcroPDPage
'Start Acrobat in the background
Set Acroapp = CreateObject("AcroExch.App")
'Uncomment the following line if you want to watch the program run
Acroapp.Show
Set avCodeFile = CreateObject("AcroExch.AVDoc") 'This is the code file
Set avFormCapture = CreateObject("AcroExch.AVDoc") 'This will be each jpg in turn
'Open the already created code file
avCodeFile.Open DOC_FOLDER & "CodeFile.pdf", "Code File"
Set pdCodeFile = avCodeFile.GetPDDoc
avFormCapture.Open DOC_FOLDER & "14101data.pdf", ""
Set pdFormCapture = avFormCapture.GetPDDoc
Set AVPage = avCodeFile.GetAVPageView
lngPage = AVPage.GetPageNum - 1 'we want page before
If lngPage < 0 Then lngPage = 0 Else lngPage = pdCodeFile.GetNumPages - 1
pdCodeFile.InsertPages lngPage, pdFormCapture, 0, 1, 0
If lngPage = 0 Then pdCodeFile.MovePage 1, 0
pdFormCapture.Close
avFormCapture.Close 1
Set pdFormCapture = Nothing
avFormCapture.Open DOC_FOLDER & "14101 - Lanier-Copier5622.pdf", ""
Set pdFormCapture = avFormCapture.GetPDDoc
Set AVPage = avCodeFile.GetAVPageView
lngPage = AVPage.GetPageNum - 1 'we want page before
If lngPage < 0 Then lngPage = 0 Else lngPage = pdCodeFile.GetNumPages - 1
pdCodeFile.InsertPages lngPage, pdFormCapture, 0, 4, 0
If lngPage = 0 Then pdCodeFile.MovePage 1, 0
pdFormCapture.Close
avFormCapture.Close 1
Set pdFormCapture = Nothing
'close the doc file now with form captures
pdCodeFile.Close
avCodeFile.Close 0
'Exit Acrobat
Acroapp.Exit
'
Set objCurrent = Nothing
Set frmCurrent = Nothing
Set Acroapp = Nothing
Set avCodeFile = Nothing
Set pdCodeFile = Nothing
Set avFormCapture = Nothing
MsgBox "Finished with document!"
End Sub
Thanks for any help regarding the above.
Struggling To Make First Object - Make Class Property = To Combo Box On Form
I have an attachment that I would like someone to take a look at.
If you extract to C: it should create a folder named TEST with the Visual Basic code and a .mdb database.
Basically I've created a Class1 module and would like to make its Name property equal to whatever the Combo1's text comes up as (combo box) on Form1. At the end of the Form Load, it has a message box but it comes up blank. I'm pretty sure that I've got my Property Get sub commands correct in the class.
Depending on the default user initials that come up (gvntUser) then there are certain options allowed based on their profile. Some would be in a read-only category and only certain command buttons would be visible. An example of this is in the Class1 class. Class1.ReadOnly would store the property of true or false.
This of course is first of all based on the initial collection of pulling from orderentry.mdb database and then basing it on the Form1.Combo1.Text field as the Key. But I perceive something is not allowing this to happen as the Form is loaded...
This is just a test program that I'm learning through
On my real program, I have numerous combo boxes - some for salespeople, and some for types of orders.
Any suggestions is much appreciated. Thanks in advance for all of your replies.
How Can I Make A Program That Will Make It So That Windows Recognises A File-type?
can any1 help? i am making a program which uses *.pli files, and i want my system to recognise them instead of showing them up with the white icon with the windows system. I no i can do it by going into the folder options (I have windows 98 btw) but can u get vb to do it 4 u in a program? (This program is going to be distributed among lots of people who all use windows, but not necessarily windows 98, i dunno if that makes any diff.)
thanks
Web Pages
Hello,
I want to open a web page like www.yahoo.com in my application. I used a webBrowser for this. But now I have to implement the back, refresh ...and everything else. Is there an easier way to do this where we can just open it directly using Microsoft Internet Explorer or is the webBrowser the only way to do this?
ICQ Web Pages
I have yet to of yieled any results on how to send ICQ messages and ICQ webmessages using VB6.
Might end up making something such as trillian, and this would come quite handy.
Anyone have any advice?
Web Pages
Is there any web pages I can go to that can give me lessons on vb and examples on how to do stuff??
Web Pages
I'm new to Visual Basic, just started learning, and I am wondering if I want to create a web site using VB do I create it just like I would a program, saving it as an .exe? I have VB 6.0 Professional that came with my book. Would this work? Thanks for the help.
Tab Pages
I would like to have multi tab pages on a form. What is the component for this ?
Pages
using Crystal 8.0 in my APP i want to know how many pages have been printed and to get that number to do some operations.
Vb In Web Pages
Does anyon know if it is possible to up a vb program or exe on the web for use on the web. Not as a download, but to be used as part of a flash presentation. Is this possible?
Pages In RTF
Is't possible to count how many pages i have written in a richtextbox?
Web Pages In VB
I understand that there is a way to create web pages
in vb.
Is it possible?
How?
Web Pages In A VB App
Can anyone explain to me how I could integrate a web object into a VB app? I am quite new to VB programming, and I cannot find any straight-forward approach as yet..
Thanks for any help!
Dennis.
ASP Pages
Hi,
I am just beginning my ASP. Can anyone give me an example created for IIS application through VB6 please
cheers
kis_jobs
VB And Web Pages
I have been set a task to create a web page to go onto our main works web site. The Web Page will just be a simple data entry page with an underlying Access 2000 Database.
Can somebody please, please advise me where to start, I only know VB and have VB6 Enterprise. Can I do this with the DHTML thing, I also have the Programming VB6 book by F. Balena who has a section on creating Remote Data Services, but I cannot work out how to implement this in VB.
I only have until tomorrow to put a simple demo together and have wasted so much time trying fathem it out . . .
many thanks
Work is necessary for man. Man invented the alarm clock.
Use Of DLL In ASP Pages
Hi all
I am having a dll file , i want to use this functionalities of this dll file in my .asp page.
how it is possible...
If possible send me code also....
my personnen mail is abhirangd@indiatimes.com
Thanks....
AbhiDesh
DLL For Web Pages
I am trying to save a graph on a form to memory as a gif so I can print it to a web page. I have to code to generate the object to be saved but am lost on how to save it to memory.
I am new to DLL's so any help would be appriciated.
Roger
Vb To Web Pages
VB code works well on my documents in word2000. If I save the .doc as a web page the code doesnt work. Is there a convertor program to get vb working on html pages or how do I get my vb programs work on my web pages?
Web Pages And VB6
Can someone come up with some code to view or download a web page and make a list containing all the "unique" (filter duplicates)words in the "viewable" text of a page (i.e. no code )?
1) A Textbox named "txtURL" (conatining the URL to which to download from)
2) A command button named "cmdGetWords"
Example: I type in the URL of the page i wish to retrieve all the words from. I press cmdGetwords Button, A "save as" box pops up asking me where i would like to save the list and what filename, with a default ".txt" extension.
Viewable text:
The Quick Brown Fox Jumped Over The Lazy Dog
would write a text file with:
The
Quick
Brown
Fox
Jumped
Over
Lazy
Dog
How Do I Make A HTTP (POST) Call To DLL To Make HTML?
In some applications you see a HTML page in the Web-browser call a DLL
instead of a .asp page.
The result is HTML presented in the browser.
I have seen this working for stand-alone apps as well (Internet Explorer
does the same)
== Questions
1) How does this work?
2) How do I set up the VB code inside the DLL to recieve and handle the
HTTP-call?
3) Is there any sample code available showing me the basics? (A VB project,
or "whitepapers")
4) Dou you recommend .NET or VB 6.0?
== Why?
I want create a small desktop application using HTML-pages to present data
and to present forms.
Via POST, data should be stored via the DLL into a database
== What for?
Applications to be distributed to desktops using Win 98, WinXP and Win2000
Thanks in advance.
Peter
Multiple Pages In One Tab
HI,
I am writing a tab based application and i have run into a problem. My application has 4 tabs. Each tab shows a different data set but some of the lists created can be clicked and this calls up sub set of the main data set. Currently this is opening a new window and displaying the sub set of data in this window. What i want to know is.... is there a way i can keep this in the tab based format and not have to open a new window. Is there a way i can have each tab holding multiple pages?
I dont want to really create a new tab, as this data & sub sets are titled by one of the 4 tabs.
Any help on this would be great.
Thanks
Alv.
ADO Property Pages
Hi,
I am trying to develop a Active X Control using constituent controls like ADO. I have mapped the properties and events of ADO to my control but I also wanted to map the Property page of ADO that is popped up when we try to build a connection.
Is there anyway to do it?? Is there a API/ dll etc so that we can get the list of all the ODBC and OLE Drivers available on the machine???
Get back ASAP...
Thanks in advance
IIS Setup For ASP Pages
After installing IIS to create a default web server for programing and debugging I could not find the folder for web extensions under the local computer node. Does anyone no how to fix? I am running IIS 5.1.
Thanks
OutPrint Pages, From ... To
Hi all
I am making a commondialog view to select to print Word Documents. But I have a problem when I selected the option From Page ... To Page
here's the code I am using
Code:
' depending the way you use to print
Select Case TmpPrint.TypeMethod
Case 0
' All the document
Document.PrintOut Background:=False, Range:=Word.WdPrintOutRange.wdPrintAllDocument, Copies:=TmpPrint.Copies
Case 1
' From ... to ...
Document.PrintOut Background:=False, Range:=Word.WdPrintOutRange.wdPrintFromTo, From:=CLng(TmpPrint.FromPage), To:=CLng(TmpPrint.ToPage), Copies:=TmpPrint.copies
Case 2
' Odd Pages
Document.PrintOut Background:=False, Range:=Word.WdPrintOutRange.wdPrintRangeOfPages, Pages:=Tmpprint.oddpages, Copies:=Tmpprintr.Impresora_Copies
End Select
The error I get is the number 13 (I don't know what'a the traducction in english)
anybody knows what's the problem?
Fetching Web Pages With VBA
Is it possible to fetch web pages with VBA code? Sorry if this is basic, but I've searched the MS documentation and it seems like it's not possible, but I thought I'd aske before I gave up.
Barry Moore
Univeristy of Utah
Dept. Human Genetics
Still Can't Get Rid Of Blank Pages
Hello
I posted a thread last week I think, that involved removing hidden blank pages from a document in word. Someone replied, saying that I should go to format - font - uncheck hidden text, but this did not work, then I got sidetracked.
Just wondering if anyone had any other ideas. The problem is that when you put the page numbers in, it puts them in these pages I can't find, meaning that all the numbers are out of sink.
Any help would be much appreciated.
Cheers
James
How To Count The Pages?
this doesnt work:
Set pagect = ActiveDocument.Bookmarks("page").Count
the compiler errors that 'it' doesnt know the method 'count'
So whaat's the best way to count the pages?
Blank Pages
Can anyone tell me how I would go about search for blank pages in a word document?
Printing Certain Pages
I have a print routine using printDocument and PrintPreviewControl
I would like to be able to print certain pages. Pages 3 to 10 for example.
Appreciate your help
VS 2005
Scanning Pages
I am able to scan documents in vb, but I have a Document typed in MS Word, and i want to scan it and be able to enter text in the blank fields. I'm not wanting to change any of the words on the sheet, but if there is a blank line i want to be able to type in text. Can this be done?
DLL Debugging On ASP Pages
Hi, does anyone have an idea how to debug DLL that are used by ASP pages. Ive tried to set a breakpoint in a source code of that praticular class module in VB6 a run it, but when the page loads (or a method from that dll is called), loading of page does not jump into debug mode whe it reach the breakpoint line, instead the it continues as if no breakpoint was set. Im am currently using MS Windows Server 2003 R2 service pack 1, Enterprise edition and as far as i know, the problem should be in that Service Pack 1. Thank in advance for any help.
Going To Pages In A Multipage
I have next and back buttons but i dont know how to make them go to a certain page in the multipage like if it was on page1 i need to know how to make the next button go to page 2 ect.
Please help.
Open Too Many Pages???
I am running into an interesting problem. I have written a macro that does the following steps. 1) Open a web page in excel (just HTML Tables), 2) as the page opens in a new workbook I move that activesheet to my document, 3) I format the sheet a little, 4) I then copy a range of data and paste it into the original sheet, 5) I then delete the imported tab, and repeat, with a new web page.
The problem is that I have a list of sites I am downloading, and it works perfectly, until about page 175. When I am opening the 175th page (give or take 20) it just stops. It ends. I can narrow it down to the 'Workbooks.Open' statement. For some reason it can't open another page from this macro.
Does anyone know of a reason why it wouldn't be able to handle more? My thought was that even though I was deleting the page each time, maybe Excel was creating an object and It persisted creating some kind of memory leak or something.
Thanks,
--bnpatten
Richmon,VA
Printing Certain Pages
Hey all. I have pretty much finished my workbook, but I want to print out certain pages. This is my code:
Private Sub CommandButton9_Click()
Worksheets("Glider 1").PrintOut
Worksheets("Glider 2").PrintOut
Worksheets("Glider 3").PrintOut
Worksheets("Glider 4").PrintOut
Worksheets("Glider 5").PrintOut
Worksheets("Glider 6").PrintOut
Worksheets("Glider 7").PrintOut
Worksheets("Glider 8").PrintOut
End Sub
What I was wondering is why it wants to save each page in that list? What is the better way to print the above worksheets?
Tia
IIS Setup For ASP Pages
I am using Win XP with IIS 5.1. When I try to run a ASP page (The helloworld.asp Example.) I get the following error.
The server failed to load application '/LM/W3SVC/1/Root'. The error was 'Class not registered'.
Does anyone have an idea of how to fix?
I have search the knowledgebase and can't find any reference to it. Everything I find is for Win 2000 or IIS 5.0 and 6.0. Is there reference material on how to setup IIS 5.1 to create a virtual web server to use ASP pages?
Is there another way to get information from the client web page to the database other than ASP pages? If so where can I find information on how?
Thanks
Saving Web Pages In Vb
im making a HTML editor and im trying to save the code as an HTML file and that works. But the part that get weird is that when i open up that html file i get this in the web page....
{
tf1ansideff0{fonttbl{f0fnilfcharset0 MS Sans Serif;}} viewkind4uc1pardlang1033f0fs17 par par par par par par par par par THIS IS THE BODY par par par par par par par par par }
I dont have any idea what to do!!
Heres my code for saving the page....
Code:
Private Sub mnuFilesave_Click()
'code for saving the file the user is working on
Dim sFile As String
With cdCommon
.DialogTitle = "Save As"
.CancelError = False
.Filter = "Web Page (*.html)|*.html"
.ShowSave
sFile = .FileName
End With
rtbCode.SaveFile sFile
End Sub
any ideas???
Linking Pages
i am writing a program and i want a command button at the end which takes me to the "payment sheet" but i dont have a clue what to put or how to link these pages?!?! any ideas???
thanks jon
Printing Pages?
can some one please tell me how I can print my data on to a page with a title at the top of each page?
PDF - Counting Pages
I am trying to programatically count the number of pages in a PDF but I am getting no where.
Can anyone suggest a way to do it?
Thanks,
Andrew
Property Pages.... How To
Im trying to add some property pages to a control im making.
Now i want to get a list of all the ImageLists available on the form where the control would be located.
How is it possible to do so?
I mean.. i want it to display (NONE) if no imagelists are available, while if some are available, their names will be displayed (all in a combo box)
thanks for your help
Property Pages....
At the risk of abusing your help....
Okay I have the property page of a custom control all set up. I can right click, set properties and be happy with results.
The problem is when I run the program that contains the control... the controls settings reset to default. They don't use the ones I just set in the property page.
I know... I know... I am overlooking something stupid.
|
TRACKER
