HELP with Excel 2007 Data Collection via Web

OK....This will be long winded. I apologize in advance. I have tried to
come up with a better solution but have yet to do so. Hopefully, there
is a guru out there than can help me.

Here is what I am currently doing:

I run a website ('About Us' (http://www.kartwins.com)) published
through Microsoft Publisher. I enter and store data through that website
using Microsoft Excel. Basically, everything I do is through Excel. I
only use publisher to get it online. A copy and paste scenario from
Excel to Publisher and then Publisher through FTP transfer.

I have run into several tedious, time consuming issues that I am sure
my lack of knowledge is contributing too.

The first...

Is there a way I can "lock" an image file into a particular cell. What
happens now, I insert a picture, get the Excel document to view the way
I want it to look (in Excel). Then copy the file to Publisher or Word
and the image relocates to a different area throwing the original
document all out of proportion.

The second....

Is there a way I can sync data from Excel to my website direct? I use
an FTP file transfer but can really seem to utitlize the publish option
in Excel. It may require another transfer method other then FTP. If it
does, I have no idea what that method is or how to use it.

The third....

I would like to be able to have users go in and enter information web
based and then that info connect with my Master Excel Document which I
can then edit or make changes too once the authenticity of their change
has been verified. I have heard this can be done through Access but I
have little to no knowledge of that program.

SO....there it is. My problems. Hopefully someone here can help. If
not, maybe you can point me in the right direction to receive help?
Thanks in advance.


--
DataFunk
------------------------------------------------------------------------
DataFunk's Profile: http://www.thecodecage.com/forumz/member.php?userid=730
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=127568

No, you can't - at least not without jumping thru some major VBA hoops. I
asked that same question in a private newsgroup a few months ago. What I did
learn how to do was to insert a picture in a comment block. You can set that
to show and it should remain where you put it.

I can't help you with the website aspect tho. I used FrontPage and
Expression Web and never did anything that intense. Sorry.

--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



"DataFunk" <DataFunk.3xabzs.DeleteThis@thecodecage.com> wrote in message
news:DataFunk.3xabzs@thecodecage.com...
>
> OK....This will be long winded. I apologize in advance. I have tried to
> come up with a better solution but have yet to do so. Hopefully, there
> is a guru out there than can help me.
>
> Here is what I am currently doing:
>
> I run a website ('About Us' (http://www.kartwins.com)) published
> through Microsoft Publisher. I enter and store data through that website
> using Microsoft Excel. Basically, everything I do is through Excel. I
> only use publisher to get it online. A copy and paste scenario from
> Excel to Publisher and then Publisher through FTP transfer.
>
> I have run into several tedious, time consuming issues that I am sure
> my lack of knowledge is contributing too.
>
> The first...
>
> Is there a way I can "lock" an image file into a particular cell. What
> happens now, I insert a picture, get the Excel document to view the way
> I want it to look (in Excel). Then copy the file to Publisher or Word
> and the image relocates to a different area throwing the original
> document all out of proportion.
>
> The second....
>
> Is there a way I can sync data from Excel to my website direct? I use
> an FTP file transfer but can really seem to utitlize the publish option
> in Excel. It may require another transfer method other then FTP. If it
> does, I have no idea what that method is or how to use it.
>
> The third....
>
> I would like to be able to have users go in and enter information web
> based and then that info connect with my Master Excel Document which I
> can then edit or make changes too once the authenticity of their change
> has been verified. I have heard this can be done through Access but I
> have little to no knowledge of that program.
>
> SO....there it is. My problems. Hopefully someone here can help. If
> not, maybe you can point me in the right direction to receive help?
> Thanks in advance.
>
>
> --
> DataFunk
> ------------------------------------------------------------------------
> DataFunk's Profile:
> http://www.thecodecage.com/forumz/member.php?userid=730
> View this thread:
> http://www.thecodecage.com/forumz/showthread.php?t=127568
>