Search results
-
O
Save one sheet of a work book as .csv?
Hmm...it's saving the whole workbook and setting focus to that sheet on open for me. -
O
Save one sheet of a work book as .csv?
That still saves the entire workbook though. -
O
Save one sheet of a work book as .csv?
That's the whole thing...we don't want to save anything in the xls. Hence saving the csv. As far as not specifying the ".csv" , thats at the very end of my line of code (which works btw). I get no warnings when I save using my code. It saves the modified xls as a csv. Maybe I'm asking the... -
O
Save one sheet of a work book as .csv?
Well, I got it to work now, except its saving the entire workbook. ThisWorkbook.Worksheets("Var").SaveAs "c:\saveddaily\user" & Format(Date, "mmddyy") & ".csv" That's what I'm using to save where "Var" is the sheet I need to save. -
O
Save one sheet of a work book as .csv?
tried using that and got an error. could it be because im not specifying the save location? -
O
Save one sheet of a work book as .csv?
Hey guys, I have a workbook of 8 pages and on the 6th page, all of the information that the user has input is stored there. Once complete, I would like the user to be able to click a button to save a copy of just page 6 as a .csv to another folder. Is this possible? **Note** Pages 4-8 are... -
O
Save file to each users desktop?
Oh I hear you there! And that was not intended to be an insult, sorry about that :). The way I see it: if you didn't say it, someone browsing this thread may not have known it and never would have, had you not said it! -
O
Save file to each users desktop?
A) The users desktops are locked down. They don't have access to ANY folders or shortcuts, hence saving on the desktop :) B) Vista = for retards. We're not switch to Vista here aaaaaaaaaaaaaany time soon, but thanks! -
O
Save file to each users desktop?
Environ worked! I've used that numerous times, why I didn't think of it...I'll never know!! haha, Thanks guys! -
O
Save file to each users desktop?
Hey guys, I'm trying to save a file to the desktop for all that use it. The problem is, since we're all on a network, and the path to each users desktop is going to be different (ex: C:\Documents and Settings\user\Desktop(where user is going to be different)). Is there a way to modify my... -
O
Save custom file names
Hey guys, I have a spreadsheet here that keeps track of my work through the day. If I want to save the file name with information from a cell, how would I do so? My code: Private Sub CommandButton2_Click() Dim savename As String savename = Range("e6") 'This is the cell with the info I need... -
O
Save to table?
You've hit the nail on the head my friend! As far as record sets, I haven't toyed with them as of yet since i don't know how to. But VBA...I'm slowly coming to grasp that. Any ideas to point me in the right direction? (sorry to ask so much!) -
O
Save to table?
Here we go again! This one should be simple for you guys: I've got a form that requires the user to input the missing information. Some text boxes are pre-populated due to a combo box. My issue is how would I save the information that is entered into a new table? I'll upload the db so you... -
O
Select an Item from combobox
Here is your database with those changes made, just for reference. :) -
O
Select an Item from combobox
Ok, Here's what you want to do: 1)Go to properties of your combo box. Under format, look at the Column Widths field and change whatever is there to 1". 2)Still on your combo box properties, click the event tab. Select After Update. Choose [Event Procedure] then click the box with the "..."... -
O
Select an Item from combobox
Sounds linke you're in the same boat I was in. Check my thread and give that a shot:http://www.access-programmers.co.uk/forums/showthread.php?t=153940 -
O
Populate text boxes from combo box selection???
Yeah, I feel pretty dumb for not realizing it was that simple. HAHA, Thanks a ton! -
O
Populate text boxes from combo box selection???
That is perfect! Thanks so much for this!!